Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Participant CSV Import Chinese Error

More
9 years 11 months ago - 9 years 11 months ago #126465 by StefanBasen
Hi everyone,

im doing a Survey for Participants in China. So i prepared an Excel File for this. Everything under A is the "language" Attribute, B has firstname, C lastname,D email and E has attribute_1 ( for Sir or Ms. ). When in now try to import that File into the Participant Database for the Survey, LS changes all Names that are written in chinese into a Questionmark. Tried to manually add a participant and with this the chinese stays but only when im importing participants via CSV File LS adds ? instead of the chinese first or lastname. So what im doing wrong? How can i import the participants? Thing is, the File has more thann 500 Participants and add them all manually takes tons of time.

Best Regards
Last edit: 9 years 11 months ago by StefanBasen.
The topic has been locked.
More
9 years 11 months ago #126469 by holch
Most probably has something to do with the coding of the CSV (e.g. UTF8), but I am no expert on this so not much of a help. But I guess you should research into this direction.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The following user(s) said Thank You: StefanBasen
The topic has been locked.
More
9 years 11 months ago #126535 by StefanBasen
With Libre Office i was able to save the CSV as UTF 8 Unicode. But LS doesnt accept the Data. It Says while import:

548 Datasets in CSV-File
548 Datasets met the requirements
0 Datasets imported

548 Datasets with invalid E-Mail-Adress removed.

And even when i use that Checkbox wich said "Allow invalid Email Adress" LS dont let me import those Participants. I even tried to ignore the Email Adress so what can i do?
The topic has been locked.
More
9 years 11 months ago #126566 by DenisChenu
Hi,

Can you upload a partial part of your files : only one line and a false adress (with @example.org for example).

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
9 years 11 months ago #126570 by StefanBasen
Here is the requested File. Hopefuly you can find that error. Otherwise i have to add all participants manually ( wich are about 500+) . The File was saved in CSV via Libre office. Filteroptions were set to UTF8 Unicode. Also tried simplified chinese but nothing works :(
The topic has been locked.
More
9 years 11 months ago - 9 years 11 months ago #126575 by DenisChenu
The CSV look like :
Code:
,,,,
attribute_1,firstname,lastname,language,email
,,,,
尊敬的陈先生,您好!,伟彬,,zh-Hans,1012122@example.com
Importing in LibreOO show 2 empty line : firt line MUST be attribute_1,firstname,lastname,language,email

PS: removing this empty line, and this file import without issue.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
Last edit: 9 years 11 months ago by DenisChenu. Reason: PS
The topic has been locked.
More
9 years 11 months ago #126578 by StefanBasen
OMG! You Guys rock! It finally works. So small stuff and such big problems. Thank you so much!
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose