I have done this for work but can not provide an example. However, following are the basics of what I did to accomplish what you are talking about: Environment:
- IIS web server - Perl CGI - Perl DBI - Simile Timeline 2.x 1. Configure timeline as you wish it to appear 2. write script to retrieve data from mysql DB (I used form data to let the user select a range of data; 1 day, 1 hour, 1 week...etc) 3. write subroutine in above script to process retrieved data into JSON 4. write subroutine to deliver the resulting JSON to the timeline The Timeline simply calls the CGI script which runs the query, builds the JSON and streams it back to the Timeline. I do this for exhibits as well. In the head of the html page that contains the Timeline/Exhibit, the following line calls the cgi script which does the back end work with the database and JSON generation: <META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE"> <link href=" /cgi-bin/ct_get_data.cgi?query=cc<http://wjwieland.dvrdns.org/cgi-bin/ct_get_data.cgi?query=cc>" rel="exhibit/data" type="application/json" /> Note that the name of the script which does the work in the above is ct_get_data.cgi. While I am using Perl to do the back end work, anything that can connect to your DB will do just fine as long as it runs on your web server. (Many use PHP for this type of work, but ruby, python...whatever will do. Hope that helps. -- You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To view this discussion on the web visit https://groups.google.com/d/msg/simile-widgets/-/4ksd5VJwbwIJ. 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.
