Page 1 of 1

Is manual entry of database records ok to do?

Posted: Thu Apr 09, 2015 7:18 pm
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.

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

Posted: Fri Apr 10, 2015 7:55 am
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