Embed Web page from 3rd-party site into dashboard (iframe or otherwise)

This is the same exact idea that I had last night…I’ve seen the project that @josh was talking about, but have no clue how it was done. I was trying to come up with a way to keep track of a list, on a dashboard. Like a simple chore list for my kids that they could visually see what they’ve done. I guess the best approach would be to make a hyperlink tile to the app, and make changes to the list that way…but what could I do to display the updated content on the dashboard?? And if you have any suggestions on what to use to make a visual “full screen” timer, that would be a life saver too.

I’d love a task list, for the same reason. There’s a couple free task lists that are useful, for example microsoft’s excellent ToDo application.

@Chris_C Are you suggesting that I build/host a custom pages in AWS free tier and then iframe both my initial state dashboard AND my sharptools dashboard into those pages?

Anyone know of an automated capture tool? For example, look at page, take picture, save the page as JPG, and then embed the JPG into sharpTools as a graphic. If you click on the graphic, it modals. In theory, if the screen capture runs regularly, you get the “look” of an iframe

you could possibly use some sort of HTML Template to build the layout that you want, and then automate the data fill in process, and then save the results as a image? I do this with Microsoft Flow for work process all the time…not 100% sure how it could be used here. But hypothetically the end result image could be saved to a url, and viewed as a Media tile on the screen?

1 Like

The example @Chris_C linked to was done using the concepts in the following help article:

The article includes some sample markup. It’s an HTML page with an iframe. In the menu example, it’s basically just a menu that changes which embedded SharpTools dashboard is displayed in the iframe. But we’ve seen examples where multiple iframes were used to mix SharpTools content alongside external content.

There’s a few codesandbox examples linked within the article that you can play around with.

There’s a project by the Google Chrome team called Puppeteer which enables you to take ‘screenshots’ of a page. It would definitely be more of a developer type project though as you’d need to automate the screenshots and storing the screenshots somewhere.

We’ve been bouncing around the idea of Custom Components - the ability to build custom components to integrate third party resources (eg. To Do lists, Weather, Spotify, etc). The same concept could potentially allow you to iframe in other sites directly into a SharpTools dashboard. I’ve noted your feedback under this request and will be sure to post back here if/when we circle back on the idea.

Edit: Custom Tiles are now available! :tada: You can find documentation at the following link:

:man_technologist:t4: Custom Tiles | SharpTools Docs

1 Like

Thanks for the link to puppeteer, I’m going to have to try that. I was looking for screenshots as a service from reading the posts above but most of them have low limits on free tier.

@josh I just grabbed this image from airnow.gov, well the page that this image came from using puppeteer! Thanks for the pointer to that :slight_smile: Now I can add this to my tablet after I figure out how to automatically trim it… unless puppeteer can capture based on x,y coords, that I’ll have to read up on.

image

2 Likes

From a quick glance at their documentation, it looks like you could even select a specific element on the page. A puppeteer script like the following worked for me in the puppeteer demo environment:

const browser = await puppeteer.launch();
const page = await browser.newPage();
await page.goto('https://www.airnow.gov/?city=Frisco&state=TX&country=USA', {waitUntil: 'networkidle0',});
await page.waitForSelector('.aq-dial-container > .aq-dial');  //wait for the element to render
const element = await page.$('.aq-dial-container > .aq-dial'); //get the element as an object
await element.screenshot({path: 'airquality.png'}); // screenshot the element in puppeteer  
await browser.close();

image

If you want to get fancy and clear out the background from the gauge, you could inject a bit of scripting…

Script for transparent gauge
const browser = await puppeteer.launch();
const page = await browser.newPage();
await page.goto('https://www.airnow.gov/?city=Frisco&state=TX&country=USA', {waitUntil: 'networkidle0',});
//inject a script to make everything in the element hierarchy transparent
await page.evaluate(() => {
  document.body.style.background = 'transparent';
  document.getElementsByClassName('marquee')[0].style.background = null;
  document.getElementsByClassName('marquee')[0].style.backgroundColor = 'transparent';
})
await page.waitForSelector('.aq-dial-container > .aq-dial');  //wait for the element to render
const element = await page.$('.aq-dial-container > .aq-dial'); //get the element as an object
await element.screenshot({path: 'airquality.png'}); // screenshot the element in puppeteer  
await browser.close();
2 Likes

Saved me a lot of time trying to use clip: coordinates, size and then having to deal with the background :slight_smile:

@Shai_Dotan, you may be interested to check out the puppeteer @josh mentioned. I remembered you tried to load a COVID19 dashboard page as screenshot to be displayed as part of your dashboard, and the challenge was the dashboard site requires a click before the dashboard is rendered. It seems you should be able to resolve that using page.click(selector) in puppeteer.

I just setup a docker ( buildkite/ docker-puppeteer) running on my NAS to generate the screenshot of the the city’s Covid19 dashboard site every 12 hours, and a media tile pointing to the generated screenshot image on my NAS, and used it in my dashboard.

2 Likes

Now we just need an icon for Coved!

1 Like

This is too much SW for HW guy like me. Can you please make a short movie explaining how to do that ?

@josh, just FYI this works beautifully with Microsoft PowerApps. Not sure how familiar you are with Powerapps, But I have made multiple apps that my company uses. And it hit me that those apps can be ran through a web browser. So I made a chore chart list for my kids to use and it works perfectly. Powerapps can be made to display or do basically anything that you need.

2 Likes

James , can you do the same for me:
קורונה 2020
No need to click nothing, just want the 1st table.

@Shai_Dotan, see below for a quick code example using puppeteer to screenshot the first t able in קורונה 2020, and you may need to update the code based on your needs as this is just a quick reference for you. You will need to install Node.js and NPM on the device where this script is going to be running, ex windows, raspberry PI, and etc. (I am running this on my NAS server.)

const puppeteer = require('puppeteer');
const merge = require('merge-img');
const { default: mergeImg } = require('merge-img');
const pause = (seconds) => new Promise(res => setTimeout(res, seconds * 1000));

let getCovid = async () =>{
    const browser = await puppeteer.launch({ 
        defaultViewport:{width:1200, height:800},
        headless: true,
        args: ['--no-sandbox', '--disable-setuid-sandbox']
    });
    const page = await browser.newPage();    
    await page.goto('https://newmedia.calcalist.co.il/data_journalism/corona/index.html');
    await page.waitForSelector('.info1300');     
    const element = await page.$('.info1300');  
    // await element.screenshot({path: './screenshots/table.png'});
    let imgTable = await element.screenshot();

    await page.waitForSelector('.head-and-sub._50');     
    const header = await page.$('.head-and-sub._50');  
    // await header.screenshot({path: './screenshots/header.png'});
    let imgHeader = await header.screenshot();
    // await page.waitFor(5000);
    // await page.screenshot({path: './screenshots/example.png'});    
    await browser.close();    
    let mergedImg = await merge([imgHeader, imgTable], {direction: true, align: "center"});
    mergedImg.write('./screenshots/merged.png');
    await pause(3600*6); // Run every 6 hours
    await getCovid();
}
//main
(async () => {
    try{
        await getCovid()
    }
    catch (err){
        console.error(err);
    }
})();

-EDIT-
Updated the code example to take screenshots of both the head title and table, and then merge into a single image.

2 Likes

Perfectly Work !! Thanks alot for your support.
To anyone want to use you need:

  1. Make sure you have a folder called “screenshots” in the same folder, so the code can output the image to.
  2. run : “npm install merge-img” to make it works before launching “node ScreenShot.js”
  3. Share your “screenshots” folder to Google Drive , using Google Drive desktop
  4. Use that:
    Dashboard background image not showing anymore - #4 by josh
    in order to make your “merged.png” available in SharTools.
    And if you don’t familiar to Node and NPM watch the following:
  5. YouTube in order to install :
    https://youtu.be/epH81xhS6mk
  6. YouTube in order to create project:
    https://youtu.be/xUqK8VFhu64
2 Likes

If you’re taking votes on this, please count me in! This is functionality I’d also love to have.

1 Like

I just moved this thread into the Feature Requests category, so you can vote on it now. If you refresh the page and scroll up to the top, you should see an option to vote on this post now.

1 Like

Can you share a step-by-step of how to do this for someone who has a technical background, but who’s never used PowerApps?

If you’re looking to display a list, you can do it in Google Sheets and export the table as an image. Pretty sure @josh or @James posted about it before.

1 Like

Unfortunately, I’m specifically looking to do an iFrame.