Using/Capturing data from Mosaic Back of House BOH

Follow
Avatar
Trevor Scanlan

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

Comments

3 comments

Sort by Date Votes
  • Avatar
    Shea Darlison

    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: 

    Hope that helps. 

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Trevor Scanlan
    • 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
    Comment actions Permalink
  • Avatar
    Shea Darlison

    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
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post