- Posts: 73
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Mass Editing Participants in Active Survey
- BBCMResearch
- Topic Author
- Offline
- Senior Member
Less
More
7 years 6 months ago #141867
by BBCMResearch
Mass Editing Participants in Active Survey was created by BBCMResearch
Long story short, I need to change the value of a pre-set attribute from 0 to 1 for 10% of my participant list, or about 2800 entries in an active survey with a preset sample, and I'm trying to figure out the best way to do it without losing response data.
I cannot wait until the survey closes because 1s and 0s have different branched questions. If I take the survey offline and repopulate with a corrected sample, minus completed responses, I'll lose the response data for incomplete entries, right?
Can anyone think of a solution to my problem?
I cannot wait until the survey closes because 1s and 0s have different branched questions. If I take the survey offline and repopulate with a corrected sample, minus completed responses, I'll lose the response data for incomplete entries, right?
Can anyone think of a solution to my problem?
The topic has been locked.
- davebostockgmail
- Offline
- Elite Member
Less
More
- Posts: 166
- Thank you received: 26
7 years 6 months ago #141877
by davebostockgmail
Replied by davebostockgmail on topic Mass Editing Participants in Active Survey
By editing participants in a survey do you mean changing a value in the token table?
If that is the case and you have some way of identifying the ones you want to change .. say a variable in the token table that is set as GroupA, GroupB and GroupC, then it would be just a case of identifying the table in the database and running an update query ..
As an example .. if the Identifying Variable is Attribute1 in the table and the one you wanted to update was Attribute5 then the sql code would be....
UPDATE `surveys`.`[Your Token Table]` SET `attribute_5`='1' WHERE `attribute_1`='GroupA';
This will update the table for all participants who have a value of GroupA
Hope this helps
If that is the case and you have some way of identifying the ones you want to change .. say a variable in the token table that is set as GroupA, GroupB and GroupC, then it would be just a case of identifying the table in the database and running an update query ..
As an example .. if the Identifying Variable is Attribute1 in the table and the one you wanted to update was Attribute5 then the sql code would be....
UPDATE `surveys`.`[Your Token Table]` SET `attribute_5`='1' WHERE `attribute_1`='GroupA';
This will update the table for all participants who have a value of GroupA
Hope this helps
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10611
- Thank you received: 3691
7 years 6 months ago #141903
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 Mass Editing Participants in Active Survey
See this post about editing the token table -
www.limesurvey.org/forum/can-i-do-this-w...-participants#141902
Of course, editing that table will not affect how the attribute was used in any completed survey or how it was used in any incomplete survey that has progressed beyond the attribute use. (does that make sense?)
Of course, editing that table will not affect how the attribute was used in any completed survey or how it was used in any incomplete survey that has progressed beyond the attribute use. (does that make sense?)
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: BBCMResearch
The topic has been locked.