Two thoughts regarding this: 1. load your spread sheet data into your mysql db and do all of your queries for you timeline from there. This prevents you from having to maintain two separate sources, and two methods of pulling data into your timeline.
2. as an alternative, add a new band to your timeline. The original band can continue to source the spread sheet, and the new band can be aimed at the mysql db. I use perl scripts to query a mssql db, convert the query results to xml as prescribed by timeline and deliver it to the timeline. My timeline uses a modification of the onLoad that we see in the examples, called reLoad. The reLoad function simply clears out the existing events from the timeline and then fires off a request to the webserver which calls the perl scripts. Incidentally, I do use two bands, both of which reload the timeline dynamically and independently from different scripts, although all from various mssql databases on various machines. This works out very nicely for showing the relationship between event types on a manufacturing lines (downtime vs discarded product...etc). best of luck... wjw On Sep 21, 12:38 pm, Praveen <[email protected]> wrote: > Hello, > > I am a new member of the simile group. First off, I wanted to thank > all of you for the work you have already done. It has been very > helpful in attempting to create my timeline. I have a couple tasks I > want my timeline to do, but I will start with what is probably the > more complicated! > > I currently have timeline running off a google docs sheet. This is > good for the data that changes once a year since i can just change > that in the google docs sheet and it updates automatically. I believe > this uses exhibit to convert to json. I then have some filters and > search which allows some interactive uses. I can give you the link to > this timeline if you want. > > What I am interested in doing is having the standard data as above but > also have information from my mysql database (that the user has > entered on other pages) imported into the timeline as well. This would > probably need to occur in real time so that someone can enter > something in and then see it on the timeline if they wish. Any idea > how to do this? I would also be good if the searches and filters above > from my google docs could somehow extend over this database. Any help > would be appreciated! Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en -~----------~----~----~----~------~----~------~--~---
