Recover partially saved responses

More
3 weeks 3 days ago #191207 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?

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
3 weeks 3 days ago #191209 by blocka
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?

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!