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

Notification

Icon
Error

timeline connector for SQL query
davidem
#1 Posted : Friday, June 24, 2011 4:50:21 PM(UTC)
Rank: Advanced Member

Joined: 6/24/2011(UTC)
Posts: 111
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)
Rank: Administration

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

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)
Rank: Advanced Member

Joined: 6/24/2011(UTC)
Posts: 111
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)
Rank: Administration

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

Still on the todo list, not enough requests...
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.