aardappel / procrastitracker

a Windows time tracking application
http://strlen.com/procrastitracker/
483 stars 53 forks source link

Remove duplicates #112

Open lepeter2010 opened 2 weeks ago

lepeter2010 commented 2 weeks ago

Is there a way to remove the duplicate imports from the database? I used the "Merge in" feature after a previous crash and did not realize that the database now contains the previous years' data multiple times: image The bottom part of the stat is the correct data, the top part is incorrect, it shows 30+ hours daily activity for most days.

aardappel commented 1 week ago

There certainly is no way to "unmerge" that data, as merging simply produces the same entry as if you actually had spent twice the time.

The only way to fix this is to add code that halves times for all entries within a date range.

You'd typically make backups before doing merges. Your folder of database files may still contain backups.

lepeter2010 commented 1 week ago

Thank you for the response. Since I realized only several month later that the import was not not perfect, I did not have a chance to restore it from a backup. Some export/import possibility would be useful to handle these kind extra manipulations, Is there a chance that there will be a csv/txt/html/etc export/import option in the tool?

aardappel commented 1 week ago

I certainly don't have time to work on additional such options myself.