dataport output file format

calvinhfx
calvinhfx Member Posts: 6
edited 2002-09-20 in Navision Financials
<img border="0" title="" alt="[Confused]" src="images/smiles/icon_confused.gif" /> I am about to experiment with a dataport to export information from Navision since odbc is so slow, due to the table sizes. The database is installed at our office in Singapore and the data has language specific characters within, but the import will be into our SQL reporting database, in english. I am told that I need this file in unicode format due to these characters. I have not tried this yet but would appreciate any help beforehand if anyone has gone through this before.

Comments

  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    Not a solution but a hint

    I did some conversion for output in ANSI code instead of ASCII. I think with some modifications it sould also be able to convert the 2-byte UNI-Code Text into Navision and back.
    </font><blockquote><font size="1" face="Verdana, Arial">code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">ANSI2ASCII(ANSIText : Text[250]) ASCIIText : Text[250])
    local: ANSI Text 1
    ASCII Text 1
    returnvar: ASCIIText Text 250

    ASCII[1] := 246; ANSI[1] := 148; //German oe (ö)
    ASCII[2] := 214; ANSI[2] := 153; //German OE (Ö)
    ASCII[3] := 228; ANSI[3] := 132; //German ae (ä)
    ASCII[4] := 196; ANSI[4] := 142; //German AE (Ä)
    ASCIIText := CONVERTSTR(ANSIText,ANSI,ASCII);</pre><hr /></blockquote><font size="2" face="Verdana, Arial">

Categories