Purge old data?
Purge old data?
Is there a way to purge old data, such as punches etc from years ago?
Re: Purge old data?
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?
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?
How are you performing the conversion?
Re: Purge old data?
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
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?
Check the TimeTrex debug logs once you finish the migration again, they should help determine what the problem is.