Welcome to the LimeSurvey Community Forum

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

Missing data in survey results

  • enzobronzwaer
  • enzobronzwaer's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 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!
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 5 months ago #142927 by tammo
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


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • enzobronzwaer
  • enzobronzwaer's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 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
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 5 months ago #142933 by tammo
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.


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 5 months ago #142934 by tpartner
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
  • enzobronzwaer's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago - 7 years 5 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.
Last edit: 7 years 5 months ago by enzobronzwaer.
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 5 months ago #142939 by tammo
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
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 5 months ago #142941 by tpartner
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)

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
  • enzobronzwaer's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago - 7 years 5 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:
Last edit: 7 years 5 months ago by enzobronzwaer.
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 5 months ago #142944 by tammo
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
  • enzobronzwaer's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 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!
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 5 months ago #142949 by tammo
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


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose