Reading all the files in a folder from Navision programming?

ardent
Member Posts: 17
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.
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.
0
Comments
-
Hi ardent
We've had one task where we had to read-in several files a day into the navision dos database (logistical).
When starting the import-function, you first start a dos-batch that copies all files into one. Then you start the dataport.
You can start a dos command via the callSYSTEM() Parmeter
Hope, this helps1
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions