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

Notification

Icon
Error

Options
Go to last post Go to first unread
davidem  
#1 Posted : Friday, June 24, 2011 4:50:21 PM(UTC)
davidem

Rank: Advanced Member

Joined: 6/24/2011(UTC)
Posts: 147
Location: New York, NY

I understand there is a feature to construct a custom timeline by accessing some kind of XML data, but it would seem to be useful to be able to extract timelines from remote dbs via normal SQL.

for example, Our phone system stores our call info (start, end, number, directory lookup) in a db, and it would be useful to pull that in as a timeline via a simple extract. I could construct the query myself, provide the expected column names, etc, I just need the connector.

I'm sure I can find a way to do the query externally, and convert it to the necessary XML on the fly, but that would require yet another running program, or what have you. It would seem that you are already using SQL under the hood to access the CE db, so some of the lifting is probably already done, and the intermediate steps of XML conversion would be unnecessary.

Plus, I can't be the only one who could use this. :)
admin  
#2 Posted : Monday, June 27, 2011 10:44:15 AM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872

I'll put this on our todo list. If we will have some time we will try to add it to the next version.
At the very least we would probably need two fields, one for connection string and one for query.
davidem  
#3 Posted : Tuesday, February 21, 2012 1:05:44 AM(UTC)
davidem

Rank: Advanced Member

Joined: 6/24/2011(UTC)
Posts: 147
Location: New York, NY

was this ever researched or considered for an upcoming version?
admin  
#4 Posted : Thursday, February 23, 2012 9:34:00 AM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872

Still on the todo list, not enough requests...
stevenp  
#5 Posted : Wednesday, June 20, 2012 3:56:30 PM(UTC)
stevenp

Rank: Advanced Member

Joined: 10/27/2011(UTC)
Posts: 39
Location: Ukraine

Maybe it is the right place to ask, I would like to anchor a Counter window to a Focused Window to show Active Application Usage Time viewable in ManicTime. The script is already written in AutoHotkey (AutoIt scripting language), but is ManicTime data available to query/fetch somehow? Maybe with some API calls?

Edited by user Wednesday, June 20, 2012 3:59:06 PM(UTC)  | Reason: Not specified

stevenp attached the following image(s):
query api.jpg (233kb) downloaded 6 time(s).

You cannot view/download attachments. Try to login or register.
admin  
#6 Posted : Saturday, June 23, 2012 10:57:14 PM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872

There is no easy way to get this info from MT directly. The easiest way I can think of is to use server. You can query it for data for one day, then just sum it up.
As soon as we release next version, (we are testing it, probably in the first week of July) we will also post a few code samples which you can use. From there it should be fairly simple.
stevenp  
#7 Posted : Sunday, June 24, 2012 12:13:44 AM(UTC)
stevenp

Rank: Advanced Member

Joined: 10/27/2011(UTC)
Posts: 39
Location: Ukraine

Quote:
You can query it for data for one day, then just sum it up.

What do you mean? I will need to query this every second. Is it a CPU-intensive task to query from server?
admin  
#8 Posted : Sunday, June 24, 2012 7:30:17 PM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872

MT sends data every 30 seconds, so I suggest 30 seconds as a minimum.
stevenp  
#9 Posted : Sunday, June 24, 2012 7:39:43 PM(UTC)
stevenp

Rank: Advanced Member

Joined: 10/27/2011(UTC)
Posts: 39
Location: Ukraine

Great, at least 30 sec, eagerly waiting for sample scripts :)
admin  
#10 Posted : Friday, July 20, 2012 12:43:34 PM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872

Lets start with this

http://www.manictime.com...5/writing-3rd-party-apps

Just for reading it should be fairly simple. You can just use Server.SampleClient with your own front end if you like.

Let me know if you have any questions and we will update the project.
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.