Just when I thought I had it figured out... I had some problems trying the hexadecimal route because some of the exhibits would not use the tabs that followed the hexadecimal sequence. So I tried a test with a brand new spreadsheet and when I went to copy the rss link to the page, I noticed it had ody and not od6. This suggests that 3rd digit can be any alphanumerical character. I can try all of those to find the right one, but this seems like a wild goose chase for every exhibit that uses multiple-tabbed spreadsheets and especially if it is deprecated down the road.
*So, does anyone know how to use Exhibit to reference a multiple-tabbed Google spreadsheet (most probably using the &GID=x URL framework?* Thanks, Fred On Thu, Jan 31, 2013 at 2:39 PM, George Adams <[email protected]> wrote: > Fred, > > My exhibit that uses the second sheet is > https://spreadsheets.google.com/feeds/list/0AkgOV8gxmgPadFpENkNmZ2xIaklxS05fQUwxMDZ5a1E/od7/public/basic?hl=en&alt=json-in-script > It uses od7 like you said. Maybe the original way to do this was with odX > but Google changed that. The old way may be depreciated and might just stop > working someday. > > > > On Thu, Jan 31, 2013 at 1:24 PM, Fred Hagemeister <[email protected]>wrote: > >> Thanks, George. Yes, I found that as well. GID gives the tab order, but >> I couldn't get my exhibit to work with using any of the combinations I >> tried. I tried various combinations of the two URL forms (docs.google and >> spreadsheets.google) and with and without the various passed values: >> >> >> https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&single=true&gid=3&output=html >> >> https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&single=true&gid=3&alt=json-in-script >> >> https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&alt=json-in-script >> >> https://docs.google.com/spreadsheet/pub?key=0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc&single=true&gid=3&output=html >> >> >> https://docs.google.com/spreadsheet/pub?key=0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc&single=true&gid=3&output=json-in-script >> >> Long before I ever needed to use a multi-tabbed spreadsheet, I seem to >> recall seeing something someone write and it was using the od6 format with >> substituting somewhere. I don't recall exactly, and my attempts have >> failed so far. >> >> Ugh, I think I figured it out. I just tried substituting the number in >> od6 – I tried od7 and got the 2nd tab. Since I need the 4th tab (GID=3), I >> tried od10 but that didn't work. For yucks, I figured to try hex, and it >> worked, i.e., oda worked (6 + 4 = a(hex) ). >> >> I'm getting the page to appear fine in a browser ( >> https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/oda/public/basic?alt=json-in-script), >> but my exhibit seems to be having troubles, and I think I tried one to >> many things so I need to step back through my html and JS. >> >> Thanks! >> >> Cheers, >> Fred >> >> On Thu, Jan 31, 2013 at 1:45 PM, George Adams <[email protected]>wrote: >> >>> Fred, >>> I did this quite a while ago and it took some searching to figure out >>> how to do it. It doesn't seem to be the same now. These things seem to be >>> changing constantly in Google Docs >>> >>> I went to the spreadsheet and then to the File>>Publish to the web menu >>> item. In the lower half of the dialog box you can get a link to the "all >>> sheets" or pick a sheet. The part that changes is in bold below. "* >>> &single=true&gid=1" *It looks like single=true limits the feed to one >>> sheet and gid=1 identifies the sheet. gid=0 is the first sheet, gid=1 the >>> second. >>> >>> >>> https://docs.google.com/spreadsheet/pub?key=0AkgOV8gxmgPadFpENkNmZ2xIaklxS05fQUwxMDZ5a1E >>> *&single=true&gid=1*&output=html >>> Hope this helps >>> >>> >>> On Wed, Jan 30, 2013 at 8:04 PM, Fred Hagemeister <[email protected]>wrote: >>> >>>> I have an Exhibit 2 site that I need to add another page with >>>> associated data that is in another tab of the same Google spreadsheet. I >>>> can't figure out how to reference this second spreadsheet tab for the >>>> exhibit. I would appreciate any help available. Here is what I have: >>>> >>>> (1) All tabs of my spreadsheet are published. If I go to get the URL >>>> for all sheets with RSS output, I get: >>>> >>>> >>>> https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?alt=rss >>>> >>>> Normally, I take that URL for the RSS output and convert it to the >>>> following for the Exhibit html: >>>> >>>> https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&alt=json-in-script >>>> (2) I can't ask for RSS output for a single tab, but if I ask for >>>> something like PDF, I get the following for the page I want: >>>> >>>> >>>> https://docs.google.com/spreadsheet/pub?key=0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc&single=true&gid=3&output=pdf >>>> >>>> (3) I've tried various combinations of the above, e.g., using >>>> docs.google.com rather than spreadsheets.google.com; using the gid=3 >>>> with the first URL, etc.\ >>>> >>>> >>>> What am I doing wrong, please? >>>> >>>> Thanks, >>>> Fred Hagemeister >>>> >>>> -- >>>> 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?hl=en >>>> . >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> -- >>> 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?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> >> >> -- >> Cheers, >> Fred Hagemeister >> >> -- >> 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?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > 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?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Cheers, Fred Hagemeister -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
