Koral,
Here are the steps that work for me to get a Google Spreadsheet to be a
data source for Exhibit.
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 WORKSHHET_ID in this URL with the ones found above.
https://spreadsheets.google.com/feeds/list/KEY/WORKSHHET_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 Tue, Oct 7, 2014 at 12:24 PM, <[email protected]> wrote:
>
> Hey thanks for your help. I have tried addressing some of these changes
>> and still haven't had any luck. HERE
>> <http://maps.lclc.uic.edu/Indonesian%20Culture.html> is the link to the
>> map (or what should be the map), and maybe you can access the code there.
>> I honestly don't even know where to begin researching the new code from
>> this website: http://api.simile-widgets.org/exhibit/. One of my
>> questions is: do I need a gmap key? And if I do, is the gmap key the same
>> thing as an API key? I added the API key, but I don't know if I was
>> supposed to do that. Also, I'm still not sure if I have the correct
>> spreadsheet URL.
>>
>
> Koral Daniel
>
> --
> 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.
