Is there a way to have Filemaker server on say a schedule import a CSV file? Any solutions that can detect a new file in a directory and import once detected?
Yes to the import. The "IMPORT" script step is supported on FMS. Keep in mind that FMS can only import from its Documents folder or the Temp folder. So you can't import from any other folder.
As to monitoring a folder no: not a 'live' monitoring. But you can have your schedule run every few minutes.
If you need an actual folder monitor that will kick into action as soon as a file drops into the folder then you'll have to build your own. FMS has an XML API that you can then trigger it to run a script to import that file. Or your tool can already parse the data and just push the data into FMS through the XML, PHP or xDBC APIs.
FMS can import file, but can not check to see if the file exists. You can have FMS run a script and put your files in the Document folder on FMS computer. Then try to import and trap for errors. There are several plugins that can be helpful for you. Otherwise, create a FM Robot that does the job for you. Easier to control then
If it's possible to have the file stored on a ftp server, I prefer to grab the text with insert from url and use a script to add the records and data. Using the ftp errors you can tell if the file doen’t exist. This method runs well on the server.
Retrieving data ...