how to import euro symbol in navision 4.0

venkatesh
venkatesh Member Posts: 51
edited 2006-04-12 in NAV/Navision Classic Client
hello,
i want to import some datas into navision which contain euro sign with it. i tried to import datas with dataport,but i am not able to import euro sign inside navision.please give me a solution for this.


thanks,

Comments

  • kriki
    kriki Member, Moderator Posts: 9,124
    This is probably because the codepage of Windows and Navision is not the same. So € and other symbols have another ASCII-value between Windows and Navision, and have to be converted.
    Check this : http://www.mibuso.com/dlinfo.asp?FileID=287
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Kowa
    Kowa Member Posts: 926
    If you open the file in Wordpad and save it as file type "Text Document (MS-DOS)" the special characters e.g. "€üöäsÄÖÜß" should come out right. Navison expects ASCII-type files , not ANSI.
    Kai Kowalewski
  • venkatesh
    venkatesh Member Posts: 51
    Hello kirki,
    i imported the Ansi-Ascii converter in to navision 4.0.After importing the Ansi-Ascii.txt, I opened the Codeunit 99999(This is the imported object Id)in design mode.now,the Euro sign is changed to some ascii character like this 'Ç' inside the codeunit 99999.
    The same problem exists when i try to import Ellipses '...' It is changed to 'à'.
    Can you please give me a solution for this.

    Thanks
  • colingbradley
    colingbradley Member Posts: 162
    One way is to treat all incoming data as text variables and then validate the data, convert or extract etc and insert into the database fields.

    This way you can check everything before updating the table(s).
    Experience is what you get when you hoped to get money
  • kriki
    kriki Member, Moderator Posts: 9,124
    venkatesh wrote:
    Hello kirki,
    i imported the Ansi-Ascii converter in to navision 4.0.After importing the Ansi-Ascii.txt, I opened the Codeunit 99999(This is the imported object Id)in design mode.now,the Euro sign is changed to some ascii character like this 'Ç' inside the codeunit 99999.
    The same problem exists when i try to import Ellipses '...' It is changed to 'à'.
    Can you please give me a solution for this.

    Thanks
    In case it still didn't give the correct character in Navision, did you also try the other function?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories