Monitoring a network folder for files to pickup - HOW?

Bryan

I have the need to monitor a network location and import the files found there if they have a certain word in the file name.

For example:
In location C:\Imports
I need to pickup and import all files with 'ImportME' in the file name. The files themselves will be named something like ImportME09142015.csv or ImportME_test_09142015.csv and so on. As long as 'ImportME' is in the file name I need to import it.

Second part of the equation is that I need to do this on an interval. For example: every 5 minutes check the folder for new files.

Any ideas are welcome.

tford

Take a look a the documentation for the CREATE action.

It gives an example:

CREATE Attachment FOR EACH FILE IN 'c:/mydirectory'

Additional explanation:

The action in the fourth example will create as many instances of the Attachment object as there are files in the specified directory.

NOTE: You can use LOOP_ITERATION expression to get values of the current file name, current date or current iteration number, for example:

CREATE TRANSACTION FOR EACH FILE IN 'c:/mydirectory' WITH Transaction.FileName=LOOP_ITERATION

See also the “Aware IM Rule Language Reference” for more details.

You can create some rules that parse the file name & take appropriate actions based on the file names.

Bryan

Thanks Tom a good start. I will see where is takes me.

tford

If you could share your final solution with some detail, that would be great, Bryan.