phpList.org

Attributes not working on import

Not sure if I’m doing this right…but I created attributes mapped to my CSV file, then I try to import, it says there’s an error before even starting, then import works anyways, but only email field gets imported…!

The error is this:

Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'fname","title","industrytype","stateprovince","city""' at line 1

@xuzo It looks like the csv file you are importing has ‘,’ as the field separator. You need to enter that on the first import page.

Wow, excellent, why doesn’t the error say something human like:

"your list is comma separated, use ", " in [Field Delimiter]"

Solved, thanks :wink: