Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:
  • Seite:
  • 1
  • 2

THEMA: Restore or export old answer tables

Restore or export old answer tables 1 Jahr 4 Monate her #95916

  • cblue3000
  • cblue3000s Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 2
  • Karma: 0
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 1 Jahr 4 Monate her #95948

  • Mazi
  • Mazis Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 5325
  • Dank erhalten: 296
  • Karma: 249
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
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 1 Jahr 4 Monate her #95999

  • cblue3000
  • cblue3000s Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 2
  • Karma: 0
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!!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 1 Jahr 4 Monate her #96031

  • Mazi
  • Mazis Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 5325
  • Dank erhalten: 296
  • Karma: 249
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
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 7 Monate 2 Wochen her #104657

  • eliminator
  • eliminators Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 9
  • Karma: 0
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: )
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 7 Monate 2 Wochen her #104658

  • Mazi
  • Mazis Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 5325
  • Dank erhalten: 296
  • Karma: 249
Re-activate the survey, go to the browse response screen and search for this icon:

x.png

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'"
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 7 Monate 2 Wochen her #104659

  • eliminator
  • eliminators Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 9
  • Karma: 0
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 7 Monate 2 Wochen her #104660

  • Ben_V
  • Ben_Vs Avatar
  • OFFLINE
  • Platinum Lime
  • Beiträge: 1082
  • Dank erhalten: 240
  • Karma: 76
have a look at vv functions (import and export) at the same page
x2.png
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 7 Monate 2 Wochen her #104662

  • Mazi
  • Mazis Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 5325
  • Dank erhalten: 296
  • Karma: 249
...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
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Restore or export old answer tables 7 Monate 2 Wochen her #104664

  • eliminator
  • eliminators Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 9
  • Karma: 0
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)?

x2.png


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
Der Administrator hat öffentliche Schreibrechte deaktiviert.
  • Seite:
  • 1
  • 2
Moderatoren: ITEd
Ladezeit der Seite: 0.164 Sekunden
Donation Image