Import dataport problems with special char

selece28
selece28 Member Posts: 316
edited 2008-06-02 in NAV/Navision Classic Client
Hi Nav Masters,
I have a problems with my dataport.
When importing Data, my clients data consist of special char like "
They use it for writing 'inch' so instead of <14 Inch> they write <14">
After run my dataport, the result will be incorrect because navision think " as separator.
I Already set the delimiter in my dataport from <"> into <None>
But still it cannot import correctly.

Any idea how to import this character?

Thanks in advance
______________

Regards,
Steven

Answers

  • JedrzejT
    JedrzejT Member Posts: 267
    If this file is in standard import format *.csv then you should replace all (") sign to (') before import file.
    If you have (in import file) field separator (") and have (") sign in filelds value dataport can not import that in standard way.
    When i create csv file I always replace (") on (') and (;) on (,)

    You can replace later (') on (") in code of dataport to have this in database but this is not good idea. When You have (") in table then you can not copy and paste data to excell.

    Regards
  • selece28
    selece28 Member Posts: 316
    I just find out that Navision cannot import "
    so in csv we have to replace " with other char like ^
    the with the import dataport we should use CONVERSTR to replace ^ back into "

    Thanks
    ______________

    Regards,
    Steven
  • Malajlo
    Malajlo Member Posts: 294
    Use different char for field separator. Ie ÷פ~ˇ.

Categories