- Posts: 6
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Missing data in survey results
- enzobronzwaer
- Topic Author
- Offline
- New Member
Less
More
7 years 6 months ago #142924
by enzobronzwaer
Missing data in survey results was created by enzobronzwaer
Hi to all,
I've conducted an survey on two railway stations in the Netherlands.
When I looked up the results of the surveys it seemed that the answers of several questions are not saved.
I've asked respondents to fill in the year (format: yyyy) when they first started using one of the railway stations.
If this value was 2013 or lower, than 4 questions appeared: 3x list (radio boxes), 1x array (7 sub questions).
Of these 4 questions, only the data for the array question was stored. The answers of the 3 list questions are not saved.
I've looked up the data in the MySQL database, this also resulted in nothing (only "NULL" values).
Does anyone know how this is possible? And how to fix this?
Because I need to conduct this survey at one more railway station (at the end of October).
Thank you!
I've conducted an survey on two railway stations in the Netherlands.
When I looked up the results of the surveys it seemed that the answers of several questions are not saved.
I've asked respondents to fill in the year (format: yyyy) when they first started using one of the railway stations.
If this value was 2013 or lower, than 4 questions appeared: 3x list (radio boxes), 1x array (7 sub questions).
Of these 4 questions, only the data for the array question was stored. The answers of the 3 list questions are not saved.
I've looked up the data in the MySQL database, this also resulted in nothing (only "NULL" values).
Does anyone know how this is possible? And how to fix this?
Because I need to conduct this survey at one more railway station (at the end of October).
Thank you!
The topic has been locked.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 966
- Thank you received: 219
7 years 6 months ago #142927
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Missing data in survey results
What version/build of Limesurvey have you been using?
Can you share the survey, so people that help you can look at it.
Based on what you stated, it is not possible to say what happened.
Tammo ter Hark
Can you share the survey, so people that help you can look at it.
Based on what you stated, it is not possible to say what happened.
Tammo ter Hark
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
- enzobronzwaer
- Topic Author
- Offline
- New Member
Less
More
- Posts: 6
- Thank you received: 1
7 years 6 months ago #142931
by enzobronzwaer
Replied by enzobronzwaer on topic Missing data in survey results
Hi Tammo,
I'm running LimeSurvey version 2.51.4+160908.
You can find the survey on the following link.
At page 4 the respondent is prompted to answer the question on which year he/she first started using the railway station (using the information of page 1). If the year is 2013 or below, the respondent sees 4 more questions, of which 3 are lists (radio) and 1 array (7 sub questions).
Unfortunately the answers of the 3 list questions are not stored.
The survey can be found at the following link: www.enzobronzwaer.nl/limesurvey/index.php/385896
Thank you in advance.
Enzo
I'm running LimeSurvey version 2.51.4+160908.
You can find the survey on the following link.
At page 4 the respondent is prompted to answer the question on which year he/she first started using the railway station (using the information of page 1). If the year is 2013 or below, the respondent sees 4 more questions, of which 3 are lists (radio) and 1 array (7 sub questions).
Unfortunately the answers of the 3 list questions are not stored.
The survey can be found at the following link: www.enzobronzwaer.nl/limesurvey/index.php/385896
Thank you in advance.
Enzo
The topic has been locked.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 966
- Thank you received: 219
7 years 6 months ago #142933
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Missing data in survey results
I cannot directly see what is happening. but I would try the following: make the question for the year a numeric question, with only integers and accept only values between 1900 and 2016 (of something like that).
My 2 cents.
Tammo
You can also send me the .lss file, so I can try to reproduce the error.
My 2 cents.
Tammo
You can also send me the .lss file, so I can try to reproduce the error.
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10099
- Thank you received: 3589
7 years 6 months ago #142934
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Missing data in survey results
Hmm...the relevance values are being toggled correctly (screenshot below). Can you retest with a small sample survey containing only that group. If that test fails, attach an export (.lss) of the sample survey here.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Attachments:
The topic has been locked.
- enzobronzwaer
- Topic Author
- Offline
- New Member
Less
More
- Posts: 6
- Thank you received: 1
7 years 6 months ago - 7 years 6 months ago #142936
by enzobronzwaer
Replied by enzobronzwaer on topic Missing data in survey results
Hi all,
See the attachment for the .lss file.
EDIT: I'll add a short version of the survey later.
See the attachment for the .lss file.
EDIT: I'll add a short version of the survey later.
Last edit: 7 years 6 months ago by enzobronzwaer.
The topic has been locked.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 966
- Thank you received: 219
7 years 6 months ago #142939
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Missing data in survey results
Strange, I imported and activated the survey, filled in and nothing was recorded. How about you, Tony?
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10099
- Thank you received: 3589
7 years 6 months ago #142941
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Missing data in survey results
That is the full survey. Please test with a shortened version containing only that group. That will eliminate any possible relevance from previous groups.
(and make it easier for us to test)
(and make it easier for us to test)
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- enzobronzwaer
- Topic Author
- Offline
- New Member
Less
More
- Posts: 6
- Thank you received: 1
7 years 6 months ago - 7 years 6 months ago #142943
by enzobronzwaer
Replied by enzobronzwaer on topic Missing data in survey results
Hi all,
I've created a new survey (a copy of the attached .lss file).
Secondly, I removed the conditions set to the questions ridershipPrevious, purposePrevious etc.
Surprisingly, the filled in data is now stored!
But once I set the conditions back (yearOfFirstUse =< 2013), the data will not be stored...
How is this possible... :huh:
I've created a new survey (a copy of the attached .lss file).
Secondly, I removed the conditions set to the questions ridershipPrevious, purposePrevious etc.
Surprisingly, the filled in data is now stored!
But once I set the conditions back (yearOfFirstUse =< 2013), the data will not be stored...
How is this possible... :huh:
Attachments:
Last edit: 7 years 6 months ago by enzobronzwaer.
The topic has been locked.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 966
- Thank you received: 219
7 years 6 months ago #142944
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Missing data in survey results
Still: just to test, please change the date question to a numeric question.
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
- enzobronzwaer
- Topic Author
- Offline
- New Member
Less
More
- Posts: 6
- Thank you received: 1
7 years 6 months ago #142948
by enzobronzwaer
Replied by enzobronzwaer on topic Missing data in survey results
I've found the problem!
In the validation of the questions I used the date-format yyyy.
Thus, I used this format (yyyy --> "2013") for the validation.
This worked for triggering the questions to appear, but to store the filled in data I needed the date format yyyy-mm-dd hh:mm ("2013-12-31 23:59").
Thank you all for your time and help!
In the validation of the questions I used the date-format yyyy.
Thus, I used this format (yyyy --> "2013") for the validation.
This worked for triggering the questions to appear, but to store the filled in data I needed the date format yyyy-mm-dd hh:mm ("2013-12-31 23:59").
Thank you all for your time and help!
The topic has been locked.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 966
- Thank you received: 219
7 years 6 months ago #142949
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Missing data in survey results
OK, date questions indeed have some more details to them than meets the eye!
Veel succes verder!
Tammo
Veel succes verder!
Tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.