Statistics with imported data

More
4 years 1 week ago - 4 years 1 week ago #93567 by simonbcfa
Hello

I am having a problem with displaying statistics from our survey.

We have one submission done through the site and the rest (9 or so) imported through a manipulated VV file. This works correctly but when I go to statistics to create a graph of some sort it will only return the one response
the original one i assume

Am i missing something??
Attachments:
Last Edit: 4 years 1 week ago by simonbcfa.

Please Log in to join the conversation.

More
4 years 1 week ago #93569 by simonbcfa
Further info... the answers being exported are from a drop-down menu of 4 options [A1-A4]

In the responses page in Limesurvey it looks like this...



But the exported CSV file looks like this
Response ID	token	         Date submitted	Last page	Start language	Topic of material	
id	 token	                 submitdate	lastpage	startlanguage	882995X89X740	
24	 {question_not_shown}	 1980-01-01     00:00:00	1	en	A4

Missing the Driving text

If i am to duplicate the last line and change the last value to A1 for example... it will import in correctly showing that value, but on editing that question the dropdown does not show that selection
Attachments:

Please Log in to join the conversation.

More
4 years 1 week ago #93580 by DenisChenu
For the Missing text, it's clean : it's an answer code.

Maybe some filter ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
4 years 1 week ago #93648 by simonbcfa
Filter where? I would have figured the answer code would be sufficient to affect the drop-down but it doesnt...

Am i missing some code for my VV import file??

Please Log in to join the conversation.

More
4 years 1 week ago #93652 by simonbcfa
It seems as if the problem was that i had a carriage return at the end of the last value... once I removed it/them it imports in all the results correctly

Please Log in to join the conversation.