- Posts: 13
- Thank you received: 1
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
- Topic Author
- Offline
- LimeSurvey Community Team
Less
More
12 years 1 week ago #76622
by tacman1123
Moving a survey (with responses) from one server to another was created 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
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.
- dreier
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
12 years 1 week ago #76643
by dreier
Replied by dreier on topic Aw: Moving a survey (with responses) from one server to another
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
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
- Topic Author
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13
- Thank you received: 1
12 years 1 week ago #76646
by tacman1123
Replied by tacman1123 on topic Aw: Moving a survey (with responses) from one server to another
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:
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 'hack' way I've come up with:
- Export the Survey as an lss file
- Import it to the New System
- Export the VV file from the old system
- Export the (empty) VV file from the new system
- Open both VV files in an editor
- Turn off the "Tabs->Spaces" setting
- Append the data from from the old vv file to the new vv file
- 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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 18
- Thank you received: 6
12 years 1 week ago #76671
by Steve01
Mit freundlichen Grüßen/Best regards,
Stefan Gohlke
LimeSurvey Team
Replied by Steve01 on topic Aw: Moving a survey (with responses) from one server to another
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.
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.
- snoel115
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
7 years 6 months ago #141582
by snoel115
Replied by snoel115 on topic Aw: Moving a survey (with responses) from one server to another
Just a quick note, to import the data the new survey must be active
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10634
- Thank you received: 3698
7 years 6 months ago #141606
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Moving a survey (with responses) from one server to another
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.