Reading/parsing multiple files in a folder in NAV 2013 R2

dwk
dwk Member Posts: 9
edited 2014-06-09 in NAV/Navision Classic Client
Hi,

I am feeling rather stupid atm... I am trying to read a bunch of .txt files from a specific folder, using a codeunit like this:

Setup i my configuration record, ResponseFile is a variable of type record, sub type File.

Setup.GET;
ResponseFile.SETRANGE(Path,Setup."Import path"+'*.txt');
ResponseFile.SETRANGE("Is a file",TRUE);
IF ResponseFile.FINDSET THEN
BEGIN
REPEAT
//Dialog.MESSAGE(ResponseFile.Name);
UNTIL ResponseFile.NEXT=0;
END;

When I try to run the above code unit, my RTC client crashes with a "The program has stopped working" message...
I would appreciate if someone could give me a pointer as to what to look for.

Comments

  • yukon
    yukon Member Posts: 361
    Hi dwk,

    You can check error under the event viewer. If you want to filter by extension name try to use below sample code
    ResponseFile.SETRANGE(Path,'C:\YourFolder\');
ResponseFile.SETRANGE("Is a file",TRUE);
ResponseFile.SETFILTER(Name,'@*.txt');
IF ResponseFile.FINDSET THEN
REPEAT
  MESSAGE(ResponseFile.Path + ResponseFile.Name);
UNTIL ResponseFile.NEXT=0;

    Regards,
    Make Simple & Easy
  • dwk
    dwk Member Posts: 9
    Hi yokon,

    Ah, I tried the same without the @, but couldnt make it work... thank you!
    yukon wrote:
    Hi dwk,

    You can check error under the event viewer. If you want to filter by extension name try to use below sample code
    ResponseFile.SETRANGE(Path,'C:\YourFolder\');
ResponseFile.SETRANGE("Is a file",TRUE);
ResponseFile.SETFILTER(Name,'@*.txt');
IF ResponseFile.FINDSET THEN
REPEAT
  MESSAGE(ResponseFile.Path + ResponseFile.Name);
UNTIL ResponseFile.NEXT=0;

    Regards,

Categories