Purge old data?

Topics brought up by the TimeTrex open source community.
Locked
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Purge old data?

Post by Batrams »

Is there a way to purge old data, such as punches etc from years ago?

shaunw
Posts: 7568
Joined: Tue Sep 19, 2006 2:22 pm

Re: Purge old data?

Post 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.

Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: Purge old data?

Post 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

shaunw
Posts: 7568
Joined: Tue Sep 19, 2006 2:22 pm

Re: Purge old data?

Post by shaunw »

How are you performing the conversion?

Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: Purge old data?

Post 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

shaunw
Posts: 7568
Joined: Tue Sep 19, 2006 2:22 pm

Re: Purge old data?

Post by shaunw »

Check the TimeTrex debug logs once you finish the migration again, they should help determine what the problem is.

Locked