I've started looking at this; it's unveiled a number of separate
problems. I have suggested fixes at the end of the story.
The simplest problem was the reported one: a failure to include the date
conversion function. I've fixed this with an instance of the api at
http://people.csail.mit.edu/karger/Exhibit3/api/exhibit-api.js
Unfortunately this was only the tip of the iceberg. In fact, it wasn't
even very important. In your spreadsheet, you've created duplicate
"birth" and "death" columns, and filled them with proper iso8601-format
dates which exhibit doesn't need to convert. So if you'd just deleted
the "traditional format" date columns, then the iso8601 converter
wouldn't have been needed and you wouldn't have seen the error. As it
is, even with the parsing corrected, your newer columns, since they have
the same column headings, overwrite the traditional date columns.
With the data conversion problem out of the way, the next problem is
that your spreadsheet does not contain "presidency" data. Presidents
don't have their own indates and outdates; instead they have
presidencies where each presidency has an indate and an outdate (this
was forced upon us by Grover Cleveland, who had the gall to be elected
for two non-contiguous terms). Your spreadsheet only holds the
presidents, and not their presidencies, so when exhibit tries to look up
the presidency data it finds nothing. That is why none of the
days-in-office etc. statistics are showing in the tabular view.
Finally, there appears to be a problem with extension loading. Something
is preventing the timeline (and possibly the map) from signaling that
loading is done and allowing exhibit to proceed. But if you remove the
timeline (and possibly the map) you can at least verify that data is
being properly loaded by looking at the tabular view.
So, if you'd like to progress on this issue, you should do one of the
following:
Option 1 (skip date parsing)
* remove the "traditional date" columns from your spreadsheet
* add another spreadsheet (or json file) providing the "presidency" data
that is missing (with dates in UTC of course)
* verify the released version of exhibit works on this data (in tabular
view) without the extensions
* check if perhaps its extension loader will work with the other
problems solved
Option 2 (try to use date parsing)
* use my fork of the exhibit api at
http://people.csail.mit.edu/karger/Exhibit3/api/exhibit-api.js
* remove the UTC data columns from your spreadsheet
* add another spreadsheet (or json file) providing the "presidency" data
that is missing (with dates in traditional format if you like)
* verify the forked version of exhibit works on this data (in tabular
view) without the extensions
* check if perhaps its extension loader will work with the other
problems solved
On 10/14/2012 1:52 PM, lostexpectation wrote:
trying to use google spreadsheets with exhibit 3
trying to use example where nothing else changes, can't really find
one
so converted an exhibit 3 example
http://www.simile-widgets.org/exhibit3/examples/presidents/presidents.html
data
https://docs.google.com/spreadsheet/ccc?key=0AqAEiinGYynOdFd3dDRBWFJXUllSRnZzZEYxNEVTT3c
swapping indatae outdate for birth death just to have something on the
timeline
http://dublinstreams.com/tds/exhibit3/presidents3.html
but getting an error
Uncaught TypeError: Object #<Object> has no method
'makeISO8601DateString' exhibit-scripted-bundle.js:1
Exhibit.Importer.JSONP.GoogleSpreadsheet.transformJSON
ps some of the exhibit3 examples have the old 'ex:label' instead of
'data-ex-label' will the old way still work if trying to convert
previous exhibits
--
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.
