It looks like we are going to update a FileMaker solution daily with a csv file. ODBC is not an option, unfortunately. The thing is we would like to automate this process as good as possible.
Ideally, FileMaker would call an FTP server outside once daily and check for a new csv file. If there is one, then FileMaker should start an import process.
As far as I know, you can achieve this by using HTTP PUT; that is something you need a plugin for. The ones we tried didn't make us happy.
I could imagine the easiest way is to write a Windows batch script that makes sure that the csv file gets stored in a specific location, and FileMaker then can check regularly if the csv file is there and if yes can start the import process.
My question: Is this an appropriate way of achieving my goal? / Any caveats?
Thanks a lot for your input,