Google Spreadsheet Layout XML File Located On Internal Web Server

  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hello,
I have a question regarding the storage of a layout file that is used by a Google Spreadsheet gadget.  I have successfully set up multiple displays which are using multiple Google Spreadsheet gadgets, all using custom layouts.  The problem that I am running into is that the only way that I can get these custom layouts to function is by hosting the xml layout file on a web server that is external to the company.  If I attempt to pull the xml file in from an IIS server that is internal to the company, I am never able to get the gadget to display anything, both in a preview and via the player.  I am able to host images and other files on the IIS server and use them within the presentations, but it is just the xml files that are giving me fits. 

I have verified that I am able to access the xml files by using the link in a browser, which successfully returns the contents of the files.  I have also verified that I can access the Google Spreadsheet by checking the 'use default' checkbox, which then will display the data in the spreadsheet, but in a not-so-nice layout.  In addition I have verified that the xml file that does work when hosted externally, is the same as the file that is hosted internally. 

I am hoping that someone may be able to help give me some insight as to if this is a known issue or maybe point me in the right direction in order to remedy the issue.


Thanks in advance!
Jamie

Photo of Jamie Simms

Jamie Simms

  • 300 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Hi Jamie,

When you have the Spreadsheet Gadget set to use the custom layout on the internal server, can you go on the Display and open the Developer's tools (press 12), and go to the Console tab?  Is there anything listed on that tab relating to the layout, or the spreadsheet gadget?

Thanks.
Photo of Jamie Simms

Jamie Simms

  • 300 Points 250 badge 2x thumb


Hello Neal,
When I go into the console tab within the dev tools, I do see the following error:


Uncaught TypeError: Cannot call method 'getElementsByTagName' of undefined Spreadsheet.min.js:30


Thanks,

Jamie

Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Hi Jamie,

I'm seeing the same thing when I try a custom layout on an internal network. If I make that same file available to the outside world, it appears that it does indeed work.

I'm looking to see right now if I can get confirmation from a developer that the file does indeed need to be available externally, but based on my immediate findings, it does appear that way.

Thanks.
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Jamie,

The layout file needs to be accessible to the outside world so that the Gadget can make use of it.

If you need anything further, please let us know.

Thanks.