Rank: Newbie
Joined: 5/6/2013(UTC) Posts: 3
|
Hi, I just bought ManicTime, and I am very happy about that.
Now the day duration time statistics is very empty. :-) I collected a Excel/SCV File with begin/end times of the past few years. Is there a way i could import that into the manicTime Database for the day duration statistics?
Is it safe to add some rows to the Table DayDurationStatisticsCacheItem, or is there more to consider?
Greetings from Switzerland
|
|
|
|
Rank: Administration
Joined: 4/13/2010(UTC) Posts: 872
|
Uf, I wouldn't, but I have no idea how it will behave. If you do, please make a backup of the database before you do. And if you do, let me know how it goes :)
|
|
|
|
Rank: Newbie
Joined: 5/6/2013(UTC) Posts: 3
|
ok, then I can try at least.
Can you confirm if DayDurationStatisticsCacheItem will be overritten/flushed-rewritten from Activity tables, or this entries are permanent? (at least in the current implementation).
|
|
|
|
Rank: Administration
Joined: 4/13/2010(UTC) Posts: 872
|
Honestly, I don't remember. Clear stats in Settings will definetly reset it. I don't know about normal updates, it will probably work since we only update the new activites.
|
|
|
|
Rank: Newbie
Joined: 5/6/2013(UTC) Posts: 3
|
Loading the graph takes 5 seconds, but it works. I used SQL Compact Toolbox (http://sqlcetoolbox.codeplex.com/) to open the database.
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.