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?
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
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
