Using/Capturing data from Mosaic Back of House BOH
I work at a school district in Iowa and we are using the Rise Vision program. We are looking to see if anyone has had luck pulling the menu data from Mosaic BOH (Back of House) program and automatically updating the spreadsheet we have in Google Drive, so the workers don't have to copy and paste the menu items. I could probably write a little JavaScript for that and pull it out but I'm hoping their is an existing solution as I don't have time at work to code.
Well, Community, any ideas?
They would be much appreciated. Thanks!!
-
Hey Trevor,
I've never worked with Mosaic but if there is an XML feed available you could potentially import data from that that using IMPORTXML. Here's a very simple example I put together:
- XML Feed: https://www.w3schools.com/xml/simple.xml
- Spreadsheet: https://docs.google.com/spreadsheets/d/1lO4asJBFf7fwI4awjRE7TMXxWziDUyGW34GwtuVg400/edit#gid=0
Hope that helps.
Thanks
-
Hi Trevor,
What you have open there is the HTML of the page which is different from an XML feed that contains just the data. Some webapps provide an XML feed or JSON feed to export your data but they might not.
If you have a rep with Mosaic I would suggest contacting them and asking if they have a way to export your menu data from Mosaic into a Google Sheet or digital signage software. They might have some ideas as they've probably gotten similar requests before.
Shea
Please sign in to leave a comment.
Comments
3 comments