Statistics with imported data

More
4 years 3 months ago - 4 years 3 months ago #93567 by simonbcfa
simonbcfa created the topic: Statistics with imported data
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 3 months ago by simonbcfa.

Please Log in to join the conversation.

More
4 years 3 months ago #93569 by simonbcfa
simonbcfa replied the topic: Statistics with imported data
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 3 months ago #93580 by DenisChenu
DenisChenu replied the topic: Statistics with imported data
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).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 3 months ago #93648 by simonbcfa
simonbcfa replied the topic: Statistics with imported data
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 3 months ago #93652 by simonbcfa
simonbcfa replied the topic: Statistics with imported data
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.

Start now!

Just create your account and start using Limesurvey today.

Register now