View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0015421||phplist application||Subscriber Import||public||08-03-10 14:07||29-04-10 04:48|
|Target Version||2.10.12||Fixed in Version||2.10.12|
|Summary||0015421: Importing CSV with multiple values for Checkboxgroup crashes with SQL Error|
|Description||I have a CSV file that I use to import users, the file contains the email, the first name, the last name, and several other single value fields in addition to the field (Course) that is causing the problem which is an attribute defined as a checkboxgroup.|
I am trying to import users with multiple values for the course field separating them by ; and adding a space after it.
The user is imported along with all attributes but it crashes on the multi-value attribute Course.
I have added the importcsv to my installation: ref http://mantis.phplist.com/view.php?id=5921
But I get an error always
"Database error 1064 while doing query 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 '; CFA) and phplist_user_user_attribute.attributeid = 50' at line 4"
I have tried adding the option id and the option value, all fail with the same error, tried removing the space before the semi column, same issue.
I have attached the csv file for reference..
I have attached my CSV file
|Tags||No tags attached.|