I've been using the feedback module for a small questionnaire, combined with a quiz (as testing-tool). The target is to export both results to Excel document and then compare both results with statistical software (SPSS). To accomplish this, both results need to be identified by a username.
The problem is that the quiz does give some identification when exporting to Excel, but the Feedback module does not export an ID to Excel:
The “analysis page” shows a generalized result without ID (as is the exported Excel document).
The “input page” does show details (with ID), but does not have an Excel export option.
Is it possible to add an identification to the exported Excel document?
Thomas Coppens
Hi Thomas,
have a look at the excel workbook. There are two worksheets. The second one is with detailed informations.
Andreas
have a look at the excel workbook. There are two worksheets. The second one is with detailed informations.
Andreas
Hello Andreas
Thank you for taking time to answer my question.
I've taken a look at the second worksheet as you suggested, but I can't find an identification in the detailed worksheet. I think something might be going wrong with the feedback.xls creation? Could you take a quick look at the Excel document? I've put it here.
Thomas Coppens
Thank you for taking time to answer my question.
I've taken a look at the second worksheet as you suggested, but I can't find an identification in the detailed worksheet. I think something might be going wrong with the feedback.xls creation? Could you take a quick look at the Excel document? I've put it here.
Thomas Coppens
Hi Thomas,
do you use the last version of feedback? What version is shown in your admin-panel?
Andreas
do you use the last version of feedback? What version is shown in your admin-panel?
Andreas
Andreas
I'm currently using Feedback version 2008050104 and Moodle version 1.9.
Do you need some extra information?
Sincerely
Thomas Coppens
I'm currently using Feedback version 2008050104 and Moodle version 1.9.
Do you need some extra information?
Sincerely
Thomas Coppens
Andreas
Some more information about the configuration:
- OS: FreeBSD version 6.2
- Webserver software: Apache version 1.3.37 with PHP version 5.2.4
Thomas Coppens
Some more information about the configuration:
- OS: FreeBSD version 6.2
- Webserver software: Apache version 1.3.37 with PHP version 5.2.4
Thomas Coppens
Hi Thomas,
ok, can you try to export with debugging is set on? Note, please set the debugging to "All:..." not to "Developer:..."!
If the export file is wrong so you can open it in an editor. Perhaps there you can find some error outputs.
Also check if there is support for iconv or mbstring in your php.
Andreas
ok, can you try to export with debugging is set on? Note, please set the debugging to "All:..." not to "Developer:..."!
If the export file is wrong so you can open it in an editor. Perhaps there you can find some error outputs.
Also check if there is support for iconv or mbstring in your php.
Andreas
I have not had any issues with this.
Hello Andreas
I'm waiting for an information from the hosting company about iconv and mbstring support.
Debugging has been enabled, and I've also added myself as administrator to the site. Added an attachment to this post including the page with errors whenever the export function to Excel is used. This page does look abnormal, but I can't make any conclussion on what's causing this behavior. Does it say more to you?
Also, a message saying "Notice: Undefined variable: return in /usr/home/deb4871/domains/ceupers.be/public_html/nursing/mod/feedback/lib.php on line 147" appears whenever viewing the activity report in a user profile.
I'm waiting for an information from the hosting company about iconv and mbstring support.
Debugging has been enabled, and I've also added myself as administrator to the site. Added an attachment to this post including the page with errors whenever the export function to Excel is used. This page does look abnormal, but I can't make any conclussion on what's causing this behavior. Does it say more to you?
Also, a message saying "Notice: Undefined variable: return in /usr/home/deb4871/domains/ceupers.be/public_html/nursing/mod/feedback/lib.php on line 147" appears whenever viewing the activity report in a user profile.
Hello again Andreas
The Moodle administration page (environment) says iconv and mbstring are supported. I've reinstalled Moodle using version 1.9.1 with Feedback version 2008050105 but the issue isn't resolved.
The questionnaire for the thesis is running, so I hope to recover the results next month. Do you think this issue can be solved?
Regards
Thomas Coppens
The Moodle administration page (environment) says iconv and mbstring are supported. I've reinstalled Moodle using version 1.9.1 with Feedback version 2008050105 but the issue isn't resolved.
The questionnaire for the thesis is running, so I hope to recover the results next month. Do you think this issue can be solved?
Regards
Thomas Coppens
Hi Thomas,
you can try two things.
first:
switch the configuration for the excel encoding to latin. You can do that on "Site Administration" -> "Language" -> "Language settings". There you will find this option at the bottom of this page.
If this still isn't working so you can try the second one:
Open the file "easy_excel.php" from feedback-folder with an simple text-editor (not Word or OpenOffice!)
Go at the bottom of this file. You will find the function "feedback_convert_to_win()". It should look like this:
function feedback_convert_to_win($text) {
global $CFG;
static $textlib;
static $newwincharset;
static $oldcharset;
if(!isset($textlib)) {
$textlib = textlib_get_instance();
}
...
Put directly below the line "function feedback_convert_to_win($text) {"
the statement: "return $text;"
It now should look like this:
function feedback_convert_to_win($text) {
return $text;
global $CFG;
static $textlib;
static $newwincharset;
static $oldcharset;
if(!isset($textlib)) {
$textlib = textlib_get_instance();
}
...
I'm hoping it helps.
Andreas
you can try two things.
first:
switch the configuration for the excel encoding to latin. You can do that on "Site Administration" -> "Language" -> "Language settings". There you will find this option at the bottom of this page.
If this still isn't working so you can try the second one:
Open the file "easy_excel.php" from feedback-folder with an simple text-editor (not Word or OpenOffice!)
Go at the bottom of this file. You will find the function "feedback_convert_to_win()". It should look like this:
function feedback_convert_to_win($text) {
global $CFG;
static $textlib;
static $newwincharset;
static $oldcharset;
if(!isset($textlib)) {
$textlib = textlib_get_instance();
}
...
Put directly below the line "function feedback_convert_to_win($text) {"
the statement: "return $text;"
It now should look like this:
function feedback_convert_to_win($text) {
return $text;
global $CFG;
static $textlib;
static $newwincharset;
static $oldcharset;
if(!isset($textlib)) {
$textlib = textlib_get_instance();
}
...
I'm hoping it helps.
Andreas
Andreas
Your suggestion did help. Switching the Excel encoding language to Latin (using Moodle "Site Administration", "Language", "Settings", "Excel encoding") did the trick.
I very much appreciate all the time you've devoted to this... thanks!
Thomas Coppens
Your suggestion did help. Switching the Excel encoding language to Latin (using Moodle "Site Administration", "Language", "Settings", "Excel encoding") did the trick.
I very much appreciate all the time you've devoted to this... thanks!
Thomas Coppens