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

dwk

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.

yukon

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,

dwk

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,