I'm getting a strange error

[Any Web PCs]

Hi All,

Can anyone answer a very quick question. I'm in the middle or submitting my flat file spreadsheet to my first actinic store but for some reason I keep getting this error:

Line 17: Wrong number of fields. Expected 64 but got 53.

The first 16 lines are fine, but the rest are not

Any suggestions

Cheers in advanced

J.

[I-CC]

You might want to check that the last column is not empty, i.e. each of the entries for each row of the column has an entry. We generally have the "Can Be Ordered Online" as the last column as this is always got a 1 or 0 in it.

Another thing is to check that you do not have wayward columns placed in by excel, if that is how you are originating your csv file. We generally grab the column descriptors and drag it through a couple of hundred so called empty columns and then delete them, just to make sure nothing is lurking that could produce rogue columns when converted to a csv file.

Hope this helps....

[garyhay]

Did you install a trial of business or developer

[Any Web PCs]

No mate, we brought and installed the full copy of Actinic Developer V6.

J.

[Any Web PCs]

SUCCESS!! Fixed it

SUCCESS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Fixed it. Thank you Support@Techno it was the spaces. Firstly I moved the "Can Be Ordered Online" column to the end of the sheet, and then wen through the document to remove any spaces, and it worked. We now have 140 inkjet cartridges online. Now I have to work out what part of what template is doing what.. and remove the large amount of space found above the products.

Cheers all

J.

[I-CC]

Glad it worked out for you.

Best of luck with the store.