save csv file for import

nikeman77
nikeman77 Member Posts: 517
edited 2012-11-28 in NAV/Navision Classic Client
hi guys,

how do i save a *csv files with start & end delimiter as double code so that i can import into navision dataport?

in windows 7, i tried to used control panel> region and language> format tab> additional settings, set list as "

it can only save as below with data item format(item no| quantity|sales price)

item1011"50",$20.55

but i like to get

"item1011","50","$20.55"

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Avoid those:
    Use tab-separated in Excel. You will have a lot less problems importing data.

    And in your dataports, use
    FieldStartDelimiter,FieldEndDelimiter=<None>
    FieldSeparator=<TAB>

    the < and > are mandatory.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • nikeman77
    nikeman77 Member Posts: 517
    kriki,

    start and end delimiter, when i tried 3 methods but failed.
    method1:
    Start Delimiter: <BLANK>
    End Delimiter : <BLANK>
    Result : <BLANK>item1011<BLANK> <BLANK>50<BLANK> <BLANK>$20.55<BLANK>

    method2:
    Start Delimiter: <NONE>
    End Delimiter: <NONE>
    Result : <NONE>item1011<NONE> <NONE>50<NONE> <NONE>$20.55<NONE>

    method3:
    Start Delimiter: *i tried to delete whatever text inside the field but it will auto go back to <">
    End Delimiter: *i tried to delete whatever text inside the field but it will auto go back to <">
    _____________________________________________________________________________________
    For field separator, i CAN change to <TAB>
  • MBerger
    MBerger Member Posts: 413
    nikeman77 wrote:
    kriki,
    method2:
    Start Delimiter: <NONE>
    End Delimiter: <NONE>
    Result : <NONE>item1011<NONE> <NONE>50<NONE> <NONE>$20.55<NONE>
    Oddly enough, NAV is case-sensitive here....use <None>
  • nikeman77
    nikeman77 Member Posts: 517
    a silly mistake i made.. it was some coding inside the dataport that causes it as i uses 2 data item in a dataport
    first one for export, second one for import.

    when i split the dataitem into 2 dataport, all i need to do was to save the file into *.csv , dont have to set my dataport properties sorry about that
    guys..

Categories