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, . <expectationl...@gmail.com
<mailto:expectationl...@gmail.com>> 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
<geo...@hayriverti.org <mailto:geo...@hayriverti.org>> 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
<kar...@mit.edu <mailto:kar...@mit.edu>> 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
<kar...@csail.mit.edu <mailto:kar...@csail.mit.edu>>
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
simile-widgets+unsubscr...@googlegroups.com
<mailto:simile-widgets+unsubscr...@googlegroups.com>.
To post to this group, send email to
simile-widgets@googlegroups.com
<mailto:simile-widgets@googlegroups.com>.
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
simile-widgets+unsubscr...@googlegroups.com
<mailto:simile-widgets+unsubscr...@googlegroups.com>.
To post to this group, send email to
simile-widgets@googlegroups.com
<mailto:simile-widgets@googlegroups.com>.
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
simile-widgets+unsubscr...@googlegroups.com
<mailto:simile-widgets+unsubscr...@googlegroups.com>.
To post to this group, send email to
simile-widgets@googlegroups.com
<mailto:simile-widgets@googlegroups.com>.
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
simile-widgets+unsubscr...@googlegroups.com
<mailto:simile-widgets+unsubscr...@googlegroups.com>.
To post to this group, send email to
simile-widgets@googlegroups.com
<mailto:simile-widgets@googlegroups.com>.
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
simile-widgets+unsubscr...@googlegroups.com
<mailto:simile-widgets+unsubscr...@googlegroups.com>.
To post to this group, send email to
simile-widgets@googlegroups.com
<mailto:simile-widgets@googlegroups.com>.
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 simile-widgets+unsubscr...@googlegroups.com
<mailto:simile-widgets+unsubscr...@googlegroups.com>.
To post to this group, send email to
simile-widgets@googlegroups.com
<mailto:simile-widgets@googlegroups.com>.
Visit this group at http://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.
