- Posts: 8
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Problem when importing csv file (with commas and double quotes) for invitation
- laura.bonacini
- Topic Author
- Offline
- New Member
Less
More
1 year 10 months ago - 1 year 10 months ago #229860
by laura.bonacini
Problem when importing csv file (with commas and double quotes) for invitation was created by laura.bonacini
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
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
Attachments:
Last edit: 1 year 10 months ago by laura.bonacini.
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12997
- Thank you received: 3999
1 year 10 months ago #229864
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Problem when importing csv file (with commas and double quotes) for invitation
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
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
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- laura.bonacini
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
1 year 10 months ago #229868
by laura.bonacini
Replied by laura.bonacini on topic Problem when importing csv file (with commas and double quotes) for invitation
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
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
Please Log in to join the conversation.