- Posts: 5
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Export Answers of an old survey direct from Database
- lsuser3112
- Topic Author
- Offline
- New Member
Less
More
4 years 7 months ago - 4 years 7 months ago #188049
by lsuser3112
Export Answers of an old survey direct from Database was created by lsuser3112
Hi,
i have a database from an old limesurvey application server. The server is gone but i still need to export answer tables.
So i do this direct in the database but the answers in the old_survey_xxx table are codes. The text for the codes is in the answer table. When I 'decode' the answers, the result is incorrect. Example:
1 stands for "male" and 2 for "female"... but when i replace the codes in the old_survey_xxx table with the corresponding answer in the answers table it get:
Person_FirstName Person_Gender(column to decode)
Peter female
Claudia male
Johannes female
seems wrong to me. Where is the failure here? Is it a Problem, when the order of the answers had changed?
Thank you for your help,
i have a database from an old limesurvey application server. The server is gone but i still need to export answer tables.
So i do this direct in the database but the answers in the old_survey_xxx table are codes. The text for the codes is in the answer table. When I 'decode' the answers, the result is incorrect. Example:
1 stands for "male" and 2 for "female"... but when i replace the codes in the old_survey_xxx table with the corresponding answer in the answers table it get:
Person_FirstName Person_Gender(column to decode)
Peter female
Claudia male
Johannes female
seems wrong to me. Where is the failure here? Is it a Problem, when the order of the answers had changed?
Thank you for your help,
Last edit: 4 years 7 months ago by lsuser3112. Reason: Problems with exporting Data direct from the database
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 7 months ago - 4 years 7 months ago #188097
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Export Answers of an old survey direct from Database
If you don't have the lss file (or better an LSA) : you can't have a easy clean solution.
With only the data from SQL : you must update each answer code by their answer etc …
PS : if the DB is complete : why not install a new (or old) version linked to this DB ?
Then you can import data from old survey
With only the data from SQL : you must update each answer code by their answer etc …
PS : if the DB is complete : why not install a new (or old) version linked to this DB ?
Then you can import data from old survey
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 4 years 7 months ago by DenisChenu. Reason: PS
The following user(s) said Thank You: lsuser3112
The topic has been locked.
- lsuser3112
- Topic Author
- Offline
- New Member
Less
More
- Posts: 5
- Thank you received: 0
4 years 7 months ago #188099
by lsuser3112
Replied by lsuser3112 on topic Export Answers of an old survey direct from Database
Hi Denis,
thank you very much for your help. We followed your advice and installed a new old LimeSurvey Server and exported the files. The Problem is, that we still don't get the correct decoding for some answers (especially the answers which had changed).
Do we have to import an .lss or .lsa file into the survey before we can export the data? We have this files on an backup server.
Thank you!
thank you very much for your help. We followed your advice and installed a new old LimeSurvey Server and exported the files. The Problem is, that we still don't get the correct decoding for some answers (especially the answers which had changed).
Do we have to import an .lss or .lsa file into the survey before we can export the data? We have this files on an backup server.
Thank you!
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 7 months ago #188101
by DenisChenu
If you have an LSA with the old answer value : you can import it in any LimeSurvey version and export.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Export Answers of an old survey direct from Database
How you think LimeSurvey can keep old value … you must remind the old code …lsuser3112 wrote: that we still don't get the correct decoding for some answers (especially the answers which had changed).
Not necessary : i think if you only have lime_survey_orf.csv, then have an lss can help.Do we have to import an .lss or .lsa file into the survey before we can export the data? We have this files on an backup server.
If you have an LSA with the old answer value : you can import it in any LimeSurvey version and export.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: lsuser3112
The topic has been locked.
- lsuser3112
- Topic Author
- Offline
- New Member
Less
More
- Posts: 5
- Thank you received: 0
4 years 7 months ago #188108
by lsuser3112
Replied by lsuser3112 on topic Export Answers of an old survey direct from Database
Hi Denis,
ok. Thank you for the help.
Best regards,
ok. Thank you for the help.
Best regards,
The topic has been locked.