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
- 309 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
Loading data from text files
McLean
Member Posts: 32
I'm loading contact data into Attain 3.0 using a code unit. Special characters like é (letter e with a tremor) are not translated correctly. All of my windows applications (Word, Excel, NotePad, WordPad) can see the data correctly. Used to do this without problem with Nv Fin 2.0.
Any suggestions?
Angus
Any suggestions?
Angus
0
Comments
The problem lies in the conversion between ANSI and ASCII. Most Windows apps use ANSI as their character set. Navision uses ASCII instead. Files in Excel can be saved as e.g. CSV (MS-DOS), which produces ASCII, and can be imported into Navision without loss of diacritics.
Jan Hoek
Product Developer
Mprise Products B.V.
Thanks for your reply. From Excel I tried just about every possible format. the one that works is Text(tab delimted) the characters are correct and the data appears in fixed positions (I need this for the code unit). If I use the format Text (MS-Dos) then the characters are incorrect and the data is not in position.
By the way I use WordPad to open and examine the contents of the txt files after I have created them with Excel.
The strange thing is I used to do this with Nav Fin 2.01 without problems and now with Attain I can't get it to work.
regards
Angus
Since Wordpad is a Windows app, it uses ANSI as well. Use good old edit.com to view your files in ASCII.
Jan Hoek
Product Developer
Mprise Products B.V.
when i use edit it shows the character to be incorrect. So I am not translating the data correctly ie from ANSi to ASCII?
Just solved it!!!!
In access I export the query and changed the Code page in the Export Text Wizard from Western European (Windows) to Western European (Dos). And this now loads correctly and shows right characters using edit.com
Thanks for your help