Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Moving a survey (with responses) from one server to another

Moving a survey (with responses) from one server to another 4 years 8 months ago #76622

  • tacman1123
  • tacman1123's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 125
  • Thank you received: 1
  • Karma: 1
How does one move a survey, with responses, from one server to another?

I would have thought that exporting to a vv file and then importing it would work, but because the survey id changes that isn't true:

bugs.limesurvey.org/view.php?id=5902

So it is possible? Hard to believe that a system this powerful would lack the ability to move a survey, with responses, from one system to another, but I've tried a few forms of export / import, and nothing works.

Tac
The topic has been locked.

Aw: Moving a survey (with responses) from one server to another 4 years 8 months ago #76643

  • dreier
  • dreier's Avatar
  • Offline
  • Junior Lime
  • Posts: 24
  • Thank you received: 2
  • Karma: 3
Hello,

I didn't try it myself, but wouldn't an easy sql dump doesn't make the job here? Dump your database and "import" it into the database of the new system. Then you should have the survey and the responses.

Greetings
dreier
The topic has been locked.

Aw: Moving a survey (with responses) from one server to another 4 years 8 months ago #76646

  • tacman1123
  • tacman1123's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 125
  • Thank you received: 1
  • Karma: 1
That will only work if you're importing everything. But you can't just move one survey.

The 'hack' way I've come up with:
  1. Export the Survey as an lss file
  2. Import it to the New System
  3. Export the VV file from the old system
  4. Export the (empty) VV file from the new system
  5. Open both VV files in an editor
  6. Turn off the "Tabs->Spaces" setting
  7. Append the data from from the old vv file to the new vv file
  8. Import.

This messy process exists because of the tight dependencies on SGQA, instead of using unique question_codes + answer_codes to define the database fields. Maybe 2.0 will use a different approach.

Tac
The topic has been locked.
The following user(s) said Thank You: snoel115

Aw: Moving a survey (with responses) from one server to another 4 years 8 months ago #76671

  • Steve01
  • Steve01's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 493
  • Thank you received: 47
  • Karma: 17
Hello,

I heared that there is a new approach in LimeSurvey 2.0 which should make it possible to export the complete survey and not the survey logic + results in two seperate files. Though I don't know the current status of this feature.
Mit freundlichen Grüßen/Best regards,

Stefan Gohlke
LimeSurvey Team
The topic has been locked.

Aw: Moving a survey (with responses) from one server to another 2 months 3 weeks ago #141582

  • snoel115
  • snoel115's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
Just a quick note, to import the data the new survey must be active
The topic has been locked.

Moving a survey (with responses) from one server to another 2 months 3 weeks ago #141606

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6570
  • Thank you received: 1477
  • Karma: 579
This thread is obsolete. Now you can export/import the complete survey structure, data, token table and timings with the .lsa format - manual.limesurvey.org/Exporting_a_survey...y_archive_.28.lsa.29
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
Time to create page: 0.211 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form