Wild Card - Search for a File in aFolder

schoolkid

Hi,

I want to import the xml files into NAV automatically,

My POS system generates XML files and drop them in a particular folder with a Time Stamp,
like this for example

Pos_28102009122521.xml
Pos_28102009123525.xml

what i need to do is to search for the XML files that are in the folder like

c:\inbound\Pos_*.xml, which will pick the files 1 by one and then import them into NAV.

Any help would be great

Thanks

kapamarou

There is a virtual table called file. (You can see it if you create a new form and move to the last tables). If you apply a filter like the folder name it will show you the contents of the folder and you can loop through them.

matttrax

There are some issues with the file table that you'll want to read up on. For example it doesn't always refresh the files it sees automatically. Works well for the most part, though, and it is your best bet.

Also look into the EXISTS function.

schoolkid

Hi matttrax & kapamarou

Thanks guys my issue is solved

Thanks again

kapamarou

Glad to help out.

Also notice the issue that matttrax mentions, and search the forum for this, to avoid problems with this approach.