- Posts: 32
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Adding information to an existing participation table with csv file
- Surveylab_KN
- Topic Author
- Offline
- Junior Member
Less
More
2 years 4 months ago #222677
by Surveylab_KN
Adding information to an existing participation table with csv file was created by Surveylab_KN
Hi,
is it possible to add information for attributes in the participation table with a csv file to existing particpants?
I am planing a closed survey with a fixed number of participants, which I will upload before the survey starts. So I have a table of survey participants. But the participants will be able to fill in the survey several times and I would like to add some information to survey participants table (through the import of attributes in a csv file) after the survey started.
Thanks
(Limesurvey Version 3.22.5+200218 )
is it possible to add information for attributes in the participation table with a csv file to existing particpants?
I am planing a closed survey with a fixed number of participants, which I will upload before the survey starts. So I have a table of survey participants. But the participants will be able to fill in the survey several times and I would like to add some information to survey participants table (through the import of attributes in a csv file) after the survey started.
Thanks
(Limesurvey Version 3.22.5+200218 )
The topic has been locked.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 967
- Thank you received: 220
2 years 4 months ago #222685
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Adding information to an existing participation table with csv file
I am not sure, but first I would try if it is possible to add an attribute to an active survey. If not, that will be a bottleneck which you can circumvent by (before activating) adding several attributes (empty attributes) which you can fill later. I guess you will have to keep track of what attribute contains what then...
Tammo
Tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12935
- Thank you received: 3979
2 years 4 months ago #222687
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Adding information to an existing participation table with csv file
Hi,
"to add some information".
If these informations are based on answers in the previous round, you may use a plugin "updateTokenByResponse".
Otherwise ???
Joffm
"to add some information".
If these informations are based on answers in the previous round, you may use a plugin "updateTokenByResponse".
Otherwise ???
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 967
- Thank you received: 220
2 years 4 months ago #222702
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Adding information to an existing participation table with csv file
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The following user(s) said Thank You: DenisChenu, tpartner
The topic has been locked.
- Surveylab_KN
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
2 years 4 months ago #222714
by Surveylab_KN
Replied by Surveylab_KN on topic Adding information to an existing participation table with csv file
Thanks for the tip with the plugin.
I want to show the respondents how often they have already filled in the survey. I assume this is something I have to do in a statistical program, which is totally fine for me. But I would like to upload the addtional information. And as the survey is taking part, I can't delete the particpant table and upload a complete new one.
I want to show the respondents how often they have already filled in the survey. I assume this is something I have to do in a statistical program, which is totally fine for me. But I would like to upload the addtional information. And as the survey is taking part, I can't delete the particpant table and upload a complete new one.
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10109
- Thank you received: 3595
2 years 4 months ago #222721
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Adding information to an existing participation table with csv file
If you have access to the server, you could use AJAX and the API to check for previous responses.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- Surveylab_KN
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
2 years 4 months ago #222730
by Surveylab_KN
Replied by Surveylab_KN on topic Adding information to an existing participation table with csv file
Yes, I have access to the server. But I think it is ok to download the data and run some routine in an external program. At the moment my bigger problem is to upload the additional data in Limesurvey to extend the participants table without editing each participants by hand.
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12935
- Thank you received: 3979
2 years 4 months ago #222731
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Adding information to an existing participation table with csv file
Hi,
I think Tony is talking about an AJAX call.
Here you may query the survey for previous answers and update the attribute of the table
Here in "lime_tokens_123456"
Joffm
I think Tony is talking about an AJAX call.
Here you may query the survey for previous answers and update the attribute of the table
Here in "lime_tokens_123456"
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- Surveylab_KN
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
2 years 4 months ago #222735
by Surveylab_KN
Replied by Surveylab_KN on topic Adding information to an existing participation table with csv file
Thanks. That seems to do what I need, but I think my technical knowledge isn't sufficient for this. I
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
2 years 4 months ago #222752
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 Adding information to an existing participation table with csv file
With version up to 4.X : you can count number of answered response by token (if i don't make error)
manual.limesurvey.org/StatFunctions
manual.limesurvey.org/StatFunctions
Code:
statCountIf('token', TOKEN)
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.