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?

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?

for certain questions the column is blanc for all given responsen.

Which type of questions?

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

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

[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

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.