Export problems.... HELP!!

Becka
Becka Member Posts: 178
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 :mrgreen:

thanks for help..
MCSD
Attain Navision

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    On www.dynamicsusers.org you can find a ansi to unicode convertor.
    Marije Brummel | Freelance Business Central Specialist
  • Waldo
    Waldo Member Posts: 3,412
    I think I know this tool, but isn't it only for exporting?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • ara3n
    ara3n Member Posts: 9,258
    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
  • Waldo
    Waldo Member Posts: 3,412
    :oops: I meant importing ... :|

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Dries
    Dries Member Posts: 29
    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.
  • Dries
    Dries Member Posts: 29
    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));

Categories