Welcome to the LimeSurvey Community Forum

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

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

  • tacman1123
  • tacman1123's Avatar Topic Author
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
12 years 1 week ago #76622 by tacman1123
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.
More
12 years 1 week ago #76643 by dreier
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.
  • tacman1123
  • tacman1123's Avatar Topic Author
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
12 years 1 week ago #76646 by tacman1123
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 following user(s) said Thank You: snoel115
The topic has been locked.
  • Steve01
  • Steve01's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
12 years 1 week ago #76671 by Steve01
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.
More
7 years 6 months ago #141582 by snoel115
Just a quick note, to import the data the new survey must be active
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 6 months ago #141606 by tpartner
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.

Lime-years ahead

Online-surveys for every purse and purpose