google spreadsheets with exhibit 3

[lostexpectation]

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

[Piezanowski]

I also have an issue with the Google Spreadsheet loader in Exhibit 3.

The "working" pop-up seems to keep loading without any result.

It was working fine in Exhibit 2.0.

I am using the code below to load my spreadsheet

<link rel="exhibit/data" 

       type="application/jsonp"

       href="https://spreadsheets.google.com/feeds/list/0AhUOTiQczyxHdG54eXNQRHVjODdVRWRxc3cyOWM4U0E/od6/public/basic?alt=json-in-script"

       ex:converter="googleSpreadsheets" />

[David Karger]

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

[Piezanowski]

Thks,

Just to say I am using a map view. 

I tried loading without the map view, only with the facets, but it is still not responding.

[David Karger]

Please post a link to your exhibit.

--
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/-/4EpJcfieKjQJ.
To post to this group, send email to simile-...@googlegroups.com.
To unsubscribe from this group, send email to simile-widget...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en.

[Piezanowski]

Here it is http://ambascience.co.uk/coop2/

and the spreasheets are here goo.gl/M7rko

Even with the large number of items, It was loading fine with Exhibit 2.0.

[David Karger]

(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.

[David Karger]

Try switching to the forked version of the api that I mentioned in my email---that fixes the data-string-parser issue.

To view this discussion on the web visit https://groups.google.com/d/msg/simile-widgets/-/ZP5tRxjDdF4J.

[Piezanowski]

Ok, Import is working fine with your version but I am still unable to render the map view.

Maybe a problem with the map extension.

[David Karger]

Google maps (at least version 2) is working on exhibit3, as can be seen here:
http://simile-widgets.org/exhibit3/examples/presidents/presidents.html

To view this discussion on the web visit https://groups.google.com/d/msg/simile-widgets/-/Z8PJ6KFK2moJ.

[Piezanowski]

The map in the link below is not working on my Google Chrome but is rendering ok with Firefox and IE8.

Same with my map using GMap3.

[David Karger]

Here's one.  I had to make another tweak to get it to work, that hopefully didn't break anything else.  We definitely need to take a look at how to handle date parsing in general.
http://people.csail.mit.edu/karger/Exhibit/Sandy/index.html

On 10/30/2012 3:53 PM, . wrote:

ok thanks, the date converter was the problem, serves me for right trying to give you a link to look at, spent time creating an exhibit to replicate the problem and created more, the presidency exhibit wasn't the one I was actually having problems with it was another, but wanted to try and isolate the problem and created irrelevant ones.  

still can't get to fully work

a working example with google spreadsheets and exhibit 3 would be nice

[Jeff Roehl]

http://people.csail.mit.edu/karger/Exhibit/Sandy/index.html

That's very cool!

 

Thanks
Jeff Roehl
jro...@yahoo.com
(818) 912-7530

---

From: David Karger <kar...@mit.edu>
To: . <expecta...@gmail.com>; SIMILE Widgets <simile-...@googlegroups.com>
Sent: Tuesday, October 30, 2012 12:58 PM
Subject: Re: [Simile-Widgets] google spreadsheets with exhibit 3

--
You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group.

[Thiru]

Hi all,

I built a web page using exhibit 2.2. My web page is http://njadapt.rutgers.edu/resources/climate-adaptation-directory - please scroll to the bottom where the iframe is present which has the exhibit page.I am having browser compatibility issues for this. Data loads from a google spreadsheet.

So I am hoping upgrading to exhibit 3.0 will solve the browser issues. But with 3.0, only the "loading" animation displays along with static HTML. The actual data never loads. 

When I read through this forum and used http://people.csail.mit.edu/karger/Exhibit3/api/exhibit-api.js it seemed to work fine. (Browser compatibility yet to be tested.)

Do you guys think that this is the best location to access the API? What about the official exhibit api? Is it going to get updated with fixes?

Please let me know your thoughts.

Thiru

[Neha Bajaj]

Hi All,

I just started working with exhibit library. I need to make something similar to president map view. So, I thought , I should first try with the same data. I don't what is going wrong, the map appears for a second and then just disappears. and when I check n dev tool, I get errors. I have attached a snapshot, please have a look and let me know what is wrong. Thanks!

[David Karger]

You are linking to code on static.simile.mit.edu which is no longer supported.  You need to use api.simile-widgets.org .  Where did you find instructions to use static.simile.mit.edu?  We need to remove them.

--

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 simile-widget...@googlegroups.com.

To post to this group, send email to simile-...@googlegroups.com.

Visit this group at http://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.

[NEHA BAJAJ]

Hi David, 

Thanks for your response. I found the instructions here http://simile.mit.edu/wiki/Exhibit/Map_View and http://simile-widgets.org/exhibit3/examples/presidents/presidents.html . I still don't understand, what I am supposed to do.

--

Thanks & Regards,
Neha Bajaj

[David Karger]

the instructions at simile-widgets.org are up to date.  there's good getting started documentation here: http://simile-widgets.org/wiki/Getting_Started_with_Exhibit
also http://people.csail.mit.edu/karger/Exhibit/CAR/HandsOn/

[mwra]

I note that all the Exhibit demos here http://simile-widgets.org/wiki/Examples_of_Simile_Widgets#Exhibit, bar the MLB one don't connect. Certainly, all the ones at simile-widgets.org returns what looks like a custom 404 page (there's no mention of 404).

Trying to figure out if it's worth the hassle of gong from the old Timeline to Exhibit as I only really want the timelining functionality.

[David Karger]

Looks like some poor housekeeping during our migration to exhibit 3.  For now, if you replace "exhibit" with "exhibit3" in those urls, you'll get to the right place.  Meanwhile we'll work on fixing the directory structure.

[John Bullington]

I'm not good at this. Trying to just have teachers complete a form and then have the google sheet attached to that form display the data in an exhibit 3 page but can't seem to get the data to display at all. The spreadsheet is public and published (we are a google apps for edu domain). If copied html from other ehibit 3 samples and did substitution but nothing. Can someone look at html code below and advise.

<html> 

<head> 

<title>Shen Educational Website Database</title> 

    <link rel="stylesheet" href="http://www.simile-widgets.org/styles/common.css" type="text/css" /> 

 

 

<link rel="exhibit-data" type="application/jsonp" href="https://docs.google.com/a/shenschools.org/spreadsheets/d/1QaeZO16WXDLcbLerHzZbTghgX7lLIR4qnpVZ7gbAoc8/pubhtml?alt=json-in-script" 

ex:converter="googleSpreadsheets" /> 

 

<<script src="http://people.csail.mit.edu/karger/Exhibit3/api/exhibit-api.js" type="text/javascript"></script> 

  

     <style> 

       body {

margin-left:20%;

margin-right:20%;

       }

       table.show {

           border:     1px solid #ddd;

           padding:    0.5em;

       }

       div.name {

           font-weight: bold;

           font-size:   120%;

       }

 

   </style> 

 

 </head> 

 <body> 

    <h1>Shen Educational Website Database</h1> 

<br /><br /><br /><br /><br /><br /> 

 

    <table width="100%"> 

        <tr valign="top"> 

 

         <td ex:role="viewPanel"> 

 

<div ex:role="view" ex:viewClass="Tabular"

  ex:columns=".url, .grade, .subject, .description, .username" > 

<table style="display: none;"> 

<tr> 

<td><a ex:href-content=".url"><b ex:content=".url"></b></a></td> 

<td><span ex:content=".grade"></span></td> 

<td><span ex:content=".subject"></span></td> 

<td><span ex:content=".description"></span></td> 

<td><span ex:content=".username"></span></td> 

</tr> 

</table> 

</div> 

 

 

  </td> 

 

 

            <td width="25%"> 

  <h2>Search as you type:</h2> 

               <div ex:role="facet" ex:facetClass="TextSearch"></div> 

<br /><br /><br /> 

 <h2>Filter by:</h2> 

               <div ex:role="facet" ex:expression=".grade" ex:facetLabel="Grade(s)"></div> 

               <div ex:role="facet" ex:expression=".subject" ex:facetLabel="Subject(s)"></div> 

               <div ex:role="facet" ex:expression=".username" ex:facetLabel="Reviewer"></div> 

 

            </td> 

        </tr> 

    </table> 

 </body> 

 </html> 

 

[Luis Miguel Morillas]

I thint "?alt=json-in-script"   doesn't work with new google spreadsheets api, does it?

--

luismiguel

[.]

got it working with 

<link rel="exhibit-data" type="application/jsonp" href="https://spreadsheets.google.com/feeds/cells/1LlKMRSp4I7GZLf4V9VHWSa78mxRQbMEjzxG5qH64KyU/1462291997/public/basic?alt=json-in-script"
http://dublinstreams.com/tds/exhibit3/mailinglist.html  so its https://spreadsheets.google.com/feeds/cells/[key]/[index]/public/basic/?alt=json-in-script key is long alpha numeric, index is the 1462291997 bit of https://docs.google.com/spreadsheets/d/1LlKMRSp4I7GZLf4V9VHWSa78mxRQbMEjzxG5qH64KyU/edit#gid=1462291997	ex:converter="googleSpreadsheets" />

--

[.]

ugh i had it working and now its not, getting 'Invalid query parameter value for grid_id.'

[Luis Miguel Morillas]

It raises same error for me. I think google changed ids :)  Try with https://spreadsheets.google.com/feeds/cells/1LlKMRSp4I7GZLf4V9VHWSa78mxRQbMEjzxG5qH64KyU/1/public/basic?alt=json-in-script

Saludos,

-- luismiguel  (@lmorillas)

[.]

why does that work?

[.]

seems to problem with how google is dis-improving things in the new sheets, breaks and then says nothing never explains itself 

create old sheets via http://g.co/oldsheets