Please help us help you and fill where relevant: 
Your LimeSurvey version: [Version 3.22.24+200630]
Own server or LimeSurvey hosting: DK
Survey theme/template: Fruity/Inherit
==================
Good afternoon,

I've got a issue when importing csv file (format with commas, sting values in double quotes and column names follow LM manual) to create my LS participant invitation list.
A SQL error occurs because of column "firstname" at row 1 (see screenshot)
When I went back to the list of participants, 37 rows were created out of the 414 in my csv file despite the error (see screenshots).

Can someone let me know what goes wrong here and why*?
Thanks in advance.

Kind regards
Laura
 

Hi,

1. The Li?ge issue is because there is a mismatch of character sets.
I can reproduce this if I set "Western Europe / ISO 8859-1" in Notepad and keep the setting "automatic" in LimeSurvey.
Other combinations produce other "translations" of the accent.


Check your settings.

2. There seems to be an issue in a row starting with "CAMP...", maybe "CAMPUS"? The program complains about a character at the start of this line.
To help, it would be advisable you'd send the file.

Joffm

 

Hi Joffm

Indeed, West Europ was the default charaters set in LibreOffice but not supported by LS.
I have changed it to Unicode UTF 8 which is supported by LS.

Thanks a lot for your help!
Laura