flat file import

[Coggy]

Hi all,

I've created a csv file in excel that contains certain fields including section text, product reference etc. In order for me to identify errors in the file as soon as possible I have been importing the file (and replacing existing catalog data) after the addition of each new field. This worked perfectly for the first 10 fields, however now I've added a field for the extended info image and I get the error messages:

"Line 17: Wrong number of fields. Expected 11 but got 10."
"Line 18: Wrong number of fields. Expected 11 but got 10."
:
:
:
"Line 864: Wrong number of fields. Expected 11 but got 10."


Line 17 is the line immediatly after the first record containing an extended info image filename entry and line 864 is the last record in the file.

Does anybody now why this is happening how to sort it out?

Chris

[Duncan Rounding]

Sounds like for some reason you may have a comma missing at the end of each record entry, ie the headrer has 11 fields but the records only have 10. Are you populating the newly added extended info field or leaving it blank? Try opening in notepad and check the number of commas on each of lines.

Duncan

[Coggy]

Problem Solved

Thanks Duncan,

You were right; it appears there were commas missing from all of the rows after the populated filename field. I noticed that those fields not completely populated were immediately followed by fields that were completely populated so, rather than manually adding commas to every row and risk completely messing the file up, I moved the filename field to ensure that the last field in the table was completely populated. This removed the problem.

Cheers

Chris