View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|11627||Feature requests||Other||public||2016-09-06 14:42||2016-09-21 12:02|
|Summary||11627: Import .csv to update participant data|
|Description||I'd like to be able to update participant data on a live survey via .csv import. This would primarily be to change existing records rather than add new. Say, to update `firstname` via a .csv import with two fields: `email` (the key) and `firstname`.|
Thanks for considering the request.
|Additional Information||As mentioned in the forum 'Can I do this with LimeSurvey?' https://www.limesurvey.org/forum/can-i-do-this-with-limesurvey/106946-update-participants-data-on-live-survey#141366|
|Tags||No tags attached.|
The real issue with dataoperations like this is that LimeSurvey has no pause mode.
A pause mode which e.g let no new probands on the survey, but let the others finish their interviews.
The time gap between exporting and importing can cause change of data which is lost.
Currently there is only an importmode under "Create Entries".
Since there is an Export Button, I would favor an Import Button for the other import modes. Update and Replace. Replace overwrites everything with the CSV content. Update will only replace nonempty cells.
That way you can update data without overwriting everything else.
Thanks for the comment. The use-case that brought me here (my first survey): a mistake with the original Create->Import->.csv - where only the first 50 records had a valid `firstname` (the `lastname` field wasn't used) - the rest were populated with "O". So, in this case, I'd want the import/update to overwrite a non-empty field.
(Luckily, or by great design, the bounces suggest that the single character names were not used in the To header - they went as "To: firstname.lastname@example.org" rather than "To: O <email@example.com>").