Welcome to the LimeSurvey Community Forum

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

Unable to import CSV participant table

More
7 years 1 month ago - 7 years 1 month ago #159002 by dhel
What am I doing wrong? Try to import a CSV file into LS Version 2.67.2
Following the manual, and what I would expect LS to do, is to offer a mapping overview. But I do not get any apportunity to map anything!


I don't get any CSV field names...

After this screen...



I only get a button to upload, after which I get the final result where only email address matches, other fields were not imported.




Help?

Regards, Daniel
Last edit: 7 years 1 month ago by dhel.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 1 month ago #159004 by Joffm
Replied by Joffm on topic Unable to import CSV participant table
Hello, dhel,
a sample of your csv will be appreciated.

What do you expect us to say, if you really followed all the instructions.
Can be charset, can be typo, can be...

Best regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
More
7 years 1 month ago #159018 by dhel
Replied by dhel on topic Unable to import CSV participant table
The CSV that did not work out...
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 1 month ago - 7 years 1 month ago #159024 by Joffm
Replied by Joffm on topic Unable to import CSV participant table
Hello, dhel,

according to the manual:

Your CSV file must be a standard CSV (Comma Separated Value) file. The first line of text is always the header information and will be used to identify the field data. Possible data fields are:

firstname,lastname,email,emailstatus,token,language code,tid,attribute_1,attribute_2, attribute_...


So your csv header should be like:

attribute_1;attribute_2;email;attribute_3;attribute_4;attribute_5


In the attribute management you can use "LevNaam", "taalOrig", and so.

One recommendation: Use the "language". Otherwise all your participants will get the default language.


Best regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 7 years 1 month ago by Joffm.
The following user(s) said Thank You: tastymouse
The topic has been locked.
More
7 years 1 month ago #159031 by dhel
Replied by dhel on topic Unable to import CSV participant table
Hi Joffm,

thanks for the info! I was not aware about (and did not read so in the manual) that the headers are not free to choose... I understood LS would bring up a mapping screen where the header of the CSV could be mapped onto the corresponding header of LS ...

I'll try again with proper headers and see what hapens now.
The topic has been locked.
More
7 years 1 month ago #159032 by dhel
Replied by dhel on topic Unable to import CSV participant table
import successful!
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose