- Posts: 129
- Thank you received: 6
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Changing SGQA codes following export/import from one instance of LS to another
- mascarpone
- Topic Author
- Offline
- Premium Member
Less
More
10 years 2 weeks ago #107238
by mascarpone
Changing SGQA codes following export/import from one instance of LS to another was created by mascarpone
Dear all,
I feel there may not be an easy answer on this but here is our challenge: we have realized that SGQA are "instance specific" and that they will change when re-importing a survey on a different instance of LS.
The problem we have faced with this is related to the automated analysis/reporting features that we have developed around our surveys and that would need to be recoded after each transfer. I realize it is probably not usual to transfer surveys like this. In our case we are openly sharing our work with a bunch of other partner agencies - and as such promoting further the use of LS - and that includes the analysis/reporting scripts. We are therefore looking at a way of getting this "connection" stable.
As anybody faced this issue before and found an elegant way of solvin/working around it?
Cheers!
Mas
I feel there may not be an easy answer on this but here is our challenge: we have realized that SGQA are "instance specific" and that they will change when re-importing a survey on a different instance of LS.
The problem we have faced with this is related to the automated analysis/reporting features that we have developed around our surveys and that would need to be recoded after each transfer. I realize it is probably not usual to transfer surveys like this. In our case we are openly sharing our work with a bunch of other partner agencies - and as such promoting further the use of LS - and that includes the analysis/reporting scripts. We are therefore looking at a way of getting this "connection" stable.
As anybody faced this issue before and found an elegant way of solvin/working around it?
Cheers!
Mas
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11639
- Thank you received: 2738
10 years 2 weeks ago #107249
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Changing SGQA codes following export/import from one instance of LS to another
Of course the SGQA code changes when you import a survey (even on the same instance), because they need to be unique (especially the S = Survey portion). I don't see a way around this. Maybe someone else or one of th developers does, but I do have little hope.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: mascarpone
The topic has been locked.
- byan
- Offline
- Junior Member
Less
More
- Posts: 39
- Thank you received: 11
10 years 2 weeks ago #107267
by byan
Replied by byan on topic Changing SGQA codes following export/import from one instance of LS to another
I think as long as your survey title and qids remain the same, you should be able to achieve your goal by joining the lime_surveys_languagesettings, question, answer, your survey tables.
The following user(s) said Thank You: mascarpone
The topic has been locked.
- DenisChenu
- Away
- LimeSurvey Community Team
Less
More
- Posts: 13619
- Thank you received: 2488
10 years 2 weeks ago - 10 years 2 weeks ago #107279
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 Changing SGQA codes following export/import from one instance of LS to another
Hi,
Maybe you can use "EM code" in your data anlysi, and have a 'EM code to SGQA' system.
github.com/LimeSurvey/LimeSurvey/blob/ma...dmin/export.php#L682
Better link from code:
github.com/LimeSurvey/LimeSurvey/blob/ma...ort_helper.php#L4437
Maybe you can use "EM code" in your data anlysi, and have a 'EM code to SGQA' system.
github.com/LimeSurvey/LimeSurvey/blob/ma...dmin/export.php#L682
Better link from code:
github.com/LimeSurvey/LimeSurvey/blob/ma...ort_helper.php#L4437
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: 10 years 2 weeks ago by DenisChenu. Reason: Better link from code:
The following user(s) said Thank You: mascarpone
The topic has been locked.
- mascarpone
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 129
- Thank you received: 6
10 years 2 weeks ago #107302
by mascarpone
Replied by mascarpone on topic Changing SGQA codes following export/import from one instance of LS to another
Thanks all for your replies and suggestions. We will probably move to the solution proposed by Denis and implement some sort of a mapping table between our analysis script and EM Codes so that we may share our work more easily with others!
Merci!
Merci!
The topic has been locked.