Problems Downloading Choice Data into Excel

Problems Downloading Choice Data into Excel

by Elizabeth Lewis -
Number of replies: 9
I am having problems downloading data from Choice into Excel.  The resulting data is garbled with non-alphabetical characters.  We are using 1.5.2 and IE.  I also tried with Firefox with no better results.  There are forced groups on in the course.  Any ideas?
Average of ratings: -
In reply to Elizabeth Lewis

Re: Problems Downloading Choice Data into Excel

by Dan Marsden -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
does the download as text format work? - or are they both garbled?

smile

Dan
In reply to Elizabeth Lewis

Svar: Problems Downloading Choice Data into Excel

by Joar Herseth -
Same problem - both with text and excel - 1.5.2 - LAMP - all browsers.
In reply to Elizabeth Lewis

Re: Problems Downloading Choice Data into Excel

by Res Hotz-Pohlmann -
Same problem - both with text and excel - 1.5.2 - WAMP - all browsers.
In reply to Res Hotz-Pohlmann

Re: Problems Downloading Choice Data into Excel

by Robert Brenstein -
I just checked that it works for me fine, both excel and text - OSX server, Safari browser on OSX and Netscape on OS9. I suspect this has little to do with the browser as such but with the server. If all characters are garbled, character encoding conflict is to be suspected. There is an experimental flag, $CFG->unicode, that can be set to true in config.php. May be worth to try it to pinpoint the issue. No idea, though, how safe it is to use it on production site.
In reply to Elizabeth Lewis

Re: Problems Downloading Choice Data into Excel

by Dan Marsden -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
can you also check the downloading Quiz results as an excel sheet to see if those are broken as well? - if so, this isn't a problem with the choice mod - see Roberts comments in this thread.

thanks,

Dan
In reply to Elizabeth Lewis

Re: Problems Downloading Choice Data into Excel

by Dan Marsden -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
What version of PHP is installed on your servers? - is it PHP 5.0.5 ?

also what OS/Moodle version are you running?

smile

Dan
In reply to Dan Marsden

Svar: Re: Problems Downloading Choice Data into Excel

by Joar Herseth -
PHP Version 4.3.10
Mandriva 2005
Moodle 1.5.2 + (2005060222)
Apache-AdvancedExtranetServer/2.0.53
In reply to Dan Marsden

Re: Problems Downloading Choice Data into Excel

by Derry Lyons -

I'm having the same problem here, and the unicode setting didn't fix it. sad

Moodle 1.5.3, PHP 5.0.4 (can't get 5.1.1 to work), Apache 2.0.54.

The Excel spreadsheet that opens has, what looks to be, the drop-down list for the sub-groups, then a lot of gibberish.

Thanks for helping us think this through... smile Derry

In reply to Derry Lyons

Re: Problems Downloading Choice Data into Excel

by Elizabeth Lewis -

I have come to the conclusion that the problem has something to do with either "separate groups" or setting a limit on the number of times a choice can be chosen.  I tried another choice without these restrictions and the download works fine. Quizzes also work fine.

We are using 1.5.3+ and PhP 5.0.2.  I believe when my initial problem was posted, we were using the previous stable version. We use a Windows 2000 server.