Dear limesurvey community

I am using LimeSurvey Version 4.1.16+200407

I have made a survey and distributed it, but after receiving some additional funding, I would like to contact some of the participants again for a followup survey. I do not have that much experience with limesurvey, and i am unsure how it is possible to do so. In the first survey, i have a question (type Long free text (T)) with their name, their email address and an array question for rather or not i am allowed to contact them again for two different purposes. How can I add the participants who gave permission for me to contact them again to the second survey? And is it possible to connect their answers in the first survey to their answers in the second?

Kind regards Marie

Hi Marie,

you can make an Excel file of the people that gave you permission to contact them again, export that excel file to CSV and upload that to the token tabel of the second survey that you want to send out.

After receiving the results, you can join the results using the email addresses in the to exported tables.

This in short. If you need a more elaborate answer, this will take some more time, depending on your experience with LimeSurvey.

Hi, Marie,
as I understand, this first survey is an open survey.
You have name and email only within the data fields of the survey, in this question of type "long text".
For your follow up survey, which should be a closed one with tokens (but not anonymous), you have to create a participant table.
1. You export the survey to EXCEL.
2.a. Either You type the information of the text field into a different sheet.
2.b. Or you may try to extract the parts by an EXCEL macro. (Probably difficult, because the data have to be in the same structure)
3. Read the chapter in the manual about uploading participants data from *.csv
www.limesurvey.org/manual/Survey_partici...ants_from_a_CSV_file
4. Add an attribute, where you enter the ID of the answer table.
www.limesurvey.org/manual/Survey_participants#Manage_attributes
5. Save your data (mandatory "firstname", "lastname", "email" and the attribute "attribute_1") as *.csv
6. Import into your follow up survey.
7. Send invitations

And because each participant has as attribute the answer ID of the first survey you may merge them.

Joffm

With Tammo: If you use the email address to merge the surveys you do not need the attribute.

Thank you so much. This was very helpful! I will play around with it, i might write back with a follow up question. Have a great day

Thank you so much, this was very helpful! Have a great day!