- Posts: 39
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Participant CSV Import Chinese Error
- StefanBasen
- Topic Author
- Offline
- Junior Member
Less
More
8 years 6 months ago - 8 years 6 months ago #126465
by StefanBasen
Participant CSV Import Chinese Error was created 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
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: 8 years 6 months ago by StefanBasen.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11639
- Thank you received: 2737
8 years 6 months ago #126469
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Participant CSV Import Chinese Error
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: StefanBasen
The topic has been locked.
- StefanBasen
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 39
- Thank you received: 0
8 years 6 months ago #126535
by StefanBasen
Replied by StefanBasen on topic Participant CSV Import Chinese Error
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?
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.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
8 years 6 months ago #126566
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Participant CSV Import Chinese Error
Hi,
Can you upload a partial part of your files : only one line and a false adress (with @example.org for example).
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 service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- StefanBasen
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 39
- Thank you received: 0
8 years 6 months ago #126570
by StefanBasen
Replied by StefanBasen on topic Participant CSV Import Chinese Error
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
Attachments:
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
8 years 6 months ago - 8 years 6 months ago #126575
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Participant CSV Import Chinese Error
The CSV look like :
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.
Code:
,,,, attribute_1,firstname,lastname,language,email ,,,, 尊敬的陈先生,您好!,伟彬,陈,zh-Hans,1012122@example.com
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 service on demand , plugin development .
I don't answer to private message.
Last edit: 8 years 6 months ago by DenisChenu. Reason: PS
The topic has been locked.
- StefanBasen
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 39
- Thank you received: 0
8 years 6 months ago #126578
by StefanBasen
Replied by StefanBasen on topic Participant CSV Import Chinese Error
OMG! You Guys rock! It finally works. So small stuff and such big problems. Thank you so much!
The topic has been locked.