Is manual entry of database records ok to do?

Topics brought up by the TimeTrex open source community.
Post Reply
thinktank32
Posts: 10
Joined: Wed Apr 08, 2015 11:20 am

Is manual entry of database records ok to do?

Post by thinktank32 »

Is it ok if I add an employee record in the employee table within the timetrex database manually? So I would just login to the mysql server and add a record to the employee table. If I do this will there be problems within timetrex when other modules associated the employee table processes the employee record? In other words, are there associations or links between the employee table and other tables that would prevent timetrex from working properly since I just manually added a record to the employee table by directly going to the mysql database?

thanks for your help in advance.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Is manual entry of database records ok to do?

Post by shaunw »

Manually modifying the TimeTrex database is guaranteed to cause corruption and undefined behavior. If you need to programmatically make changes to TimeTrex you should use the API instead. If you just want to add/update employee records you can use the import functionality for that.
http://www.timetrex.com/help/developers ... s/API.html
Post Reply