Rank: Newbie
Joined: 1/4/2013(UTC)
Posts: 3
Location: UK
|
Greetings,
Firstly thank you for an awesome piece of software, I've been using it for about a year now and I really enjoy using Manic Time.
Just a quick question. A few of my applications have been incorrectly tracked. For example, a particular java-based application creates a whole new application entry, each time the java-based software is updated.
I wondered if I was able to access the database behind Manic Time, and adjust the totals manually. Or are they all calculated on the fly?
I'm more than happy to pay for this function if it's not currently available.
Many thanks, and a Happy New Year!
Jan
|
|
|
|
|
|
Rank: Administration
Joined: 4/13/2010(UTC)
Posts: 872
|
You can update the database if you like, it is a normal MS SQL CE database. You can use this tool http://fishcodelib.com/database.htmCould you tell me some more about the java problem. Special tracking for Java apps has been on our todo list for a while now, its about time we get to it. Is this publicly available software, something I can try?
|
|
|
|
|
|
Rank: Newbie
Joined: 1/4/2013(UTC)
Posts: 3
Location: UK
|
Hi,
Thanks for the quick response! I actually found a different application that is able to modify the SQL CE database (SQL Compact Toolbox 4.0). For the life of me I couldn't find where the application total time is stored. If you're able to point me in the right direction, I'll gladly purchase the pro version of ManicTime as a thank you.
Regarding the Java application, it's a game called Minecraft. They've not released a new version for sometime, but I might be able to get hold of some older versions for you to test with. I also get the same problem if the Java runtimes get updated, Minecraft is seen as a new application again.
Thanks for your help!
|
|
|
|
|
|
Rank: Newbie
Joined: 1/4/2013(UTC)
Posts: 3
Location: UK
|
I think I've worked it out:
I get the application name from table: Group. Using the "groupid", I modify the "totalseconds" column in table: groupstatisticscacheitem
|
|
|
|
|
|
Rank: Administration
Joined: 4/13/2010(UTC)
Posts: 872
|
I wouldn't touch anything with statistics in title. That gets recalculated all the time, its just a cache so stats work faster.
What I would do. Figure out which groups you want to join. Find the latest one. Then change GroupId of all activities of the other groups to the latest group. So now all activities should point to the latest group.
Then in the Settings, go to clear Stats cache, go to stats and it should recalculate.
Something like that. And please MAKE a backup first :)
|
|
|
|
|
|
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.
