0

Unexpected error: Probably has fewer fields than header.

I loaded in 2200 records and set a tag that would flag certain records if there was duplicate data and there was 117 errors. Fine but now I am trying to get the last 117 to load and I keep getting this error. I have read through many of the posts and I tried checkin to make sure I had a good CSV. file and tried resaving it and starting again but northing seems to be working. Thank you for any help!

6 comments

Date Votes
0
Avatar
Patricio Carcani
Hi Alysha, when you check CSV file you validate you have expected columns for all rows? You can use http://csvlint.io/ to make it easier. Regards.
0
Avatar
Alysha Chapman
Hello,

I did this and it said my file was great. Thanks
0
Avatar
Patricio Carcani
Hi Alysha, please share with us Task Run ID and file used to investigate further. Thanks!
0
Avatar
Alysha Chapman
Here you go. Task Run 5051367

I am not sure how to attach a file on here.
0
Avatar
Patricio Carcani
Hi Alysha, your task definition has 29 fields while the file used as input has 28 columns (you need to add Household Name column between Last Name and Name as in QB to use a valid file according your task). Regards!
0
Avatar
Steve Armstrong

Hi,

 

Hi,

I encounter the same issue. Have no idea what is missing. Used the csv checking service http://csvlint.io/ and also received no errors and no warning.

Could you please have a look at task 13195881

 

many thanks in advance,

 

Steve

Please sign in to leave a comment.