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
- 310 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
Fixed Len Import Dataport Problems
Pavlos
Member Posts: 19
Hi to all,
I've created a dataport in order to import data from a fixed length ascii file into a table (I've created) in navision. There are two problems with this dataport that I can't figure out.
1. When I run the dataport it inserts ONLY the first record and discards the rest.
2. There is a description field (that has an item description in Greek). I've done the convertion from ansi to ascii and I still can't get the proper characters. Instead when I'm doing ansi to OEM conversion from my file editor and then import I get the proper characters.
Please help me I've spent a lot of time trying to find out a solution.
Thanks in advance.
Pavlos
I've created a dataport in order to import data from a fixed length ascii file into a table (I've created) in navision. There are two problems with this dataport that I can't figure out.
1. When I run the dataport it inserts ONLY the first record and discards the rest.
2. There is a description field (that has an item description in Greek). I've done the convertion from ansi to ascii and I still can't get the proper characters. Instead when I'm doing ansi to OEM conversion from my file editor and then import I get the proper characters.
Please help me I've spent a lot of time trying to find out a solution.
Thanks in advance.
Pavlos
0
Comments
Are you sure that you have set the property RecordSeparato correctly on the dataport. If it only import 1 record it could be because it thinks there is only one
2)
Ehhmm.. ok!
Tommy
thanks for your reply.
I've managed to figure out what the problem was. The problem was the format of the file. The file in unix format so by using my text editor I've convert the file in dos format so I've solved my first problem. For the second problem I've used again my editor to convert ANSI to OEM and it works! Although this is not the best solution. Does anybody knows any tool in navision that I can use in order to convert a unix file to dos file from within the navision instead of using an external editor?
Thank you.
Did you solve your problem with regards to it only reading the first record? Or was that also because of it being a unix file? It shouldn't be a problem to read unix files into navision. You just have to remember that the line-break on unix is on LF but in DOS it is CRLF. Thus if you dataport assumes LF as the line/record break then everything should be working!
Tommy