David, If there are multiple sheets in the spreadsheet there will also be multiple WORKSHEET_IDs listed in the document in step 5 above. I have a Exhibit version2 that uses data only from the second sheet. When things calm down here a bit I will be converting that exhibit to version 3. It will probably take a bit of time to do the conversion since it uses a Google Spreadsheet for the data and is displayed in a Google Site web page using a custom Google Gadget. All the Google Gadgets get run through caja which rewrites the HTML. If everything isn't just perfect with the exhibit code it doesn't work.
George Adams On Sun, Nov 9, 2014 at 10:18 AM, David Karger <[email protected]> wrote: > 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]> 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. > > > -- > 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.
