Thanks for the reply. This forum is a wealth of knowledge. So you are converting your db into xml, but I can't use xml in exhibit when making the searchable fields and filters can I? I was under the impression that we need to use JSON (similar to the google spreadsheet) to be able to dynamically load this stuff through exhibit and into timeline. I do agree that it would be easy to move everything into my db and query from there, but I don't know how to code from mysql into db.
Would you happen to have an example or link that I can take a look at? I believe I can convery mysql into xml and json, but I do not know how to make that output usable by exhibit and timeline. Please help! Thanks! On Sep 23, 10:04 pm, contemplative <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
