The Google Gadgets are all iframes in a Google Sites page but if you use the iframe gadget the html code needs to be hosted on a normal web server. The organization didn't have a server where html pages could be hosted so I went the XML gadget file route. It can be a hassle since there is no access to the iframe's <HEAD> that Google generates. You helped me work around that with JavaScripts in the body. The gadgets XML file can be hosted as an attachment to the Google Site so I will stick with that for now.
George Adams On Sun, Nov 9, 2014 at 11:23 AM, David Karger <[email protected]> wrote: > I put my exhibit 3 on a google site just by using an iframe (there's a > gadget for that). Much easier than doing html rewrites, though it's also > more limited. > > > On 11/9/2014 12:21 PM, George Adams wrote: > > 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. > > > -- > 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.
