Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
NAV/Navision Classic Client
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.6K
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
298
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
259
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Export problems.... HELP!!
Becka
Member
Posts:
178
2007-12-26
edited 2007-12-28
in
NAV/Navision Classic Client
hi all
So, I need to export information from Navision to the txt file... it's not problem at all... but, i need to export this information in UNICODE, so if any ideas, just help me
thanks for help..
MCSD
Attain Navision
0
Comments
Marije_Brummel
Member, Moderators Design Patterns
Posts:
4,262
2007-12-26
On
www.dynamicsusers.org
you can find a ansi to unicode convertor.
Marije Brummel
| Freelance Business Central Specialist
0
Waldo
Member
Posts:
3,412
2007-12-26
I think I know this tool, but isn't it only for exporting?
Eric Wauters
MVP
- Microsoft Dynamics NAV
My
blog
0
ara3n
Member
Posts:
9,256
2007-12-26
that is why the user is asking. exporting to unicode.
Or did you mean importing Waldo?
Ahmed Rashed Amini
Independent Consultant/Developer
blog:
https://dynamicsuser.net/nav/b/ara3n
0
Waldo
Member
Posts:
3,412
2007-12-26
:oops: I meant importing ...
Eric Wauters
MVP
- Microsoft Dynamics NAV
My
blog
0
Dries
Member
Posts:
29
2007-12-28
I have two functions for you that can convert your export.
You can use them within your dataport.
Before exporting the data, you need to put the content through the two functions and then export to the file.
I can send them to you if you want.
Cheers,
Idriss.
0
Dries
Member
Posts:
29
2007-12-28
Put your output in ABEANSI2OEM( here )
you can use the same function with unicode by changing the numbers.
*****
Build this in your dataport:
**********************
function name and content:
ABEANSI2OEM(ANSIString : Text[250]) : Text[250]
FromChars := '';
FromChars [1] := 183;
FromChars [2] := 181;
FromChars [3] := 142;
FromChars [4] := 143;
FromChars [5] := 146;
FromChars [6] := 128;
FromChars [7] := 212;
FromChars [8] := 144;
FromChars [9] := 210;
FromChars[10] := 211;
FromChars[11] := 222;
FromChars[12] := 214;
FromChars[13] := 215;
FromChars[14] := 216;
FromChars[15] := 165;
FromChars[16] := 227;
FromChars[17] := 224;
FromChars[18] := 226;
FromChars[19] := 153;
FromChars[20] := 154;
FromChars[21] := 225;
FromChars[22] := 133;
FromChars[23] := 160;
FromChars[24] := 131;
FromChars[25] := 132;
FromChars[26] := 134;
FromChars[27] := 145;
FromChars[28] := 135;
FromChars[29] := 138;
FromChars[30] := 130;
FromChars[31] := 136;
FromChars[32] := 137;
FromChars[33] := 141;
FromChars[34] := 161;
FromChars[35] := 140;
FromChars[36] := 139;
FromChars[37] := 164;
FromChars[38] := 149;
FromChars[39] := 162;
FromChars[40] := 147;
FromChars[41] := 228;
FromChars[42] := 148;
FromChars[43] := 151;
FromChars[44] := 163;
FromChars[45] := 150;
FromChars[46] := 129;
ToChars := '';
ToChars [1] := 192;
ToChars [2] := 193;
ToChars [3] := 196;
ToChars [4] := 197;
ToChars [5] := 198;
ToChars [6] := 199;
ToChars [7] := 200;
ToChars [8] := 201;
ToChars [9] := 202;
ToChars[10] := 203;
ToChars[11] := 204;
ToChars[12] := 205;
ToChars[13] := 206;
ToChars[14] := 207;
ToChars[15] := 209;
ToChars[16] := 210;
ToChars[17] := 211;
ToChars[18] := 212;
ToChars[19] := 214;
ToChars[20] := 220;
ToChars[21] := 223;
ToChars[22] := 224;
ToChars[23] := 225;
ToChars[24] := 226;
ToChars[25] := 228;
ToChars[26] := 229;
ToChars[27] := 230;
ToChars[28] := 231;
ToChars[29] := 232;
ToChars[30] := 233;
ToChars[31] := 234;
ToChars[32] := 235;
ToChars[33] := 236;
ToChars[34] := 237;
ToChars[35] := 238;
ToChars[36] := 239;
ToChars[37] := 241;
ToChars[38] := 242;
ToChars[39] := 243;
ToChars[40] := 244;
ToChars[41] := 245;
ToChars[42] := 246;
ToChars[43] := 249;
ToChars[44] := 250;
ToChars[45] := 251;
ToChars[46] := 252;
EXIT(CONVERTSTR(ANSIString, ToChars, FromChars));
0
Sign In
or
Register
to comment.
Comments
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
Or did you mean importing Waldo?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
You can use them within your dataport.
Before exporting the data, you need to put the content through the two functions and then export to the file.
I can send them to you if you want.
Cheers,
Idriss.
you can use the same function with unicode by changing the numbers.
*****
Build this in your dataport:
**********************
function name and content:
ABEANSI2OEM(ANSIString : Text[250]) : Text[250]
FromChars := '';
FromChars [1] := 183;
FromChars [2] := 181;
FromChars [3] := 142;
FromChars [4] := 143;
FromChars [5] := 146;
FromChars [6] := 128;
FromChars [7] := 212;
FromChars [8] := 144;
FromChars [9] := 210;
FromChars[10] := 211;
FromChars[11] := 222;
FromChars[12] := 214;
FromChars[13] := 215;
FromChars[14] := 216;
FromChars[15] := 165;
FromChars[16] := 227;
FromChars[17] := 224;
FromChars[18] := 226;
FromChars[19] := 153;
FromChars[20] := 154;
FromChars[21] := 225;
FromChars[22] := 133;
FromChars[23] := 160;
FromChars[24] := 131;
FromChars[25] := 132;
FromChars[26] := 134;
FromChars[27] := 145;
FromChars[28] := 135;
FromChars[29] := 138;
FromChars[30] := 130;
FromChars[31] := 136;
FromChars[32] := 137;
FromChars[33] := 141;
FromChars[34] := 161;
FromChars[35] := 140;
FromChars[36] := 139;
FromChars[37] := 164;
FromChars[38] := 149;
FromChars[39] := 162;
FromChars[40] := 147;
FromChars[41] := 228;
FromChars[42] := 148;
FromChars[43] := 151;
FromChars[44] := 163;
FromChars[45] := 150;
FromChars[46] := 129;
ToChars := '';
ToChars [1] := 192;
ToChars [2] := 193;
ToChars [3] := 196;
ToChars [4] := 197;
ToChars [5] := 198;
ToChars [6] := 199;
ToChars [7] := 200;
ToChars [8] := 201;
ToChars [9] := 202;
ToChars[10] := 203;
ToChars[11] := 204;
ToChars[12] := 205;
ToChars[13] := 206;
ToChars[14] := 207;
ToChars[15] := 209;
ToChars[16] := 210;
ToChars[17] := 211;
ToChars[18] := 212;
ToChars[19] := 214;
ToChars[20] := 220;
ToChars[21] := 223;
ToChars[22] := 224;
ToChars[23] := 225;
ToChars[24] := 226;
ToChars[25] := 228;
ToChars[26] := 229;
ToChars[27] := 230;
ToChars[28] := 231;
ToChars[29] := 232;
ToChars[30] := 233;
ToChars[31] := 234;
ToChars[32] := 235;
ToChars[33] := 236;
ToChars[34] := 237;
ToChars[35] := 238;
ToChars[36] := 239;
ToChars[37] := 241;
ToChars[38] := 242;
ToChars[39] := 243;
ToChars[40] := 244;
ToChars[41] := 245;
ToChars[42] := 246;
ToChars[43] := 249;
ToChars[44] := 250;
ToChars[45] := 251;
ToChars[46] := 252;
EXIT(CONVERTSTR(ANSIString, ToChars, FromChars));