Hello David, Thanks for the quick response, sorry for the delay with mine.
Yeah, you're right. I thought that this might be a 'known issue' (although I haven't been able to find any comments about), especially since it is mentioned very explicitly in the documentation that with JSON you shouldn't put quotes around the true/ false AND the fact that you can't really change the way the Google Spreadsheet is transformed into a JSON format (and it thus probably automatically puts quotes around all output)... Anyway, here's the link to my google spreadsheet: the feed: https://spreadsheets.google.com/feeds/list/0Aqp7tPINzPBSdEE2SzhxZWE0WDlobTAydExZSUdIUWc/od6/public/basic?alt=json the spreadsheet itself: https://docs.google.com/spreadsheet/ccc?key=0Aqp7tPINzPBSdEE2SzhxZWE0WDlobTAydExZSUdIUWc&usp=sharing and here's the page with the timeline: https://dl.dropbox.com/u/5783259/TODO_test_1.html Some info on the {durationEvent} column: the first ten items true/false are typed, the rest is from a formula based on the preceding columns (that's why they're in caps). I don't think the caps will make difference, but just to rule it out, I also typed in a few records. There's still much more work to do on the lens etc. but that's all of later concern. I basically copied the code from other examples and am using my real-life wxamples to figure out how this stuff works. Hope you can make some sense out of it and are not too confused by all the Dutch that's in the spreadsheet ;-) greetings, Michaël Op vrijdag 22 februari 2013 16:54:42 UTC+1 schreef David Karger het volgende: > > Michael, these questions are always hard to answer without a concrete > example of the problem. Can you post a link to your broken example? > > On 2/22/2013 7:48 AM, Micha�l Belgraver wrote: > > Hi all, > > > > Well, the subject says it all, I guess. > > > > What I am trying to do is to create a timeline for my project/ to-do > list. > > I'm using the "Google spreadsheet feed to JSON" option to feed my > > Exhibit Timeline. Now, I would like to use the durationEvent to create > > an event that shows the start date, the end date and the deadline > > (latestEnd). > > However, the durationEvent doesn't seem to be recognized in the > > Timeline, and I suspect this is because the json-feed put quotation > > marks around the true/ false values in my spreadsheet. At least, I see > > them when I click the orange scissors and choose 'Exhibit JSON'. > > > > Two questions: > > 1. Is this the right analyses? > > 2. Is there a solution/ work-around for this? > > Please note that I'm bound by a pretty strict environment here at work > > (meaning: can't install anything, have no webserver to use, etc.), and > > I don't want to use one of these 'online converters', since the feed > > needs to be updated real-time. > > > > If it's possible to change to Google feed into xml, that might solve > > the problem too,, but I haven't found a way to do that (automagically). > > > > Thanks for your help. > > Micha�l > > -- > > You received this message because you are subscribed to the Google > > Groups "SIMILE Widgets" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to [email protected] <javascript:>. > > To post to this group, send email to > > [email protected]<javascript:>. > > > Visit this group at http://groups.google.com/group/simile-widgets?hl=en. > > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/simile-widgets?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
