Monitor folder for New files

[Tyra]

I need to figure out a way to monitor (by monitor I mean that I need FM to have the ability to see if a new files has beed dropped into the folder so that it can begin the export process)a folder that is being used to drop new xml files for importing. The files all have unique file names. such as "Record.6845615.xml". I need to be able to delete the files after I import them. Any suggestions? Prefered plug-ins?

[mr_vodka]

You could do most of this with command line or VB Script, but it will take some work.

As per plug-ins I highly recommend Troi file Plugin. I have used it for years and have found that their products are reliable and great.

[Fenton]

Also, could you clarify what platform this is really for. You say FileMaker Pro Advanced 9 and Mac OS 9. That is not a possible combo. If this is all Mac, then AppleScript has a Folder Action ability for handling files dropped into folders.

Also, you mention file names specifically numbered, but don't say what, if anything, that means to the database. Is there a field that matches that number?

"it can begin the export process)a folder that is being used to drop new xml files for importing."

I don't know what this means. Neither would your English teacher :-]

[Tyra]

Thanks mr_vodka, I was leaning towards Troi also.

Fenton, The Server is FMS9 on a Mac that actually is being put on a new quad core Mac server that will be dedicated to FM. I use FMPA9 on Vista, but there is a cross mix of clients both Mac and Windows enviroment.

The file names are exported from the Web server with the case number as thier file name. And I do have a filed that matches that, but that info is also included in the file it's self.

You took that quote out of context..lol. I was trying to simply clear up any confusion that might arise from not being more specific by what I meant by "monitor" a folder. Did not meant to make it more confusing. Should have wrote if differently. English was always my worst subject. In fact it was the fact that PC's could spell check that got me using them in the first place! As always, I do apprecaite your input.

I am actually going to try two different methods to this problem. First I am going to see if I can get the web developers to set me up a table in MySql that I can form a relationship to, and there by get realtime updates.

The other metheod, which I have almost done, is to use the Troi file plugin to retrieve a list of the current files in the directory and then parse out that list, into fields that I can then use to import the files. Then use Troi once again to delete the processed files.