ManicTime Forum
»
Main
»
Feature requests
»
timeline connector for SQL query
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. :)
|
|
|
|
|
|
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.
|
|
|
|
|
|
Rank: Advanced Member
Joined: 6/24/2011(UTC)
Posts: 147
Location: New York, NY
|
was this ever researched or considered for an upcoming version?
|
|
|
|
|
|
Rank: Administration
Joined: 4/13/2010(UTC)
Posts: 872
|
Still on the todo list, not enough requests...
|
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
|
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?
|
|
|
|
|
|
Rank: Administration
Joined: 4/13/2010(UTC)
Posts: 872
|
MT sends data every 30 seconds, so I suggest 30 seconds as a minimum.
|
|
|
|
|
|
Rank: Advanced Member
Joined: 10/27/2011(UTC)
Posts: 39
Location: Ukraine
|
Great, at least 30 sec, eagerly waiting for sample scripts :)
|
|
|
|
|
|
Rank: Administration
Joined: 4/13/2010(UTC)
Posts: 872
|
Lets start with this http://www.manictime.com...5/writing-3rd-party-appsJust 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.
|
|
|
|
|
|
ManicTime Forum
»
Main
»
Feature requests
»
timeline connector for SQL query
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.
