Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
PDF to CSV Conversion
slowhandfan
Member Posts: 56
I have a client that is installing ALOHA from NCR and they asked me to write an interface to import that data into Navision.
The EOD folders in ALOHA (aka "the grind files") are produced in DBF format. In testing, I have been opening the DBF files I need in EXCEL and saving them as a .CSV file, and I have dataports and codeunits (for automation) to import the CSV files. It works great.
But nearing install now, obvioulsy in automation (on the NAS), I cannot open the files in excel and save them as a CSV
Does anyone know a utility (an exe program) I can call out of a shell command in navision where I tell it where the ITM.DBF file is and it creates a ITEM.CSV file in the same library....
I would greatly appreciate any input on this I could get, it is a little late in the game to rewrite the entire interface....
The EOD folders in ALOHA (aka "the grind files") are produced in DBF format. In testing, I have been opening the DBF files I need in EXCEL and saving them as a .CSV file, and I have dataports and codeunits (for automation) to import the CSV files. It works great.
But nearing install now, obvioulsy in automation (on the NAS), I cannot open the files in excel and save them as a CSV
Does anyone know a utility (an exe program) I can call out of a shell command in navision where I tell it where the ITM.DBF file is and it creates a ITEM.CSV file in the same library....
I would greatly appreciate any input on this I could get, it is a little late in the game to rewrite the entire interface....
0
Comments
Why? Why can't you use Excel automation?
Alternatively you might want to try ADO.
Or, as some software I used to use does: chip off the header of the dbf file and treat the rest as fixed length records.