Wild Card - Search for a File in aFolder

schoolkid
schoolkid Member Posts: 103
edited 2009-10-29 in NAV/Navision Classic Client
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

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    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
    matttrax Member Posts: 2,309
    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.
    Matt Traxinger - ArcherPoint
  • schoolkid
    schoolkid Member Posts: 103
    Hi matttrax & kapamarou

    Thanks guys my issue is solved :D

    Thanks again
  • kapamarou
    kapamarou Member Posts: 1,152
    Glad to help out.

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

Categories