Dataport misses first key field.

aph1
aph1 Member Posts: 14
edited 2006-10-04 in Navision Attain
Hello all,

I am new to Navision, so apologies if this is a basic question, but I am getting a strange problem when importing data from a CSV file into the Item table. Here is an example of the file:

"115124","","","BINDERS, Medium (Mechanical)"
"115131","Cont. Binders","Cont. Binders","BINDERS, Contaminated"
"115134","","","BINDERS,Contaminated"
"115194","","","WRAPPER"

In each instance the dataport misses the first key value e.g. No.

No Description
BINDERS, Medium (Mechanical)
115131 BINDERS, Contaminated
115134 BINDERS,Contaminated

After that everything is OK. What could cause that to occur?

Comments

  • aph1
    aph1 Member Posts: 14
    Actually I think I may have just answered my own question. There was an awful lot of white space in my export file which I have trimmed off and this time I got all records as expected.

Categories