(You can see the spreadsheets import happening successfully here:
http://people.csail.mit.edu/karger/Exhibit3/demos/presidents/presidents.html
), although the result is disappointing since presidency data is absent
and extensions aren't loaded.
On 10/21/2012 12:45 PM, David Karger wrote:
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.
