Maintainers
This module is part of the elabore-coop/survey-tools project on GitHub.
You are welcome to contribute.
Survey XLSX - Expand Multiple Choice
This module improves the Survey Results XLSX export provided by survey_xlsx for questions that can hold several answers.
By default such questions are exported as a single column containing every selected value joined together, which is hard to analyse in a spreadsheet. This module splits them into dedicated columns:
- Multiple choice questions (multiple answers allowed): one column per possible answer, with Oui / Non as value.
- Matrix questions: one column per matrix row, with the selected option as value.
Warning
This module relies on report extension hooks that are not part of the standard survey_xlsx yet. They are introduced by this pull request:
https://github.com/elabore-coop/survey/pull/1
You must run a survey_xlsx that includes these hooks (the PR branch, until it is merged upstream). Installed against a plain survey_xlsx, this module installs without error but the export silently falls back to the default one-column-per-question behaviour.
Table of contents
Usage
Export the results of a survey as usual:
- Go to Surveys and open a survey.
- Print the Survey Results XLSX report.
In the generated spreadsheet:
- A multiple choice question Favorite colors with options Red, Green and Blue produces three columns Favorite colors / Red, Favorite colors / Green and Favorite colors / Blue, each containing Oui or Non.
- A matrix question Satisfaction with rows Dashboards and Customer relationship produces two columns Satisfaction / Dashboards and Satisfaction / Customer relationship, each containing the selected option (e.g. Not satisfied at all).
Other question types keep their standard single-column export.
Bug Tracker
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.