Using/Capturing data from Mosaic Back of House BOH

Follow

Trevor Scanlan

• September 05, 2018 18:13

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!!

0

• 

  Shea Darlison

  • September 05, 2018 18:52

  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

  0

  Permalink
• 

  Trevor Scanlan

  • September 05, 2018 20:21
  • Edited

  Hey Shea!

  I don't see a way to export the XML. Here is what I see. If I'm misunderstanding your question, I apologize. And thank you for the response. The meal data doesn't appear until the "LUNCH" link is clicked.

   

  

  0

  Permalink
• 

  Shea Darlison

  • September 05, 2018 20:33

  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

  0

  Permalink

Please sign in to leave a comment.