exporting question codes and answer' assessment value

Mehr
3 Jahre 9 Monate her #103695 von lordzoster
lordzoster erstellte das Thema exporting question codes and answer' assessment value
Hallo
I'd need to export in a file (possibly an Excel) these survey results:

question code | answer assessment value

By "answer' assessment value" I'm referring to the assessment value attributed to the answer in "Edit label sets"
I'm on LS 2.05+ Build 140109

It's unclear to me if this is a matter of:
1. Expression Manager
2.JavaScript on the page (I would like to avoid writing SGQA JS for each distinct question, since they are likely to be hundreds)
3. some RemoteControl API script
4. a custom SQL query that retrieve data directly from the backend, solution that would make me very happy but I suppose it would be difficult to maintain through future updates and would need a custom application converting into final export document.

I apologize in advance if my question is result of a hasty reading of the documentation.
Could you give me some advice?
Thanks in advance!

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 9 Monate her #103697 von Ben_V
Ben_V antwortete auf das Thema: exporting question codes and answer' assessment value
Hello,

Sometimes you may be lucky and use the assessment value as question code.
After when you export your results to excel you have the choice beetwen answer text or answer code.
The big limit is that answer code have to be unique (for a same question) :(

A valid example for array question type (or radio buttons):

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Anhang:
Folgende Benutzer bedankten sich: lordzoster

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 9 Monate her #103703 von lordzoster
lordzoster antwortete auf das Thema: exporting question codes and answer' assessment value
Thanksalot, this sounds good to me; actually I'm using radio buttons.
And the uniqueness of answer code is more a benefit than a limit: I'm not getting the info from the documentation ( manual.limesurvey.org/Adding_answers_or_subquestions ): has it to be unique throughout all the questions (or their answer set) in the survey?

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 9 Monate her #103707 von Ben_V
Ben_V antwortete auf das Thema: exporting question codes and answer' assessment value
hopefully same answer codes set, can be reused for several questions :)

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 8 Monate her #103731 von lordzoster
lordzoster antwortete auf das Thema: exporting question codes and answer' assessment value
OK and this is right.
But in this situation your solution doesn't fit well: I couldn't have more than an answer with a specific value.
I couldn't have more answer in different sets with the same value (= code).
Anyway in my specific case I'll go for a workaround - I'll extract the survey results in form of question codes | answer codes and then I'll implement a transcode table where I'll write the tuples answer code | value code.

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 8 Monate her #103732 von lordzoster
lordzoster antwortete auf das Thema: exporting question codes and answer' assessment value
Anyway, would I have no luck at all using RemoteControl2 API?
I mean, trying to retrieve survey answers in a somewhat conventional manner without bypassing LimeSurvey logic - and trying to keep installation' upgradeability.

Bitte Anmelden um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten