- Posts: 8
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Error in data set after downloading
1 year 10 months ago #216413
by zliine
Error in data set after downloading was created by zliine
Dear all,
I downloaded my data set as CSV file and had a first look at it in Excel. I noticed the following error:
The question is in the "dual matrix" format with the following answer options and codes...
Antwort-Skala 1, A1 = in der Gegenwart
Antwort-Skala 2, A2 = in der Vergangenheit
this means, that each "Skala" only has one possible answer, however, in my data set, I see that under "Skala 1" the answers A1 AND A2 appear, and the same happens for "Skala 2". See the screenshots attached for clarification. Can someone explain why it shows A1 and A2 although only one option should be available per "Skala" ? This messes up my whole data set.
All the best,
Celine
I downloaded my data set as CSV file and had a first look at it in Excel. I noticed the following error:
The question is in the "dual matrix" format with the following answer options and codes...
Antwort-Skala 1, A1 = in der Gegenwart
Antwort-Skala 2, A2 = in der Vergangenheit
this means, that each "Skala" only has one possible answer, however, in my data set, I see that under "Skala 1" the answers A1 AND A2 appear, and the same happens for "Skala 2". See the screenshots attached for clarification. Can someone explain why it shows A1 and A2 although only one option should be available per "Skala" ? This messes up my whole data set.
All the best,
Celine
Attachments:
The topic has been locked.
1 year 10 months ago - 1 year 10 months ago #216415
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Error in data set after downloading
Hi,
Are these codes in the LimeSurvey answer table, too?
Joffm
And you missed to mention your LS version and where hosted.
Are these codes in the LimeSurvey answer table, too?
Joffm
And you missed to mention your LS version and where hosted.
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 1 year 10 months ago by Joffm.
The topic has been locked.
1 year 10 months ago #216419
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Error in data set after downloading
My first guess would be an import issue with CSV and Excel (where the regional list separator is not matching the CSV format).
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
1 year 10 months ago #216424
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Error in data set after downloading
I go with Jelo!
How does the same section look like in the Limesurvey backend where you can see the responses?
How does the same section look like in the Limesurvey backend where you can see the responses?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
1 year 10 months ago #216467
by zliine
Replied by zliine on topic Error in data set after downloading
Dear all,
I checked and the error appears in the LimeSurvey answer table too. For some answers, it's correct and for others it's not (see screenshots attached).
I use LiemSurvey Version 3.26.2 210503 (?) hosted in Germany.
All the best,
Celine
I checked and the error appears in the LimeSurvey answer table too. For some answers, it's correct and for others it's not (see screenshots attached).
I use LiemSurvey Version 3.26.2 210503 (?) hosted in Germany.
All the best,
Celine
Attachments:
The topic has been locked.
1 year 10 months ago #216473
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Error in data set after downloading
Hmm, your second screenshot looks odd. Why does Limesurvey show the answerlabel and the answer code in the first column, but not in the second column?
Because for the first screenshot the table shows label and code for both, but in the second one, where there are problems, it only shows the code.
Do you have any equations in your survey? My suspicion is that you have an error in the your equation and instead of checking if the answer is A2 you attribute A1 to the answer via equation.
Because for the first screenshot the table shows label and code for both, but in the second one, where there are problems, it only shows the code.
Do you have any equations in your survey? My suspicion is that you have an error in the your equation and instead of checking if the answer is A2 you attribute A1 to the answer via equation.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.