Import Script

[Plucky]

Hi

I have a customer that will be emailing me csv files that they have exported from there MIS system so that I can import into my FM solution.

Each csv file will be titled with there unique Job No's.

What I would like is once I receive the email the attachment is extracted from the email and saved into the Import folder I have set up on the desktop.

Then from within Filemaker I run the script that searches for files in the Import folder and imports them into my solution and then deletes the csv file.

I can import a file OK, have entourage save the attachment CSV file into a folder OK

what I can't do is have my FM script select the files in the folder by themselves and then

once imported succesfully have them delete the csv files.

Is this possible or am I going about this the wrong way.

Any help would be much appreciated.