Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
GreenTea  
#1 Posted : Monday, May 6, 2013 4:29:14 PM(UTC)
GreenTea

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


admin  
#2 Posted : Tuesday, May 7, 2013 9:51:13 AM(UTC)
admin

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 :)
GreenTea  
#3 Posted : Tuesday, May 7, 2013 10:13:19 AM(UTC)
GreenTea

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).
admin  
#4 Posted : Tuesday, May 7, 2013 4:41:33 PM(UTC)
admin

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.
GreenTea  
#5 Posted : Monday, May 13, 2013 10:29:03 AM(UTC)
GreenTea

Rank: Newbie

Joined: 5/6/2013(UTC)
Posts: 3

Loading the graph takes 5 seconds, but it works.

Graph

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.