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
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,
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
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