Hi all, i am trying to make a script but having no look and hopefully someone can assist with this.
Basically i want fm to watch a folder on a server to import a CSV file created by my web designer from the website payment system.
The website will produce a csv file and fm to check every few mins for a file, if file in the folder then import details and create an order number and auto send an email with the booking details as pdf.
The table im importing to is called Booking and the fields the order will create is
ClientEmail < Send details to this email of ordernumber etc (i will create an invoice layout and perhaps save that as pdf and send that)
When importing it needs to create a new record under
I will be running FM from the Server on my personal Windows Server and have the folder it to watch in
I want filemaker to delete the file after import and i will get the web designer to have the export order to look for file order.txt and if exists name order2.txt etc.
Hope this makes sense and someone can help because this is beyond my expertness
Please no negative posts, im not asking for abuse but assistance.