Thanks George; this is useful info.
To the original question:
As far as I know, old exhibits will continue to work; the api hasn't
changed.
What has changed is that it is now more difficult to figure out the
right url to use with *new* spreadsheets, because google has made some
changes to the way sheets get named at creation time. George's
instructions below explain how to figure that out.
I intend to add functionality that will make it easier to access sheet
data, but unfortunately using the easy functionality will also make it
*slower* because exhibit will have to fetch more information from
google. So George's recipe is the way to go if you want the best
performance.
On 11/9/2014 11:04 AM, George Adams wrote:
I have both new and old spreadsheets working with exhibits. The switch
might possibly break an exhibits link to the spreadsheet but if that
happens then the new link can be found.
I recently posted the instructions that do work to get the correct URL
for the new spreadsheets.
Here are the steps.
1. Follow the previous posted instructions for making the spreadsheet
and filling in the data.
The first line has field names like this
Timestamp {location} {label} {latlong} {category} {url} {img}
{summary}
2. The spreadsheet needs to be "Published to the web" using the
File>>Published to the web... menu item and not the "Public on the
web" option for sharing in the Share button dialog box. Do not confuse
this with the blue Share button in the top right side of the document.
Apparently that is something different.
3. Locate the key for your document. This is the 44 character string
in the URL
In this case,
https://docs.google.com/a/hayriv.com/spreadsheets/d/1U58sXa3NVN_Lz9ohGkuTuyRq3pGdWPw8lYXKsjmNeIU/edit#gid=573703946,
it is the "1U58sXa3NVN_Lz9ohGkuTuyRq3pGdWPw8lYXKsjmNeIU"
It can also be found in the publish to web dialog box from step 2 above.
4. Go to this URL
https://spreadsheets.google.com/feeds/worksheets/*KEY*/private/basic
Replace the word *KEY* with the 44 character string found in 3 above.
From the example above go to
https://spreadsheets.google.com/feeds/worksheets/1U58sXa3NVN_Lz9ohGkuTuyRq3pGdWPw8lYXKsjmNeIU/private/basic
5. In the document that is returned search for "/private/basic/"
The characters following the /private/basic/ will be the sheet ID
"https://spreadsheets.google.com/feeds/worksheets/0AkgOV8gxmgPadGV3bTVxREZvb05jNUhxaGNQZ2lFZ2c/private/basic/od6";
In this case the first sheet in the spreadsheet is the od6. This is
the normal first sheet for a spreadsheet made as a spreadsheet and not
created as a on-line form.
In this case,
https://spreadsheets.google.com/feeds/worksheets/1U58sXa3NVN_Lz9ohGkuTuyRq3pGdWPw8lYXKsjmNeIU/private/basic
the sheet ID is o9hkgr4
6. Replace the KEY and WORKSHEET_ID in this URL with the ones found above.
https://spreadsheets.google.com/feeds/list/KEY/WORKSHEET_ID/public/basic?alt=json-in-script
It should look like this
https://spreadsheets.google.com/feeds/list/1U58sXa3NVN_Lz9ohGkuTuyRq3pGdWPw8lYXKsjmNeIU/o9hkgr4/public/basic?alt=json-in-script
This will return the json data that Exhibit can use to display your data.
George Adams
On Sun, Nov 9, 2014 at 9:50 AM, . <[email protected]
<mailto:[email protected]>> wrote:
is this going to break all our old exhibits? all spreadsheets
created in the old version of Google Sheets are being migrated to
the new version
https://support.google.com/docs/answer/6082736?p=old_sheets_migrate&rd=1
On Wed, Aug 6, 2014 at 4:49 PM, George Adams
<[email protected] <mailto:[email protected]>> wrote:
David,
The spreadsheet url in my line of code is followed by /od6/
The od6 usually refers to the first sheet of the spreadsheet.
When I made up a spreadsheet from within drive this was the
case. When I started by making a web form and then had the
form make up a responses spreadsheet the first sheet looked
like this ookxz0b. I never got the spreadsheet with the form
attached to work with Exhibit.
I read quite a few web pages looking for a way to figure out
how to get that reference. I bookmarked some of them but
apparently not the ones that ended up working.
I think this is the page that I ended up using to get the URLs
needed to get the worksheetId
This is the Google API
https://developers.google.com/google-apps/spreadsheets/#retrieving_information_about_worksheets
From that document try
|https://spreadsheets.google.com/feeds/worksheets/key/private/basic
<http://spreadsheets.google.com/feeds/worksheets/key/private/basic>|
Replace the word key with your key
In the document that is returned look for something like this
"https://spreadsheets.google.com/feeds/worksheets/0AkgOV8gxmgPadGV3bTVxREZvb05jNUhxaGNQZ2lFZ2c/private/basic/od6";
In this case the first sheet in the spreadsheet is the od6,
Yours might be different.
Try the URL for the JSON data in my exhibit with both your key
and the sheet reference.
If that doesn't work try this URL from the Google API
|https://spreadsheets.google.com/feeds/cells/key/worksheetId/private/basic
<http://spreadsheets.google.com/feeds/cells/key/worksheetId/private/basic>|
This should return each of the cells in the spreadsheet once
you replace the key and worksheetId in the URL
Also note that the spreadsheet needs to be "Published to the
web" using the File>>Published to the web... menu item and not
the "Public on the web" option for sharing in the Share button
dialog box.
Let me know if this works for you.
George Adams
On Wed, Aug 6, 2014 at 9:36 AM, David Karger <[email protected]
<mailto:[email protected]>> wrote:
How did you figure out the appropriate url? The new
"publish" dialog is giving me a url that I can't easily
convert (e.g., putting my key in your url doesn't work).
On 8/6/2014 4:13 AM, George Adams wrote:
This test version of a Seed Library is running off of a
new Google Spreadsheet.
http://hayriv.com/seeds.html
I did have an exhibit connected to an older Google
spreadsheet and it was easier to figure out the proper
URL to use. I even checked the old spreadsheet and it
still has options for publishing to the web that no
longer exist with the new Google spreadsheets. The option
to publish just a single sheet no longer exists in the
dialog box.
George Adams
On Wed, Aug 6, 2014 at 12:24 AM, David Karger
<[email protected] <mailto:[email protected]>> wrote:
Has anyone figured out how to get an exhibit json
feed from the new/changed google spreadsheets?
--
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]
<mailto:[email protected]>.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
Visit this group at
http://groups.google.com/group/simile-widgets.
For more options, visit
https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
Visit this group at
http://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
Visit this group at
http://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.
--
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.
For more options, visit https://groups.google.com/d/optout.
