Dataport import skips on column 46

Kisu

Heyas, I've been working on a dataport which imports sales invoice data.
The file is in text with one header line and columns are separated with ; <-chars

I made the line skip for the first line but when I do the import it somehow skips on column no 46 and it starts the line again over the earlier line in the table and I get error that the data cant be inserted cause wrong datatype.


Example csv file:

header1;header2;header3;header4;header5
123;456;789;abc;def


It goes in the table like this (if column header3 would be the no 46)

abc|def <--line 1
123|456|789 <--line 2


I realy dont know why this happens like this can it be something todo with collation :-k

The csv has 75 columns separated by ;
also the table where I'm importing them has 75 columns (this table is for test only)

Kisu

It skips the column 46 even if I remove the header line in the file and the code that skips the header so it cant be because of that.

There is no coding now on the port what so ever and it still skips ](*,)

Kisu

Here is a picture of the situation

Kisu

I breaked down the test csv line into 5 lines and made all table variables as text and imported the file and the lines came perfectly in, so is there somekind of max line width for the import or something??

Can someone help please.

Kisu

Omg stupid me, seems like I forgot to save the dataport after I made the fields after 46-rest

It didn't even come to my mind to check the field designer again gah. #-o

Oh well, I think I get it working this time :oops: