Welcome to the LimeSurvey Community Forum

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

Restore or export old answer tables

  • cblue3000
  • cblue3000's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 10 months ago #95916 by cblue3000
Restore or export old answer tables was created by cblue3000
Hi!

I had to alter one of my surveys after a few responses. So, i'd like to export the old answers, too. How can I do this? I have the name of the old answer table as shown in the deactivation message.

cblue
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
10 years 10 months ago #95948 by Mazi
Replied by Mazi on topic Restore or export old answer tables
First, please read the warning when de-activating a survey. because that should tell you that you will NOT be able to access the old responses at the backup table after deactivation.
Now that the survey structure has changed, it will be a hassle to access that old data at all. You probably need direct DB access to grab the data and then need to create a CSV file out of it which you can try to import using VV import at Limsurvey. But again, several modifications to the data file are needed.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
  • cblue3000
  • cblue3000's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 10 months ago #95999 by cblue3000
Replied by cblue3000 on topic Restore or export old answer tables
Hey, danke für die Antwort!

I remember doing this all the time when I was working with Limesurvey a few years ago, but I simply forgot the steps! that was when we had our own server...

I just need the answers (about 5 responses) in any TXT or Excel format.

So, its basically like this: I'll have to go directly to the DB on the server? Where exactly are the datasets kept? Is there something like a step-by-step guide?

Thanks!!
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
10 years 10 months ago #96031 by Mazi
Replied by Mazi on topic Restore or export old answer tables
If you do NOT change the survey structure, then there is a feature to get the results of a de-activated survey back into Limesurvey, see: manual.limesurvey.org/General_FAQ#How_ca...eactivated_survey.3F

If the structure has changed, you need to adjust the header and data sets at the VV file.

To access the results directly via the BD, search for the lime_survey_12345 table where 12345 is the survey ID.
(Sorry, there is no step-by-step guide.)

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
More
10 years 1 month ago #104657 by eliminator
Replied by eliminator on topic Restore or export old answer tables
Hi Mazi,
I deactivated my survey a few days ago, because data collection is finished and all data stored. Really all data? Yesterday I realized that I actually still wanted to copy the timings data (unluckily, I didn´t find a way to download it, that´s why I postponed it) - but now, of course, they are gone as well. Is there any chance to restore them?
I didn´t quite understand the instruction given in the manual:

"Then, and only then the following steps will work:
Activate your survey again
Go to the "Browse responses for this survey" menu.
Click at the "Import answers from a deactivated survey table" button."

Where do I find this button? I couldn´t find it yet, although logged in as admin.
I would be very grateful for help!
Eli (or tragically true: eliminator :blush: )
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
10 years 1 month ago #104658 by Mazi
Replied by Mazi on topic Restore or export old answer tables
Re-activate the survey, go to the browse response screen and search for this icon:


Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Attachments:
The topic has been locked.
More
10 years 1 month ago #104659 by eliminator
Replied by eliminator on topic Restore or export old answer tables
Oh Mazi,
great, thanks a lot for your quick answer!
"Choose your source table.
Click at the "Import responses" button. "
- done -
So, I succeeded with importing it - but how do I export it now?
Sorry, I´m really a greenhorn!
Eli
The topic has been locked.
More
10 years 1 month ago #104660 by Ben_V
Replied by Ben_V on topic Restore or export old answer tables
have a look at vv functions (import and export) at the same page

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Attachments:
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
10 years 1 month ago #104662 by Mazi
Replied by Mazi on topic Restore or export old answer tables
...and if you want to export to Excel or CSV check the 7th icon from the left.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
More
10 years 1 month ago #104664 by eliminator
Replied by eliminator on topic Restore or export old answer tables
Dear Ben, dear Mazi
thanks a lot for your answers!

So I should not chose export VV but the "normal" survey dataset download (black circle)?



There, how do I find the old survey data recently imported? (I only see that of the newly activated and thus empty version)
Will the timings be included there?

Eli
Attachments:
The topic has been locked.
More
10 years 1 month ago #104668 by eliminator
Replied by eliminator on topic Restore or export old answer tables
Okay, sorry, I think I got the point.
I imported a wrong old file first, but a later one was correct and contained the right data.
But I didn´t manage yet to retrieve the timings data - the table remains empty. What could I do?
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose