Hi, I am using version 1.4.
We deleted some old users, but kept their data.
Now thanks to an unemployment claim we need to recover the daily punch in/out records. I know they are in there, I can see the changes in the audit log, but the name is not in the dropdown to list for the daily time report. Is there a way to recover the details?
Thanks in advance
-Jim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't know if the system deletes this when deleting a user, but in 1.3 there's a db table called `info` that holds the punch in/out information for users. The times are stored as timestamps, so you'll need to convert. Here's a quick query that worked in testing here:
SELECT `inout`, from_unixtime(`timestamp`), `notes` FROM `info` WHERE `fullname`='thenameyouwant' order by `timestamp`
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I am using version 1.4.
We deleted some old users, but kept their data.
Now thanks to an unemployment claim we need to recover the daily punch in/out records. I know they are in there, I can see the changes in the audit log, but the name is not in the dropdown to list for the daily time report. Is there a way to recover the details?
Thanks in advance
-Jim
I don't know if the system deletes this when deleting a user, but in 1.3 there's a db table called `info` that holds the punch in/out information for users. The times are stored as timestamps, so you'll need to convert. Here's a quick query that worked in testing here:
SELECT `inout`, from_unixtime(`timestamp`), `notes` FROM `info` WHERE `fullname`='thenameyouwant' order by `timestamp`
Thanks Mr Thomas, that's what i needed :)