I'm planning to set up multiple (>20) small community organizations with their own individual copy of limesurvey (on the same server) to ask an identical questionnaire. Each organization will only be able to look at their own data, but we also want to be able to combine certain data points from each survey. To do this, I'm planning to just write some code to grab the relevant variables from the relevant survey in each individual mysql database. So far, so good.
My question is, is there a way to force the underlying question ID for each question to be the same in every survey? When I copy an lss file from one installation to the next, it assigns new numbers, so 'What's the service date?' might be X10X211 in one database and X34X323 on the next. I can certainly write some sort of master index containing the survey number and the 'local' variable names for every installation, but this would get pretty tedious as the number of installations and number of variables of interest get larger. I was wondering if there's any way to force the question ids (and ideally survey ids) so that 'What's the service date?' is (for example) X10X211 on *every* survey, with only the mysql database name changing from installation to installation?
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. -
Professional support
-
Plugins, theme and development
. I don't answer to private message.
Thanks Denis, I think the code you provided will solve my problem by letting me automate identifying the DBcolumn connected to each question code for each installation.