Welcome, Guest
Username: Password: Remember me

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

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

  • tacman1123
  • tacman1123's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 125
  • 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 administrator has disabled public write access.

Aw: Moving a survey (with responses) from one server to another 2 years 6 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 administrator has disabled public write access.

Re: Aw: Moving a survey (with responses) from one server to another 2 years 6 months ago #76646

  • tacman1123
  • tacman1123's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 125
  • 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 administrator has disabled public write access.

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

  • Steve
  • Steve's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 494
  • Thank you received: 46
  • 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 administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.115 seconds
Donation Image