NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1
|Anonymous | Login | Signup for a new account||28-05-17 11:16 BST|
|My View | View Issues | Change Log | Roadmap|
|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 05: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.|
|Attached Files||Morgan.csv [^] (150 bytes) 08-03-10 14:07|
|this will be working in the next release, however, using , as the value separator, which means you have to import your file as a TAB delimited file.|
|Copyright © 2000 - 2017 MantisBT Team|