HTML Widget not working with Embed code

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members.

I am trying to use an embed code from a published to the web Google Spreadsheet.

The link works.
https://docs.google.com/spreadsheets/d/1lQW1pXVcBIH5zH8SZ7uVAHB3fLy8crLPLPllA983pcc/pubhtml/sheet?he...
I edited the code from what google gave me and it works when I click on it. Basically the only thing added in the code is the width and height but I even tried with that removed and it still doesn't work.


<iframe src=https://docs.google.com/spreadsheets/d/1lQW1pXVcBIH5zH8SZ7uVAHB3fLy8crLPLPllA983pcc/pubhtml/sheet?headers=false&gid=1229472188&range=A2:E19”
width=”400” height=”767”></iframe>

A presentation where it doesnt work: http://preview.risevision.com/?type=presentation&id=7203e23a-c910-4238-aa57-d1f52d5eef15

Photo of William Cormode

William Cormode

  • 298 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
William, have also you changed from 'private' to 'anyone can see with the link?"
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
William, how did you try to do that exactly? And are you trying to simply get sheets layout as it is into the presentation? It worked for me. I used HTML widget and simply pasted the embed code from the sheets file between <body> brackets. i did not use any width and height values in the <iframe> as the widget's settings can handle that: http://preview.risevision.com/?type=presentation&id=b766bc1a-9ef4-4576-89a0-b0b4b0bf2338
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
I edited the code a bit. It seem to be working fine for me. See if it is any use for you:

<!DOCTYPE html><html>
<head lang="en">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta charset="UTF-8">
    <title></title>
<style type="text/css">
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
overflow-x: hidden;
overflow-y: hidden;
}
</style>
</head>
<body>
<iframe height="676px" width="400px" src="https://docs.google.com/spreadsheets/d/1We9THz1rcoeIjC0Ir2aDIL-Be0qXtWMqvWnXdmkdgW0/pubhtml?gid=0&am...;
</body>
</html>
Photo of William Cormode

William Cormode

  • 298 Points 250 badge 2x thumb
When I paste that code in It is completely blank when I preview it.

When I look at yours it loads.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
William, are you saying when you preview my link it is showing fine, but when you paste the code into your presentation it shown nothing? If that is the case, then something is blocking the sheets information somewhere.
Photo of William Cormode

William Cormode

  • 298 Points 250 badge 2x thumb
Thats the weird thing. My IP address is completely immune to the filter in our building. And we are a google school so Google is completely unblocked anyway. I already have multiple RiseVision Presentations with Google elements and they work just fine even on filtered devices.
Photo of William Cormode

William Cormode

  • 298 Points 250 badge 2x thumb
Okay. I got it to work with yours now. I had to clean up the code after I pasted it. It cut it off.

And now when I paste my link into that spot it works correctly. Thank you so much.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
You are very welcome William.
Photo of XMedia Dubai

XMedia Dubai

  • 2,786 Points 2k badge 2x thumb
Hi,

Even we are facing issue with HTML and webpage widget both. We display forex rates through web page widget, which is pulling from our external server. Now the rates are not updated on 2 of the displays running in same location. Whereas it is showing updated in another display at same location. Both presentation have same url running. But the one which is not displaying correctly the presentation was created in new editor. 

In another case where i am testing the same forex application as embedded html widget, the rates display in preview, but not on the display client which i have assigned for testing. It goes blank white. 

http://preview.risevision.com/?type=presentation&id=0bd12e80-0a07-40f1-9bf9-ad8d835ec22d

I also found out that though the chrome version running in the system shows 54, it's not updated in display details.

Operating System: 32-bit Microsoft Windows 10 Home
Player Version: RisePlayerElectron 2016.11.17.19.50

Viewer Version: 2-01-201611251721

Browser Version: Chrome 52.0.2743.82

PS: Web page widget issue i was able to resolve. But still face problem with HTML embedded widget for above presentation.

regards
Prakash
 
(Edited)
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Prakash,

If I understand you correctly, you have the same Presentation, but one you work on in the older editor, and another you work on in the new editor?

And the one that is not working correctly was created and is managed in the older editor?
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Prakash,

is it possible there is a block with the code in the HTML Widget, or something configured incorrectly? That's weird that the Web Page would work, but the HTML Widget would not. Is it possible there is a cache issue occurring here? Or possibly some authentication being required?
Photo of XMedia Dubai

XMedia Dubai

  • 2,786 Points 2k badge 2x thumb
Robb,

I dont see any issue as such with code, because it would not work in preview then. Also its not working as webpage widget also. Can you have a look at the presentation and html code in it? The webpage link for the same is below

http://37.188.98.24:5000/xmltoTable.html

I am using the same code in embedded html widget.

regards
Prakash
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Prakash,

I am seeing some different information in the Dev Console on the Display than I am in preview. Let me discuss this with the team over here, and I will get back to you.

Thanks!
Photo of XMedia Dubai

XMedia Dubai

  • 2,786 Points 2k badge 2x thumb
hey Robb,

were you able to find anything on this?

regards
Prakash
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Prakash,

My apologies on the delay. I'm going to reach out and see if I can get some assistance regarding this. I will let you know what I discover shortly. Thanks!
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Prakash,

I was able to determine the reason here! It looks like that page is using a javascript function that is not widely supported. It is an Object.values error: https://www.chromestatus.com/feature/5710160244768768

It works in Chrome, but not Chromium, which is why it works in preview, but not on the Display. 
This function is not well supported in browsers yet, and our viewer browser falls into that category unfortunately.

Here is another URL all about this function that you may find helpful, specifically around what is supported and what isn't: https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Global_objects/Object/values#Browser_compatibility

I hope that helps!
Photo of XMedia Dubai

XMedia Dubai

  • 2,786 Points 2k badge 2x thumb
Robb,

The code works fine. But past weeks we facing issue. The xml data is not displayed correctly. Even if the xml data changes, it still continues to display old cache data. I have kept the duration of html widget for 30 sec in both presentation and schedule. It doesnt refresh the data instead plays from cache.

Previously we had a server host and we used a webpage widget. But we have done away with that setup now.

regards
Prakash
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Prakash,

Are you still using that javascript function that is not widely supported?
Photo of XMedia Dubai

XMedia Dubai

  • 2,786 Points 2k badge 2x thumb
No made changes to script. This the presentation
http://preview.risevision.com/?type=p...
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Prakash,

Sorry, I just want to confirm, you are saying you DID make changes to the script? Were they to that javascript function that is not widely supported in browsers yet?
Photo of XMedia Dubai

XMedia Dubai

  • 2,786 Points 2k badge 2x thumb
Hi Robb,

Yes the first issue i had regarding the HTML code was the script working in preview but not on actual display. That's when you suggesting fine tuning the javascript, which was made to the script and the code started working on display. Now the problem is xml data is getting fetched from cache instead of updating it from the feed directly. Each time i refresh it displays random data from last cache.

regards
Prakash
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Hmm...can you send a link with this Presentation to support@risevision.com so I can take a look and see if I can recreate?

Thanks!
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Thanks! I'll let you know if I can determine anything.