save csv file for import

nikeman77

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"

kriki

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.

nikeman77

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

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

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..