AnsweredAssumed Answered

Import script from folder FM15

Question asked by stu@party4less.com.au on Sep 1, 2016
Latest reply on Sep 1, 2016 by Johan Hedman

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

 

ClientNAme

ClientEmail  < Send details to this email of ordernumber etc (i will create an invoice layout and perhaps save that as pdf and send that)

PickupName

PickupAddress

PickupPHone

PickupEmail

DeliveryName

DeliveryAddress

DeliveryPhone

DeliveryEmail

 

When importing it needs to create a new record under

_pk_booking_id

 

I will be running FM from the Server on my personal Windows Server and have the folder it to watch in

c:/FMimport/order.txt

                    order2.txt

 

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.

 

Thanks

Stu

Outcomes