During recent implementation got task to fetch the files from specified directory to import in tables using XMLPORT and I was using NAV 2017.
Now in classic version we were able to use FILE and this virtual table was giving us the list of files in specified path by using required filters and we were able to import data from multiple files.
Coming to latest version to find the files in directory I used DotNet variables as follows
From one of the folder I am fetching the filename as follows
Define the variables as follows
Name Data Type Sub type Length
gvDirectory DotNet System.IO.DirectoryInfo.’mscorlib’
gvFile DotNet System.IO.FileSystemInfo.’mscorlib’
gvArr DotNet System.Array.’mscorlib’
i IntegerIn one codeunit write following program
gvDirectory:=gvDirectory.DirectoryInfo(‘E:\WorkingFolder\Target\’);
gvArr:=gvDirectory.GetFileSystemInfos();
FOR i:=0 TO gvArr.Length-1 DO
BEGIN
gvFile:=gvArr.GetValue(i);
Name:=gvFile.Name;
END;Message(Name);
This will help in importing the multiple/sequential’s files in tables using XMLPORT.
Let me know yours feedback.
Cheers