- Posts: 16
- Thank you received: 3
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
- Topic Author
- Offline
- New Member
Less
More
1 month 1 week ago #258681
by YolandaJolly
Wrong exporting questions of type YES/NO/No Answer to excel. was created 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.
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.
Attachments:
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
1 month 1 week ago #258696
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Wrong exporting questions of type YES/NO/No Answer to excel.
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).
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
1 month 1 week ago #258697
by holch
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.
Replied by holch on topic Wrong exporting questions of type YES/NO/No Answer to excel.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 16
- Thank you received: 3
1 month 1 week ago #258700
by YolandaJolly
Replied by YolandaJolly on topic Wrong exporting questions of type YES/NO/No Answer to excel.
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.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 16
- Thank you received: 3
1 month 1 week ago #258701
by YolandaJolly
Replied by YolandaJolly on topic Wrong exporting questions of type YES/NO/No Answer to excel.
OK.
Thank you very much!
Thank you very much!
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
1 month 1 week ago #258703
by DenisChenu
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.
Replied by DenisChenu on topic Wrong exporting questions of type YES/NO/No Answer to excel.
It must work : github.com/LimeSurvey/LimeSurvey/blob/ma...port/Writer.php#L232I'm talking about the "Yes/No" question in "Mask questions".
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
1 month 1 week ago - 1 month 1 week ago #258704
by DenisChenu
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.
Replied by DenisChenu on topic Wrong exporting questions of type YES/NO/No Answer to excel.
Please update : github.com/LimeSurvey/LimeSurvey/commit/...d65fcba3ed071d4aa33bYour LimeSurvey version: Version 6.4.5+240205
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 16
- Thank you received: 3
1 month 1 week ago #258766
by YolandaJolly
Replied by YolandaJolly on topic Wrong exporting questions of type YES/NO/No Answer to excel.
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.
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
1 month 1 week ago #258771
by DenisChenu
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.
Replied by DenisChenu on topic Wrong exporting questions of type YES/NO/No Answer to excel.
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.