Import CSV requires a certain field

By Jason - September 18, 2013

Hi Greg,

CONDITION is a reserved word for MySQL, but if that was the issue, I would expect to see errors when it was included, instead of excluded.  So, when you skip the condition field, you get an error, but if you assign it to a CMS field, it works correctly, is that right?  Can you let me know what the error message is that you are getting?  What type of field are you mapping it to in the CMS?  What type of values are in that column?

Let me know and we'll see if we can narrow this problem down.

Thanks,

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By gversion - September 18, 2013

Hi Jason,

Your understanding is correct; when I include the filed the import works fine and if I exclude it then the import fails.

My "condition" field is a dropdown menu field with several options such as:

  • Excellent
  • Good
  • Fair/Working

These options are just setup using the "Set options below" list.

If I exclude the "condition" field then the error message is as follows:

Import Row #1 - MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition = DEFAULT , warranty = DEFAULT , description = DEFAULT , paid_until = ' at line 17
SET `product` = 'product name',
`status` = 'visible',
`list_price` = '100,000.00',
`manufacturer` = 'company_name'

Maybe the "condition" field can not be set to DEFAULT?

Thanks for your help with this.

Regards,

Greg

By Jason - September 19, 2013

Hi Greg,

Okay, I see.  If you could send in a second level support request (https://www.interactivetools.com/support/email_support_form.php?priority=free), I can take a closer look and find out what's happening.

Thanks,

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/