Page 1 of 1
Purge old data?
Posted: Tue Dec 11, 2012 3:04 pm
by Batrams
Is there a way to purge old data, such as punches etc from years ago?
Re: Purge old data?
Posted: Tue Dec 11, 2012 4:36 pm
by shaunw
Its possible by simply deleting the data like you would anything else in TimeTrex, but we don't recommend it. It doesn't hurt to have decades worth of data in TimeTrex.
Re: Purge old data?
Posted: Wed Dec 12, 2012 7:57 am
by Batrams
I only asked because I was trying the "convert from mysql to postgres" tool and it took several hours to complete, I assume because we have many years' worth of data stored
Re: Purge old data?
Posted: Wed Dec 12, 2012 10:55 am
by shaunw
How are you performing the conversion?
Re: Purge old data?
Posted: Wed Dec 12, 2012 11:02 am
by Batrams
I'm trying to follow the instructions in the tool itself. On the next-to-last step:
7. Run: psql <TimeTrex_Database_Name> < timetrex_mysql.sql.
I'm seeing thousands of messages such as
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of escape in a string literal
LINE 1: ...eturn Code: 0',1352921822),(413312,0,7,'cron',500,'Executing...
It eventually completes but I could not get TimeTrex to work with the converted database. I am trying again in case I goofed up a step. I'm now waiting for the step 7 to complete
Re: Purge old data?
Posted: Wed Dec 12, 2012 11:42 am
by shaunw
Check the TimeTrex debug logs once you finish the migration again, they should help determine what the problem is.