Welcome, Guest
Username: Password: Remember me

TOPIC: Statistics with imported data

Statistics with imported data 2 years 5 months 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 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??

This message has attachments images.
Please log in or register to see it.

Last Edit: 2 years 5 months ago by simonbcfa.
The administrator has disabled public write access.

Statistics with imported data 2 years 5 months 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...



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

This message has an attachment image.
Please log in or register to see it.

The administrator has disabled public write access.

Statistics with imported data 2 years 5 months ago #93580

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 7495
  • Thank you received: 1021
  • Karma: 296
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 2 years 5 months 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 2 years 5 months 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.
Moderators: ITEd
Time to create page: 0.219 seconds