• Resolved taastrategies

    (@taastrategies)


    This is the only entry on the page:

    [gdoc key="https://docs.google.com/spreadsheets/d/e/2PACX-1vTART_VwhHUYsR22qVfoSsvQpSn6TC1QJxc-G3nvcU2f-7SI29E2iKLEwt08HlhNhI4vBra1SscOwEK/pubhtml"]

    The key as enclosed within quotes works fine when pasted into the browser address bar.

    Publish to the web settings:
    Link
    Entire Document, Web Page
    Published

    Sharing settings:
    Anyone who has the link can view
    [Not checked] Prevent editors from changing access and adding people
    [Not checked] Disable options to download, print, and copy for commenters and viewers

    Thanks for your help.

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter taastrategies

    (@taastrategies)

    I just tried the same link with the Google Docs Shortcode plugin and it works just fine. I’d prefer to resolve the problem with your Spreadsheet Viewer plugin because it is current and supported.

    Plugin Author Meitar

    (@meitar)

    Thread Starter taastrategies

    (@taastrategies)

    I read all of the threads on the topic, including that one, before posting. Having noted your earlier comments about settings, I detailed all of mine so there could be no question. Further, the Google Docs Shortcode plugin produces the correct result.

    There is a problem in this plugin.

    Plugin Author Meitar

    (@meitar)

    Respectfully, there is something different in your Google Sheet than in others; this is evidenced by the fact that your Sheet’s URL is different than the others I’ve seen before. Specifically, docs.google.com/spreadsheets/d/e/ has a e/ in there, and I don’t know what that means. If you look around, you’ll see no other Google Sheet URLs have this artifact.

    So, either you have simply not set the settings you think you have, or there is something different about your Google Sheet or Google Account that makes your situation different.

    I’ve never seen this e/ before, but the plugin is behaving as expected; it looks for the URL at https://docs.google.com/spreadsheets/d/e/2PACX-1vTART_VwhHUYsR22qVfoSsvQpSn6TC1QJxc-G3nvcU2f-7SI29E2iKLEwt08HlhNhI4vBra1SscOwEK/export?format=csv which is exactly what it’s supposed to do. Google responds with a “No such file,” as you point out, which may mean Google simply doesn’t allow your Sheet to be accessed in the way the plugin needs, or it may mean Google has changed things around in such a way that this no longer works. I can’t find any notice of this on Google’s blogs, though, so I’m at a loss.

    Further, the Google Docs Shortcode plugin does not actually read the data in your spreadsheet. That’s the point. As you undoubtedly know, it “works” by writing an <iframe> into your page and loading the URL you give it in a new document. That’s fine, if that’s what you want. If it’s not, that plugin can hardly be said to be “working” in the way it seems like you mean.

    Finally, on a personal note, in my country, today is a national holiday. You’re not paying me for my time and you’re not entitled to it, either. Yet here I am, looking into this issue you describe. I would appreciate it very much if you spoke to me with a bit more patience in the future. Thanks.

    Thread Starter taastrategies

    (@taastrategies)

    First, on a personal note, I apologize for sounding impatient. I have been on the other end of this (where you are) and I appreciated those who read the previous tickets and provided full details up front as succinctly as possible. I was trying to make the process go smoothly. I did note a number of Resolved tickets here where the user went away without a resolution and I did not want to fall into that camp.

    The issue you raised regarding the e/ led me to study the 3 link forms available from a GSheet: address bar, Share link, and Publish link. All three are different in form. It is the Publish link which includes the e/, apparently because there is an embedding option.

    I had tried all 3 and the Publish link was the last. That clears up the e/ issue which was my bad for not going back to the link from the address bar in my original post.

    Once I understood that piece, I went back to playing with different browsers, the GSheet itself, and the link from the address bar. It refused to work and then suddenly it did in one of the browsers. It was at that point that I discovered that I was losing more than I wanted with building a new table and set about embedding the the table using an iframe and control keywords.

    While I remain mystified regarding the troubles with the address bar link, I do appreciate the help. Please enjoy the rest of your Thanksgiving.

    Earl

    Plugin Author Meitar

    (@meitar)

    It refused to work and then suddenly it did in one of the browsers. It was at that point that I discovered that I was losing more than I wanted with building a new table and set about embedding the the table using an iframe and control keywords.

    Cool. Does this mean you’ve found a situation that works for you? Again, I’m unsure what the plugin has to do with this because it’s behaving as expected.

    It is true that the “Publish” link now automatically includes the new “e/“. I’m not sure when Google made the change, but I can confirm that the new format doesn’t work with this plugin (as of 3/22/18 anyway).

    The trick, as noted by taastrategies, is to take the link from the address bar of the sheet, NOT the Publish to Web link.

    Hope that helps somebody!

    Plugin Author Meitar

    (@meitar)

    The trick, as noted by taastrategies, is to take the link from the address bar of the sheet, NOT the Publish to Web link.

    Just to clarify, this is not a trick, this is now and has always been the instructions written in the readme file and the expected behavior of the plugin.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Sorry, the file you have requested does not exist.’ is closed to new replies.