Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Importing Special Character from Excel Worksheet
darshanm
Member Posts: 280
Hi,
I want to import data from Excel worksheet into SQL server
through Navision data port. But Navision does not accept any special character from Excel Worksheet. After importing whole data
Navision shows like this "Polythene Bag 5?"" x 6?"""
How can import data with special characters??
I want to import data from Excel worksheet into SQL server
through Navision data port. But Navision does not accept any special character from Excel Worksheet. After importing whole data
Navision shows like this "Polythene Bag 5?"" x 6?"""
How can import data with special characters??
Darshan Mungekar
Senior Consultan
Senior Consultan
0
Comments
In the dataport put properties "FieldStartDelimiter","FieldEndDelimiter" to "<None>" and property "FieldSeparator"="<TAB>".
The standard " as fieldseperator is not exactly the best choice.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
I have changed the dataport property, But still Navision is not
accepting special characters. My data is as below
Equal Tee 20mm ( ¾")
End Cap 40mm ( 1½")
Coupler 6 Kgs/Cm²
How can I import the above special characters through dataport??
Senior Consultan
http://www.mibuso.com/forum/viewtopic.php?t=1774
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
we were having similar issues and found the ansi2ascii converter to be an adequate solution thus far. Note, however, that we had to have our reseller do some map corrections so that we would get the right ASCII character. As we don't have the permissions to modify codeunits, this means we had to pay a few bucks for someone to make the change and get back to us. I would advise you do a lot of testing and make sure each special character is making it in unscathed.
We were specifically having trouble with Ø being replaced with ¥.
edit: we also had to have the Codeunit number changed to something within our license range (99999 would not work).