CSV File Import

[bnguru]

[size=2I exported the manufacturers and products files from osCommerce to Excel.

 

After reviewing the formats it was easy to cut & paste the inventroy from my POS system back into these CSV files. Both the manufacturer files imported without a problem, as did the products_to_categories table did.

 

But when I tried to import the products file I got this error:

Invalid format of CSV input on line 1569.

 

I reviewed the file and this line loks like all the others, I see no reason for the import to kick it out?

 

Also, on the products_description file I got this error:

Invalid field count in CSV input on line 69.

 

Again, I checked the file and this line has the same 6 variables as the rest of the file.

 

Any thought or ideas will be appreciated. I'm trying to get my store up and running, and inputting over 5,000 items by hand would be a long project.

 

Thanks, Steve in Illinois