I need help to make like something called monitoring directory.
I have folder, its network based folder, and using FME form or FME Flow or both, i need to make next:
Users will add CSV files in that folder, then that file or files will be add in postgreSql database.
When users change file, it need to be changed in database too.
When users add file , if the file with that name already exists in database , it needs to be replaced with new one
If I needed this I would create it on FME Server using Automations. Set the trigger to Directory modified. Then create a workbench to process the output of the trigger to the database and add this in the Automation.
Thank you for your answer
May i please you to tell me a little detailed about that, because on my FME Flow i don’t have option to set trigger on Directory modified
Thank you in advance
Please see the article Run a Workspace When Data Arrives in a Directory, which is a step by step instruction for this case.