Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-11-09 Thread .
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_migraterd=1 On Wed, Aug 6, 2014 at 4:49 PM, George Adams geo...@hayriverti.org wrote:

Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-11-09 Thread George Adams
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.

Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-11-09 Thread David Karger
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

Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-11-09 Thread George Adams
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

Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-11-09 Thread David Karger
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

Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-11-09 Thread George Adams
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

Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-08-06 Thread George Adams
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

Re: [Simile-Widgets] New Google Spreadsheets URL?

2014-08-06 Thread George Adams
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