Welcome to the LimeSurvey Community Forum

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

Missing data in survey results

More
8 years 11 months ago #142924 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.
More
8 years 11 months ago #142927 by tammo
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.
More
8 years 11 months ago #142931 by enzobronzwaer
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.
More
8 years 11 months ago #142933 by tammo
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.
More
8 years 11 months ago #142934 by tpartner
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.
The topic has been locked.
More
8 years 11 months ago - 8 years 11 months ago #142936 by enzobronzwaer
Hi all,

See the attachment for the .lss file.

EDIT: I'll add a short version of the survey later.
Last edit: 8 years 11 months ago by enzobronzwaer.
The topic has been locked.
More
8 years 11 months ago #142939 by tammo
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.
More
8 years 11 months ago #142941 by tpartner
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.
More
8 years 11 months ago - 8 years 11 months ago #142943 by enzobronzwaer
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: 8 years 11 months ago by enzobronzwaer.
The topic has been locked.
More
8 years 11 months ago #142944 by tammo
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.
More
8 years 11 months ago #142948 by enzobronzwaer
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.
More
8 years 11 months ago #142949 by tammo
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.
More
8 years 11 months ago #142950 by enzobronzwaer
Bedankt voor het meedenken!

Maar toch raar dat wel de vraag verschijnt bij het formaat YYYY, maar het dan niet opslaat...
Ach... Had ik maar beter moeten opletten bij mijn pilot survey. :silly:

Groet
Enzo
The topic has been locked.
More
8 years 11 months ago #142951 by tammo
Indeed: always test first, also data storage.

Tammo


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

Lime-years ahead

Online-surveys for every purse and purpose