NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1

View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0015421phplist applicationSubscriber Importpublic08-03-10 14:0729-04-10 05:48
PlatformOSOS Version
Product Version2.10.8 
Target Version2.10.12Fixed in Version2.10.12 
Summary0015421: Importing CSV with multiple values for Checkboxgroup crashes with SQL Error
DescriptionI 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 [^]

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
TagsNo tags attached.
Attached Filescsv file icon Morgan.csv [^] (150 bytes) 08-03-10 14:07

- Relationships Relation Graph ] Dependency Graph ]
related to 0012206resolvedmichiel incorrect import of checkboxgroup attributes 

-  Notes
michiel (manager)
19-04-10 19:13

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
Powered by Mantis Bugtracker