I have a survey with Multiple choice with comments question types.
When I export my data, I see that there is a column for the checkbox for the subquestion, and a column for the comments text.
In the column for the checkbox, I see:
Yes
No
N/A
Neither the question or the question group it belongs to are conditional (so the question is always shown).
Why would I see N/A in the export data? Either a checkbox is selected or it is not selected, which would suggest I should only see Yes or No -- not N/A).
I was running 3.22.10+200323, but I've just updated to 3.22.14+200423. In both cases, I ran a few test submissions, and I get Y or N...
But on my live survey, with about 50 responses, now and then I get N/A instead of Y/N -- and they are for responses that are marked as completed. And there are no conditions in my survey, so all questions are shown to the participant.
I just did some tests and for me the answers are also only "Y" or empty.
There should be no "No", and als no "N/A" only "Y" if checked and empty if not checked.
However, when exporting as "Full answers" and not just "answer codes", the "Yes" and "No" appear. But I did not have any "N/A" despite trying a couple of things (e.g. check and uncheck boxes, stop before the end of the survey, etc).
Are you sure that this data set was generated with exactly the same LSS as we are testing? Or did you make a copy and export a smaller sample, as we usually ask for this?
Because in your Excel sheet, the colomn for TRD4[SQ001] is "BW", in my data export it is in column "P". So you have a lot more columns than me.
Help us to help you!
Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
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.
@holch I did make a copy and removed all the other question groups in the survey, as the survey isn't for public consumption. I could PM the LSS to you directly, if you wish. But the full survey has no conditions in it, so I didn't think it would be problematic to post just the question group with the issue.
1. When I export using Responses=Full answers I get a mix of Y, N, and NA
2. When I export using Responses=Answer codes, I get just Y or blank (I never see N or NA)
When I look directly in the mySQL response table, I see the values Y, blank, and NULL, so I wonder why sometimes blank is recorded instead of NULL?
blocka wrote: For reference, I don't have an array filter or exclude option enabled on the questions that are generating N/A responses.
blocka wrote: When I look directly in the mySQL response table, I see the values Y, blank, and NULL, so I wonder why sometimes blank is recorded instead of NULL?
This is really strange …
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.
@DenisChenu: I didn't, because blocka said that there weren't any in the survey. It was also my suspicion, but I need to trust blocka here. I have no further ideas what could lead to this behavior, because I also couldn't reproduce it.
@Blocka: Try with the copy of the reduced survey that you have given us via LSS and check if you can reproduce this. If not: The problem is in some other part of your survey.
Are those responses with "NULL" in the database completed responses or not? One of my suspicion was that these are responses that have not been completed. Not sure if then a "NULL" in the database makes sense. Maybe Denis has more insights on this.
Help us to help you!
Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
holch wrote: Are those responses with "NULL" in the database completed responses or not? One of my suspicion was that these are responses that have not been completed. Not sure if then a "NULL" in the database makes sense. Maybe Denis has more insights on this.
No,
Seems the same QID … then : you can't have "Y" and null without filtering or subquestions relevance … (and since i already make an error …)
@Blocka : for reminder : what is your LimeSurvey version ?
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.
