Angel Fernando Quiroz Campos f545b472d0 SurveyTXTExport / SurveyCSVExport: Limit to 1 result from question options - refs BT#16208 | 5 年 前 | |
---|---|---|
.. | ||
lang | 5 年 前 | |
README.md | 5 年 前 | |
SurveyExportCsvPlugin.php | 5 年 前 | |
export.php | 5 年 前 | |
install.php | 5 年 前 | |
plugin.php | 5 年 前 | |
start.php | 5 年 前 | |
uninstall.php | 5 年 前 |
Exports survey results to a CSV file with a very specific format.
This plugin will add a new action button in the surveys list, allowing the teacher to export the survey in a CSV format meant at exchanging with external analysis tools.
The CSV format looks this way:
DATID;P01;P02;P03;P04;P05;P06;P07;P08;DATOBS
1;"1";"2";"26";"10";"2";"2";"2";"4";"2"
2;"1";"2";"32";"10";"6";"4";"4";"5";"2"
3;"2";"3";"27";"8";"5";"5";"2";"5";"1"
4;"1";"3";"33";"11";"1";"4";"1";"6";"1"
Where:
Setup instructions
Edit configuration.php
file
$_configuration['survey_additional_teacher_modify_actions'] = [
// ...
'SurveyExportCSVPlugin' => ['SurveyExportCsvPlugin', 'filterModify'],
];
If you have large surveys with large numbers of users answering them, you might want to ensure your c_survey_answer table is properly indexed. If not, use the following SQL statement to modify that:
alter table c_survey_answer add index idx_c_survey_answerucsq (user, c_id, survey_id, question_id);