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