mibuso.com
Home› NAV/Navision Classic Client

importing funny(french) characters in navision

ecclecticecclectic Member Posts: 176
edited 2006-08-31 in NAV/Navision Classic Client
hi all,

in the french version, the values for the field account type in the table g/l account are amongst others "Début total" . when i am trying to load data using dataport- it does not recognise the character 'é' and gives me an error message.

the file format i am using is csv.

thanks

Comments

  • kakkassmkakkassm Member Posts: 12
    it's the same problem with all caractere with accent, the tips to import those caractere in navision, make an export of sample data containing those caractere from navision to a text file, then in a text file copy the equivalent of the words.

    example:

    when you export data from general journal that contains Général as account type,

    in the text file you will find G‚n‚ral like this instead of Général.

    then in your csv file replace Général with G‚n‚ral.

    =D>
  • ta5ta5 Member Posts: 1,164
    Hi
    Navision expects the load is ASCII. Ansi files are wrong interpreted if the contain special characters.

    You have 2 possibilities:

    1) Request an Ascii File (or create one for example when exporting from Excel use MS-DOS option)
    2) Use a conversion function, for example Ansi2Ascii in CodeUnit GeneralMgt

    Hope this helps
    Thomas
  • SavatageSavatage Member Posts: 7,142
    There is a download available on Mibuso called Ansi-Ascii converter.

    Convert ANSI characters to ASCII and back!
    Very usefull when importing text files with all these nasty things!

    Contains the functions Ansi2Ascii and Ascii2Ansi.

    http://www.mibuso.com/dlinfo.asp?FileID=287

    Also if you search the forum for Ascii you should get a bunch of posts too.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • PhennoPhenno Member Posts: 630
    To correctly import non-english language specific characters I usually use a "Save as" to CSV (MS-DOS) (Not a regular CSV, but MS-DOS version) option in excel.


    Than, I simply import that csv with regular dataport. Note: do not touch that csv again. If somehting (beside character problem) is wrong with data, change in original Excel that export it again to CSV (MS-DOS).


    Another version is to you ansi-ascii convertor as Savatage said.
  • PhennoPhenno Member Posts: 630
    Btw, it's not nice to say that for someones language ("funny characters")...
  • DenSterDenSter Member Posts: 8,307
    I agree, that little c with the thingy hanging from it is a very funny character :mrgreen:
    Daniel Rimmelzwaan
    RIS Plus, LLC
Sign In or Register to comment.