Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Recover partially saved responses

  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
4 years 4 months ago #191207 by blocka
Recover partially saved responses was created by blocka
I had a survey where I had to deactivate it, make some structural changes, and then import the VV file with the response data.

The survey had two partially saved responses, seen in the table _saved_control

When imported the VV file, the partially saved responses were not included.

Thankfully out of 2000 responses, only two were partials. But if it had been a hundred (easy on a large survey), their
loss would have been much more problematic.

So, I wonder -- where are those partials saved? And is there a way to view them or access the data, and restore them (even if it means DBA or data entry work) to the survey again?
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
4 years 4 months ago #191209 by blocka
Replied by blocka on topic Recover partially saved responses
As an update, I have discovered that their responses were in the VV file, and that they are back in the response table.

But, the record of this has been deleted from the table _saved_control

I have imported the two missing records from a backup -- but:
(a) will this work for the respondent? and
(b) any thoughts about how this could averted in the future?
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose