Welcome, Guest
Username: Password: Remember me

TOPIC: Retrieving Lost Data!

Retrieving Lost Data! 2 years 7 months ago #73971

  • hsk13
  • hsk13's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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?
The administrator has disabled public write access.

Re: Retrieving Lost Data! 2 years 7 months ago #73980

  • paulfiner
  • paulfiner's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 92
  • Thank you received: 1
  • Karma: 1
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.
The administrator has disabled public write access.

Re: Retrieving Lost Data! 2 years 7 months ago #73985

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2671
  • Thank you received: 323
  • Karma: 121
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.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
Last Edit: 2 years 7 months ago by holch.
The administrator has disabled public write access.
The following user(s) said Thank You: DenisChenu

Re: Retrieving Lost Data! 2 years 7 months ago #73996

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: Retrieving Lost Data! 2 years 7 months ago #74058

  • hsk13
  • hsk13's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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!
The administrator has disabled public write access.

Re: Retrieving Lost Data! 2 years 7 months ago #74096

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6334
  • Thank you received: 817
  • Karma: 243
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
The administrator has disabled public write access.

Re: Retrieving Lost Data! 2 years 7 months ago #74126

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Retrieving Lost Data! 2 years 7 months ago #74136

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6334
  • Thank you received: 817
  • Karma: 243
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 :)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.123 seconds
Donation Image