Welcome, Guest
Username: Password: Remember me

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

Changing SGQA codes following export/import from one instance of LS to another 3 months 2 weeks ago #107238

  • mas_carpone
  • mas_carpone's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 92
  • Thank you received: 4
  • Karma: 0
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
The administrator has disabled public write access.

Changing SGQA codes following export/import from one instance of LS to another 3 months 2 weeks ago #107249

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2549
  • Thank you received: 285
  • Karma: 102
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.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
The following user(s) said Thank You: mas_carpone

Changing SGQA codes following export/import from one instance of LS to another 3 months 2 weeks ago #107267

  • boyan
  • boyan's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 49
  • Thank you received: 9
  • Karma: 1
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 administrator has disabled public write access.
The following user(s) said Thank You: mas_carpone

Changing SGQA codes following export/import from one instance of LS to another 3 months 2 weeks ago #107279

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6192
  • Thank you received: 786
  • Karma: 238
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
Last Edit: 3 months 2 weeks ago by DenisChenu. Reason: Better link from code:
The administrator has disabled public write access.
The following user(s) said Thank You: mas_carpone

Changing SGQA codes following export/import from one instance of LS to another 3 months 2 weeks ago #107302

  • mas_carpone
  • mas_carpone's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 92
  • Thank you received: 4
  • Karma: 0
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!
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.112 seconds
Donation Image