Moodle

Quiz downloaded reports contain html markup

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.8.3
  • Fix Version/s: 2.0
  • Component/s: Quiz
  • Labels:
    None
  • Database:
    Any
  • Affected Branches:
    MOODLE_18_STABLE
  • Fixed Branches:
    MOODLE_20_STABLE

Description

To reproduce (in 1.8.3 and 1.9, probably earlier versions as well):

Create a quiz with essay questions.
Log in as a student, take the quiz, apply some formatting to the essay answer in the html editor, and submit.
As a teacher, go to the Item Analysis tab and download the report (any format).

The student response in the downloaded report will contain html markup. Some of the column headers also contain <br /> tags, and question names and text can contain markup as well. This makes the downloaded reports difficult for faculty to analyze.

When downloading reports, the html should first be converted to text. A patch is attached (1.9).

Note that the same issue exists with the Detailed Responses plugin. I'll file a separate report for that one.

Attachments

  1. Microsoft Excel
    example_output_excel.xls
    10/Mar/08 6:56 AM
    120 kB
    Pierre Pichet
  2. Microsoft Word
    example_output.doc
    10/Mar/08 6:46 AM
    699 kB
    Pierre Pichet
  3. Text File
    quizreport.patch
    14/Dec/07 1:32 AM
    2 kB
    Ann Adamcik

Issue Links

This issue has a clone:
MDL-13427 Export Item Analysis Table to Files (excel or text format) Including <br /> Tags Minor Closed
This issue has a non-specific relationship to:
CONTRIB-318 Quiz downloaded reports contain html markup - with patch Minor Open

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Tim Hunt added a comment -

I'm just wondering if there are any situations where the person downloading the results would want the full HTML?

Show
Tim Hunt added a comment - I'm just wondering if there are any situations where the person downloading the results would want the full HTML?
Hide
Permalink
Pierre Pichet added a comment -

I agree with Tim.
This is why we use HTML editor to answer in some questions types.
There can be also necessary formatting in the question text .
For example using superscript and underscript in chemical formulas.

Perhaps we should create an HTML output.
In the mean time, select the table data on your browser, copy and paste as HTML in Word and everything becomes readable
see the attachement

Show
Pierre Pichet added a comment - I agree with Tim. This is why we use HTML editor to answer in some questions types. There can be also necessary formatting in the question text . For example using superscript and underscript in chemical formulas. Perhaps we should create an HTML output. In the mean time, select the table data on your browser, copy and paste as HTML in Word and everything becomes readable see the attachement
Hide
Permalink
Pierre Pichet added a comment -

copy and paste example.
This does not fullfill all needs but can be usefull.

Show
Pierre Pichet added a comment - copy and paste example. This does not fullfill all needs but can be usefull.
Hide
Permalink
Pierre Pichet added a comment -

The same copy and paste in excel.
Here you can manipulate the columns.

We should provide an HTML (XML?) ouput of the table.
I am already working on Item analysis modifications so I can add this to my to-do list.

Show
Pierre Pichet added a comment - The same copy and paste in excel. Here you can manipulate the columns. We should provide an HTML (XML?) ouput of the table. I am already working on Item analysis modifications so I can add this to my to-do list.
Hide
Permalink
Pierre Pichet added a comment -

An HTML version has been build and CVS to HEAD

see http://moodle.org/mod/forum/discuss.php?d=92376

Show
Pierre Pichet added a comment - An HTML version has been build and CVS to HEAD see http://moodle.org/mod/forum/discuss.php?d=92376
Hide
Permalink
Pierre Pichet added a comment -

Essay does not display the manual grading for each responses although it is OK in the other statistics.
Add to my to-do-list

Show
Pierre Pichet added a comment - Essay does not display the manual grading for each responses although it is OK in the other statistics. Add to my to-do-list
Hide
Permalink
Pierre Pichet added a comment -

I am revising the different format ODS, XLS and CSV so that they can be more useful to do further analysis.
These modifications will be merged down to older versions including 1.9 as they do not use new datatables.
They could also be useful at least in part in the OU project.
The HTML version allows to have a printed complete table that can also be managed in a word processing software.
The Excel, ODS ans CSV versions will have more detailed columns so that their main purpose is to do further calculation or data sorting.
The versions will be progressively put on HEAD to allow better testing before merged to 1.9 and older versions.

Show
Pierre Pichet added a comment - I am revising the different format ODS, XLS and CSV so that they can be more useful to do further analysis. These modifications will be merged down to older versions including 1.9 as they do not use new datatables. They could also be useful at least in part in the OU project. The HTML version allows to have a printed complete table that can also be managed in a word processing software. The Excel, ODS ans CSV versions will have more detailed columns so that their main purpose is to do further calculation or data sorting. The versions will be progressively put on HEAD to allow better testing before merged to 1.9 and older versions.
Hide
Permalink
Pierre Pichet added a comment -

Added storage to database attempts in the $SESSION so there is no new search when sorting the table or downloading.

A preview of the OU project to store results in the database.

Show
Pierre Pichet added a comment - Added storage to database attempts in the $SESSION so there is no new search when sorting the table or downloading. A preview of the OU project to store results in the database.
Hide
Permalink
Pierre Pichet added a comment -

Some settings combination for the refresh don't work correctly .
I will test a

Show
Pierre Pichet added a comment - Some settings combination for the refresh don't work correctly . I will test a
Hide
Permalink
Jamie Pratt added a comment -

This is fixed in 2.0 since a new 'Statistics report' has replaced the item analysis report. Responses from essays are no longer displayed in response analysis table.

Show
Jamie Pratt added a comment - This is fixed in 2.0 since a new 'Statistics report' has replaced the item analysis report. Responses from essays are no longer displayed in response analysis table.
Hide
Permalink
Jamie Pratt added a comment -

This is not fixed in 1.8 or 1.9. Assigning it to Tim, to consider.

Show
Jamie Pratt added a comment - This is not fixed in 1.8 or 1.9. Assigning it to Tim, to consider.
Hide
Permalink
Tim Hunt added a comment -

I think that since this is a minor problem, and because it was fixed by complete rewrite in Moodle 2.0, so there is no easy way to back-port the fix to 1.9, etc, it is not worth spending time fixing this independently in older versions. Therefore, I am resolving this bug as fixed in 2.0 only.

Show
Tim Hunt added a comment - I think that since this is a minor problem, and because it was fixed by complete rewrite in Moodle 2.0, so there is no easy way to back-port the fix to 1.9, etc, it is not worth spending time fixing this independently in older versions. Therefore, I am resolving this bug as fixed in 2.0 only.

People

Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.