Reading all the files in a folder from Navision pr

Business Central/NAV Developers Forum
1

Hi All, We can read a file from a file folder and import the data into Navision. This is normally achievable by using dataport and providing the path in the filename property. (which is hardcoded ). However i do not want to use hardcoded file name , instead wants to read the available fiels in the specified file folder ( Only the folder name and path are fixed not the file name ) and also if there are ‘n’ no of files existing in the above folder then i have to read all the files one by one and import the data in each file into Navision. All we want to do is … read all the files put in this file folder and read one file by another and import the data into Navision thru dataport… Is this achievable in Navision using any File/System commands ? If so how ??? Is it possible to execute any shell program / dos commands directly from Navision to get this.?? Kindly help.

2

Using automation with ‘Microsoft Scripting Runtime’

3

using this code in a report, you can get each file in a directory. recdir is a record FILE (2000000022) recDir.RESET; recDir.SETRANGE(Path,txtPath); recDir.SETRANGE(“Is a file”,TRUE); IF recDir.FIND(’-’) THEN BEGIN ImportFile(recdir.path,recdir.name); END ELSE CurrReport.BREAK; Then, in the Importfile function, you can run a dataport in unattended mode (usereqform=no) and use the different trigger to use the file. Regards,

4

Thanksssssssssssssss

5

Hai suvidha ,Is it is working.can you give me a clear explantion to do this .

Thanks in advance.