Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
  • Page:
  • 1

TOPIC: Statistics with imported data

Statistics with imported data 3 months 1 week ago #93567

  • simonbcfa
  • simonbcfa's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
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
forms_2013-03-12.png
but when I go to statistics to create a graph of some sort it will only return the one response
forms2_2013-03-12.png

the original one i assume

Am i missing something??
Last Edit: 3 months 1 week ago by simonbcfa.
The administrator has disabled public write access.

Statistics with imported data 3 months 1 week ago #93569

  • simonbcfa
  • simonbcfa's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
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...

forms_2013-03-12-2.png


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
The administrator has disabled public write access.

Statistics with imported data 3 months 1 week ago #93580

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 4520
  • Thank you received: 472
  • Karma: 168
For the Missing text, it's clean : it's an answer code.

Maybe some filter ?
The administrator has disabled public write access.

Statistics with imported data 3 months 6 days ago #93648

  • simonbcfa
  • simonbcfa's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
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??
The administrator has disabled public write access.

Statistics with imported data 3 months 6 days ago #93652

  • simonbcfa
  • simonbcfa's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
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
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.238 seconds
Donation Image