Auto import newly created Excel files on server
We have a web Form that is filled out by subcontractors of clients and saved into an online Data Storage. Normally, we convert that to a .csv/Excel file and then import that file into our the separate FMP solution we have for each client. We have 25+ different clients who each have 20+ subcontractors that may fill out a form on a daily basis.
So, in other words, each FMP file (client) we have, they want the information available to them as "real time" as possible. Which means that we have to save each online Data Storage update as a .csv/Excel and import into appropriate FMP file multiple times per day, which is tedious.
What our company would like to do is automate this. We have developed a code to automatically (each hour) take new additions to the Data Storage and save them as a new/separate Excel file on our server in a folder.
Now, I'm trying to figure out how I could script this to import into FMP as automatically and easily as possible? I can't overwrite the data in the FMP file, because the client wants access to it. Since there will be multiple files, each with a different file name, based on the batch order saved, I need to have each file recognized by the script, and then imported (added to the records already brought in).
I could envision this as a button that would "Import new files from server." But again, would only import files in that client's folder that haven't already been brought in. Without all the manual stuff we normally have to do, over and over again each day.