Changing SGQA codes following export/import from one instance of LS to another

More
2 years 11 months ago #107238 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

Please Log in to join the conversation.

More
2 years 11 months ago #107249 by holch
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'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
The following user(s) said Thank You: mascarpone

Please Log in to join the conversation.

More
2 years 11 months ago #107267 by byan
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

Please Log in to join the conversation.

More
2 years 11 months ago - 2 years 11 months ago #107279 by DenisChenu
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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
Last Edit: 2 years 11 months ago by DenisChenu. Reason: Better link from code:
The following user(s) said Thank You: mascarpone

Please Log in to join the conversation.

More
2 years 11 months ago #107302 by mascarpone
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!

Please Log in to join the conversation.