bonjour,
I'm trying the feedback module and I have troubles to get the student answers alltogether. I didn't find a place to display the all results with names on the screen. I can only get the results student by student.
When I export to xls, I get numbers in columns with no relation to the questions (see attachment). The texts answers are not there at all, and there is no mention of the name ok who submit.
Can somebody explain me if my xls export is normal ? and how to use/fix it ?
How to get a list of the answers with names ?
thanx
Hi Lea,
I'm not sure what the issue could be. I have seen the name of the first worksheet you sent includes some special chars. Perhaps it is the thing what does annoy. Can you try a feedback with name and item-descriptions without such chars and create an excel-export?
Andreas
I'm not sure what the issue could be. I have seen the name of the first worksheet you sent includes some special chars. Perhaps it is the thing what does annoy. Can you try a feedback with name and item-descriptions without such chars and create an excel-export?
Andreas
| hello, I'm coming back about the problem I reported a few months ago (I had to wait for my webmaster to update with the last feedback version, it took a while ! (you had fixed a bug, see message "text is not saved in text box when the sign ' apostrophe is typed!") After new tests (without special chars), I still have the same probleme with the export function in feedback. See below the result of the feedback I've tested, and see in attachment the xls files I get : there is no text anywhere, nor in the 1st or 2nd sheet. Any clue to help ? In case it help, here is the system we use : System : Linux Results of the FeedbackTest I made 1.) êtes-vous pour ou contre ? |
|
|---|---|
| - POUR: |  1 (50.00 %)
|
| - CONTRE: |  0
|
| - ABSTENTION: |  1 (50.00 %)
|
| - REFUS DE VOTE: |  0
|
| 2.) Vos remarques | |
|---|---|
| - | moi je sais pas |
| - | je suis favorable, completement pour |
I have exactly the same problem.In excell i cant see text characters. i attach an excell.
The problem caused after i upgrated feedback form 17(in moodle18) to feedback 19(in moodle182).
I restored the same survey(with the problem xls) in a pc with feedback17 (in moodle18) i exported a new xls, and it is ok.
And another question,how can i add page break in feedback19(i cant find it, in feedback17 it exists).
I would be very gratefull for any help.
Sakis
Re no text exported in excel - Try changing the excel coding (in Admin - Language- Language settings ) from "unicode" to "latin" . That worked for me
"Try changing the excel coding (in Admin - Language- Language settings ) from "unicode" to "latin" . That worked for me"
-- > I tried but I don't have an "excel coding" option in the page Language settings (in Moodle 1.7). The last setting of the page, for me, is SiteWide local...
By the way, xls exports work well in other activities...
I tried the change from unicode to latin but it din't work. In latin encoding i can see the text content but greek characters are not readable and my survey is in greek(english are shown fine). I am attaching xls from any case.
I imported the course in a pc with moodle18-feedback17 and the probelm solved, gtreek characters can be reed in xls both in latin/unicode setting.
During these attempts, i found another trouble in the import proccess.
I exported the questions from feedback19(moodle182) in xml file and when i tried to import it in feedback17(moodle18) i took the message
failed to loading xml.
So i took backup the whole course contained survey with feedback19 amd i restored it to the other system with feedback17 and it worked.
Sakis
I imported the course in a pc with moodle18-feedback17 and the probelm solved, gtreek characters can be reed in xls both in latin/unicode setting.
During these attempts, i found another trouble in the import proccess.
I exported the questions from feedback19(moodle182) in xml file and when i tried to import it in feedback17(moodle18) i took the message
failed to loading xml.
So i took backup the whole course contained survey with feedback19 amd i restored it to the other system with feedback17 and it worked.
Sakis
In reply to Sakis Zafeiropoulos
Re: Feedback : export answers to xls unusable
by Sakis Zafeiropoulos -
I solved it.
The problem to feedback19 is located in page analysis_to_excel.php(\mod\feedback) in line 69
$workbook->setVersion(8);
Number 8 refers to a very old MS Office Version.
You can check your Office version from the folder
C:\Program Files\Microsoft Office\Office12,
Office12 comes from Office2007.
So if we give a number between 9 -12 in the line above, the export to excell procedure, works fine.
Sakis Zafeiropoulos
The problem to feedback19 is located in page analysis_to_excel.php(\mod\feedback) in line 69
$workbook->setVersion(8);
Number 8 refers to a very old MS Office Version.
You can check your Office version from the folder
C:\Program Files\Microsoft Office\Office12,
Office12 comes from Office2007.
So if we give a number between 9 -12 in the line above, the export to excell procedure, works fine.
Sakis Zafeiropoulos
In reply to Sakis Zafeiropoulos
Re: Feedback : export answers to xls unusable
by Janette Dimitrova -
I tried this solution and it does not work for us. Any other suggestions?
I have solved the problem changing the path in /mod/feedback/analysis_to_excel.php. At line 67 when appears /srv/www/moodledata, you change it with your actual moodledata path.
Good luck!