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
  • Surveylab_KN's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 4 months ago #222677 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 )
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
2 years 4 months ago #222685 by tammo
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 ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 4 months ago #222687 by Joffm
Hi,
"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
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
2 years 4 months ago #222702 by tammo


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
  • Surveylab_KN's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 4 months ago #222714 by Surveylab_KN
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.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 4 months ago #222721 by tpartner
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
  • Surveylab_KN's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 4 months ago #222730 by Surveylab_KN
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
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 4 months ago #222731 by Joffm
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

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • Surveylab_KN
  • Surveylab_KN's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
2 years 4 months ago #222735 by Surveylab_KN
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
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 4 months ago #222752 by DenisChenu
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
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.

Lime-years ahead

Online-surveys for every purse and purpose