Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

2 double quotes importing to Mysql?


kelly236

Recommended Posts

Posted

I'm trying to manually populate the products_options_values table but when I try to upload it I get this error

 

Invalid field count in CSV input on line 1.

 

So the only way I have gotten this to work is to change the "Fields terminated by" and the "Fields enclosed by"

 

to comma's in my phpMyAdmin under the "Format of imported file" section, then it works but I go back to look at my attributes and I noticed now I have 2 double quotes in my listing, I do need to have a double quotes to show measurements in inches but they are doubled now, please can anyone, PLEASE help me figure this out I'm at a loss and I need to get this up

 

Thanks,

 

Kelly

Posted

Thanks Everybody, I figured it out!!!

 

 

 

I'm trying to manually populate the products_options_values table but when I try to upload it I get this error

 

Invalid field count in CSV input on line 1.

 

So the only way I have gotten this to work is to change the "Fields terminated by" and the "Fields enclosed by"

 

to comma's in my phpMyAdmin under the "Format of imported file" section, then it works but I go back to look at my attributes and I noticed now I have 2 double quotes in my listing, I do need to have a double quotes to show measurements in inches but they are doubled now, please can anyone, PLEASE help me figure this out I'm at a loss and I need to get this up

 

Thanks,

 

Kelly

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...