Hi Mazi

I did export and import the whole survey structure but the Group and Question IDs still changed.

The /n or n and <br/> do not work for breaking line in a label set.

Thanks for your help.
Cindy

khicon76 wrote:

I did export and import the whole survey structure but the Group and Question IDs still changed.

That's probably caused by the incrementing IDs.

Last option I can think of to prevent this is to do a full backup of the database and then load this backup into the other system.

Thanks Mazi

We did try again and found out that the Question and Group IDs changed.
I exported the data and imported on a different machine, then I exported it again
Here are the results of my exporting

Inital Survey Export
#
# GROUPS TABLE
#
"gid","sid","group_name","group_order","description","language"
"53","69366","ACTIVITY","0","","en"
"54","69366","TIME ON ACTIVITY","1","","en"
"57","69366","NUMBER OF CONTACTS","2","","en"
"58","69366","RANKING","3","","en"

Export from second machine
#
# GROUPS TABLE
#
"gid","sid","group_name","group_order","description","language"
"293","69366","ACTIVITY","0","","en"
"294","69366","TIME ON ACTIVITY","1","","en"
"295","69366","NUMBER OF CONTACTS","2","","en"
"296","69366","RANKING","3","","en"

The "gid" values have changed. The same thing happens with the Question Table - the "qid" changes but the gid changes as well but references the correct value in the group table

So it seems that ID values are translated during the import process but don't seem to be reconciled correctly some how, which is breaking the survey.

Do you have any suggestions please. Many thanks.
Cindy

I'll point one of our developers to this thread.

I'm not the import/export expert, but when importing a survey from system A to system B, here is what is done (AFAIK):
* check to see if the survey id already is in used in system B: if it is, then find a new one (unused sid), use the old one otherwise
* same algo for gourp id and question id.

So if your system B is a blank LimeSurvey install, you should get the same sid,gid,qid.

Otherwise, they will change.

If you're using INSERTANS tags, there is an option at import time to translate the SGQA codes.

If you're using other workaround, you'll have to fix the survey manually.

HTH,
Thibault

PS: have you considered a checkboxes list and then some array of radio button questions with teh array_filter attribute for your survey ?

HTH,
Thibault

Hi Mazi and Thibault

Thank you very much for your assistance. However I didnt find any solution to keep GIDs and QIDs unchanged, so I had to place the whole database into the server and work on this only.

There are some other issues you may be able to help me. In terms of multiple choice question (check any that apply) with comments, how to change the length of the line for comments (e.g make it shorter)?

Thanks for your kind help.

Have a nice weekend,
Cindy

I think that is not possible but I may be wrong. Please check manual -> question attributes.