Error from data tool when selecting CSV file


https://forum.kartris.com/Topic1140.aspx
Print Topic | Close Window

By saturation - Tue 26 Jul 2011
I have a spreadsheet of 236 records.   When I pick the CSV file from my drive, I get "236 records/lines detected.   Unexpected # of rows ->23.   Please select another file."

I removed the last 23 rows and I still get the same error message.  What am I doing wrong here?  
By Medz - Wed 27 Jul 2011
Hi, can you send me the file so I can check it out? I think its saying that it found 23 "columns" while its expecting the file to have at least 29.

Regards,

Medz
By saturation - Thu 28 Jul 2011
That was it!!   Are all of those fields required in the spreadsheet I take it?
By Medz - Fri 29 Jul 2011
Hi, just to make it a bit clearer. You actually need to include all the 29 fields in your CSV. Though you can put NULL values in some fields like in the P_Strapline or V_Desc1 if you don't have data for them.

Remember that the first 2 lines of your CSV file should always be these  ->

"Cat5_Name1","Cat5_Desc1","cat5_Image","Cat4_Name1","Cat4_Desc1","cat4_Image","Cat3_Name1","Cat3_Desc1","cat3_Image","Cat2_Name1","Cat2_Desc1","cat2_Image","Cat1_Name1","Cat1_Desc1","cat1_Image","P_Name1","P_Desc1","P_Image","P_StrapLine1","V_Name1","V_Desc1","V_Image","V_CodeNumber","V_Price","V_Quantity","V_Weight","V_RRP","T_Taxrate","Supplier","P_Attribute1"
"###_DUMMYDATA_###","DON'T MODIFY OR DELETE THIS LINE. THIS SHOULD HELP ADDRESS THE ISSUES WITH THE OLEDB DRIVER LIMITATION. BY ADDING THIS LINE WE'RE LETTING THE DRIVER KNOW THE CORRECT DATA TYPE OF EACH FIELD.  THIS IS BETTER THAN MODIFYING THE REGISTRY TO SET A HIGHER ROWSCAN VALUE.","CAT5_IMAGEFIELD","CAT4_NAME","################################################################################################################################################################################################################################################################","CAT4_IMAGEFIELD","CAT3_NAME","################################################################################################################################################################################################################################################################","CAT3_IMAGEFIELD","CAT2_NAME","################################################################################################################################################################################################################################################################","CAT2_IMAGEFIELD","CAT1_NAME","################################################################################################################################################################################################################################################################","CAT1_IMAGEFIELD","P_NAME1","################################################################################################################################################################################################################################################################","P_IMAGEFIELD","P_STRAPLINE1","V_NAME1","################################################################################################################################################################################################################################################################","V_IMAGEFIELD","V_CODENUMBER",0,0,0,0,0,"SUPPLIER","###_END_OF_DUMMYDATA_##


Then followed by the actual data lines that you want to import. e.g.

"Barbeque Basics",,,,,,,,,,,,,,,"Exodus Cajun Ketchup",,,,"Exodus 500ml",,,"exodus-ck500",2.49,0,2,0,0,,

*notice how the other fields are empty - it only includes data for the category name, product name, V_CodeNumer, Price, etc