how to import euro symbol in navision 4.0

venkateshvenkatesh Member Posts: 51
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

  • krikikriki Member, Moderator Posts: 9,118
    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!


  • KowaKowa Member Posts: 925
    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
  • venkateshvenkatesh 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
  • colingbradleycolingbradley 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
  • krikikriki Member, Moderator Posts: 9,118
    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!


Sign In or Register to comment.