Check out the LimeSurvey source code on GitHub!

Exported Question Codes repeating

More
5 years 9 months ago #60661 by karencheah
Hi,

I'm using Version 1.90+ Build 9642 on PHP/MySQL hosted environment.

I've noted that for the results exported to Excel or csv using question codes, I've got repeating question codes in the middle, i.e., not consistently throughout, just some bits. For example, some of the codes right in the middle go like this...0001 [3], 0002 [3], 0003 [3], 0004 {3], 0005 [3], 0001 [3], 0002 [3], 0003 [3], 0001 [3] and so on. The 0001 part is my question code when I built the survey and I thought that the number in the brackets are running numbers of the sections as in the beginning it looks like that. I have attached my export file here so you see what I mean.

If the numbers in the brackets are not what I think they are, then I'll have to renumber my questions so that the section number is reflected in the code.

Thanks in advance for any ideas.

Cheers,
Karen
Attachments:

Please Log in to join the conversation.

More
5 years 9 months ago #60717 by tpartner
What question types are you using?

Can you provide a screenshot of the "add subquestions" page?

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
5 years 9 months ago #60748 by karencheah
Hi Tony,

The question type is Array. When looking at the subquestion, I noticed the code there. Now I know where that number came from. Thanks for your tip!

I think I should give them each a different code since each one only has one subquestion. I have running numbers for the question codes within each section. Is there any other way of labelling the question code such that the questions are recognisable by sections? Your advice is much appreciated. Thanks!

Please Log in to join the conversation.

More
5 years 9 months ago #60751 by holch
I usually give the question code (not the subquestion, those are just following numbers) something like G01 (for group 1) and Q01 (for question 1 within the group.

But this of course is of personal taste.

My questions would look like this:

G01Q01
G01Q02
G01Q03
...
G01Q08
--
G02Q01
G02Q02
...
G02Q15
etc.

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

Please Log in to join the conversation.

More
5 years 9 months ago #60752 by karencheah
Alright, thanks for your suggestion.

Please Log in to join the conversation.

More
5 years 9 months ago #60769 by tpartner
I would follow Holch's advice. For several reasons, question codes should be unique - never repeated.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form