Check out the LimeSurvey source code on GitHub!

Retrieving Lost Data!

More
5 years 2 weeks ago #73971 by hsk13
I deactivated a survey and, in doing so, lost all of the previous responses to my survey. I was wondering if it was possible to retrieve those lost responses?

Please Log in to join the conversation.

More
5 years 2 weeks ago #73980 by paulfiner
The results should be stored in the MySQL database in a table containing the survey number.
Use a tool to read the database and export the data.

Please Log in to join the conversation.

More
5 years 2 weeks ago - 5 years 2 weeks ago #73985 by holch
Yes, you actually can:

docs.limesurvey.org/Closing+a+survey&highlight=lost%20data

Go down to the bottom: "Help! I accidentally deactivated my survey - what now?"

But better read the whole page.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
Last Edit: 5 years 2 weeks ago by holch.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

More
5 years 2 weeks ago #73996 by Mazi


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
5 years 2 weeks ago #74058 by hsk13
Unfortnately, I did add questions to my survey after deactivating it so it looks like I will be unable to just import the data from the deactivated survey.

However when I click on 'check data integrity', under Data redundancy check it says that old survey response tables containing responses still exist. Is it possible to access and open these response tables? If they still exist it seems like I should be able to open them individually, even if it is not by importing them into my current survey. Is this possible??

Thanks everyone for your help!

Please Log in to join the conversation.

More
5 years 2 weeks ago #74096 by DenisChenu
Hello,

A solution can be:
Export actual survey in VV format. Export old survey answer in CSV format ( via phpMyAdmin for example).

Then put the answer from CSV file in the VV file ( remove the actual answer) ( a solution are to use LibreOffice calc to manipulate VV and CS file: VV file have TAB for separate value.)

Attention to 'Response ID' (remove the duplicate Response ID).

After import the new CSV/VV file in the survey answer.

I already done this for some client, it's not very difficult.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
5 years 2 weeks ago #74126 by Mazi
Of course this doesn't work if you have changed the original survey because e. g. the number of columns won't match.
If the data still exists at the database, you can use tools like phpmyadmin to export the data.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
5 years 2 weeks ago #74136 by DenisChenu

Mazi wrote: Of course this doesn't work if you have changed the original survey because e. g. the number of columns won't match.
If the data still exists at the database, you can use tools like phpmyadmin to export the data.

Yep,

You need to control each column matching from one file with another file. Without phpMyadmin or some other tool like ( or a php script and acces to database), it's impossible :)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form