Hello:
This is probably a simple use case to many of you, but I only have basic experience with FME Form and Flow.
One of our programs has the ability to generate standard excel spreadsheets which contain reservation data (Date, Name of Room, Description of Room activity, Organizer contact info)
GOAL: We would like FME to take that excel spreadsheet and post that data as a table on an html webpage.
However, before that html webpage is generated, we would like the user to visit an FME Flow App (? I think) that will allow them to select from a dropdown list of rooms culled from a column in the excel spreadsheet. Once selected and submitted, the app would only show the list of active reservations
Things to note:
This excel spreadsheet data is updated once a day and will only show the current day’s data and will need to be uploaded to FME Flow each day. It’s being stored on a network location.
I’ve managed to create a FME Desktop app that uses Excel Reader > HTMLReportGenerator > HTML Writer to create the html file. It works locally.
Questions:
- What’s the best way to store the excel file? On a network drive? On the same computer as the FME Flow?
- How do I create a page that has that dropdown for submission?
- Where should the HTML file be stored, and how will it be called for viewing after submitting the room?
- How will FME Flow be used? As an FME Flow App? As an FME Flow Automation?
Thank you very much.
Herb Cruz