Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Wrong exporting questions of type YES/NO/No Answer to excel.

  • YolandaJolly
  • YolandaJolly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 1 week ago #258681 by YolandaJolly
Please help us help you and fill where relevant:
Your LimeSurvey version: Version 6.4.5+240205
Own server or LimeSurvey hosting: Own Server CentOS Linux release 7.9.2009 (Core)
Survey theme/template:
==================
Hello!
Does this happen to anyone else?Exporting to Excel a survey with YES/NO questions (with the "No answer" option), if I select the options "Answer codes" , "Convert Y to 1" and "Convert N to 2", in Excel file the N/A answers is 2 like the NO answers. and there is no difference between negative answer and No answer.If I put "Convert N to 3", in the answer N/A also appear 3.
 I reported this bug, but no one takes it : bugs.limesurvey.org/view.php?id=19477

Thank you very much.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 month 1 week ago #258696 by holch
Hmmm, I think this is referring to the multiple answer quection type, right?

Have a look how this is stored in the database. If someone ticks the check box, it gets a "Y". If it is not ticked, it is empty. So actually, there is no "N" anywhere. No and N/A is basically the same, because the answer option/ subquestion has been either marked ("Y") or not (empty).

Or are we really talking about the "yes/no" question type (that I never use).

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: YolandaJolly

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 month 1 week ago #258697 by holch

I reported this bug, but no one takes it : bugs.limesurvey.org/view.php?id=19477


You have reported the bug last Wednesday, somewhere around mid day. This means there habe been about 2,5 to 3 working days since then. So not overly suprised that this hasn't been worked on yet.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: YolandaJolly

Please Log in to join the conversation.

  • YolandaJolly
  • YolandaJolly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 1 week ago #258700 by YolandaJolly
Hello holch, and thanks for your answer.

I'm talking about the "Yes/No" question in "Mask questions".
I detected the problem only when exporting to Excel.

Kind regards.

Please Log in to join the conversation.

  • YolandaJolly
  • YolandaJolly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 1 week ago #258701 by YolandaJolly
OK.

Thank you very much!

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 month 1 week ago #258703 by DenisChenu

I'm talking about the "Yes/No" question in "Mask questions".

 
It must work : github.com/LimeSurvey/LimeSurvey/blob/ma...port/Writer.php#L232

Seems it's a new issue here.

Remind to get NULL value : the question must be hidden by relecance (and seems currently export LSA is broken for this : bugs.limesurvey.org/view.php?id=19386 )

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: YolandaJolly

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 month 1 week ago - 1 month 1 week ago #258704 by DenisChenu

Your LimeSurvey version: Version 6.4.5+240205


 
Please update : github.com/LimeSurvey/LimeSurvey/commit/...d65fcba3ed071d4aa33b
github.com/LimeSurvey/LimeSurvey/blob/de...lease_notes.txt#L118


And PLEASE : before complain of speed  «but no one takes it » : UPDATE TO THE LAST VERSION !

 

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 1 month 1 week ago by DenisChenu.
The following user(s) said Thank You: YolandaJolly

Please Log in to join the conversation.

  • YolandaJolly
  • YolandaJolly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 1 week ago #258766 by YolandaJolly
Hi DenisChenu.

I'm so sorry, I didn't mean to complain. It's ignorance on my part.

I can only be grateful for the help, and I apologize for any inconvenience.

Thank you so much.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 month 1 week ago #258771 by DenisChenu
Next time : remind to update to the mast version before create a bug report ;)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: YolandaJolly

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose