Validate File before Importing

[ejpvi]

Greetings Filemaker Gurus,

I was wondering if anyone has setup a server side script that will look at a network location at a scheduled time... if a particular file exists (MyImport.xls) .. import it. (Always in the same format, always named the same thing).

It would be nice if the script could validate the file is present before trying to import... and even better if it could delete the file after the script has run, so it isn't importing the same file over and over again if someone forgets to put the updated one in that location.

Any ideas?

Thanks!

[Agnes Riley]

One way to do this is to import your file to a new table. Then check the records. If anything new, update your data in your import table, if there are new records, add them. There, are of course plug-ins that can check the is file system. But no need to over-complicate things.