- Posts: 10
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Respones to certain questions show up in application but not in export
- dlemaitr
- Topic Author
- Offline
- New Member
Less
More
4 years 1 week ago #197086
by dlemaitr
Respones to certain questions show up in application but not in export was created by dlemaitr
Kind of at a loss how to fix this: if I look at the responses to a survey in the webapplication, I can see people have given anwers to those questions. But when I export all the data, no matter to what format, for certain questions the column is blanc for all given responsen.
Any idea what is going on?
Any idea what is going on?
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12940
- Thank you received: 3979
4 years 1 week ago #197090
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Respones to certain questions show up in application but not in export
Hi,
there is an error somewhere.
What else to answer?
You gave no information at all.
Which LimeSurvey version?
Which other environment?
Self hosted, LimeSurvey hosted or even university hosted?
At least you'd show us some screenshots of the "filled" answers in the GUI, and the "empty" answers in the export.
And - as usual - the best is to provide a lss export of your survey.
Joffm
there is an error somewhere.
What else to answer?
You gave no information at all.
Which LimeSurvey version?
Which other environment?
Self hosted, LimeSurvey hosted or even university hosted?
Which type of questions?for certain questions the column is blanc for all given responsen.
At least you'd show us some screenshots of the "filled" answers in the GUI, and the "empty" answers in the export.
And - as usual - the best is to provide a lss export of your survey.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- dlemaitr
- Topic Author
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 1
4 years 1 week ago #197092
by dlemaitr
Replied by dlemaitr on topic Respones to certain questions show up in application but not in export
version is Versie 4.1.1+200203 , self hosted
I have added the lss file and screenshot of the responses that show up in the GUI but not in the export, which I also included
these are the questions that are giving issues
G03Q13_SQ01
G03Q13_SQ02
G03Q13_SQ03
G03Q13_SQ04
G03Q17_SQ01
G03Q17_SQ02
G03Q17_SQ03
G03Q17_SQ04
I have added the lss file and screenshot of the responses that show up in the GUI but not in the export, which I also included
these are the questions that are giving issues
G03Q13_SQ01
G03Q13_SQ02
G03Q13_SQ03
G03Q13_SQ04
G03Q17_SQ01
G03Q17_SQ02
G03Q17_SQ03
G03Q17_SQ04
Attachments:
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
4 years 1 week ago - 4 years 1 week ago #197095
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Respones to certain questions show up in application but not in export
[strike]Can you report the issue with the survey archive (lsa file) ?[/strike]
[strike]You can set report as private if you need .[/strike]
See @Joffm answer
[strike]You can set report as private if you need .[/strike]
See @Joffm answer
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 4 years 1 week ago by DenisChenu. Reason: See @Joffm answer
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12940
- Thank you received: 3979
4 years 1 week ago #197097
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Respones to certain questions show up in application but not in export
Hi, Hanneleen,
the only thing I can say, is:
4.1.1. was the fourth release of 4.x.
Now the actual release is 4.1.17., which still is buggy.
Therefore we do not recommend 4.x. for production use.
Nevertheless:
I imported your survey to 4.1.11, activated and entered some data.
And here I could not reproduce the issue.
See:
Export to EXCEL:
Export to csv and opended in EXCEL:
Export to csv (with option "Full answer text")
So you really should consider an update.
Joffm
By the way:
You always used the default codes for your answer options.
Like
AO01=Nooit
AO02=Zelden
AO03=Soms
AO04=Vaak
AO05=Altijd
This obviously is an ordinal scale. And I am sure you want to calculate some statistical tests, like Mean, t-Test, F-Test, Correlation, etc.
Here you need numerical values, but your answer codes are alphanumerical. Meaning an export to SPSS will generate "strings variables".
So you have to restrucute them or (in EXCEL) "search & replace".
Therefore I always recommend to use numerical codes.
the only thing I can say, is:
4.1.1. was the fourth release of 4.x.
Now the actual release is 4.1.17., which still is buggy.
Therefore we do not recommend 4.x. for production use.
Nevertheless:
I imported your survey to 4.1.11, activated and entered some data.
And here I could not reproduce the issue.
See:
Export to EXCEL:
Export to csv and opended in EXCEL:
Export to csv (with option "Full answer text")
So you really should consider an update.
Joffm
By the way:
You always used the default codes for your answer options.
Like
AO01=Nooit
AO02=Zelden
AO03=Soms
AO04=Vaak
AO05=Altijd
This obviously is an ordinal scale. And I am sure you want to calculate some statistical tests, like Mean, t-Test, F-Test, Correlation, etc.
Here you need numerical values, but your answer codes are alphanumerical. Meaning an export to SPSS will generate "strings variables".
So you have to restrucute them or (in EXCEL) "search & replace".
Therefore I always recommend to use numerical codes.
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: DenisChenu
The topic has been locked.