Export HTML source code to Excel

1 Requirements

In some of our online tests, students are requested to enter code formatted with HTML tags (such as <p> and <br />) in an essay question. When the test results are exported to Excel, we want that all HTML tags will be preserved, and this worked well until ILIAS 4.3.
 
Unfortunately, the behaviour was changed recently in ILIAS 4.4, possibly in relation with Mantis 0014542. Now the <br /> tags get lost during the excel export, so that line breaks get lost.
 
We need a possibility to export HTML code to Excel. If other universities prefer to export HTML code in a different way, we suggest to make the decision configurable.
 
 Description:
In a test which includes data sets, go to slider "Export", select "Create Test Results Export File" and click "Create Export File". As of now, this step creates export files in xls and csv format.
Suggestion: before creating the export file, the user should select if
a) HTML code will be parsed
or
b) HTML will be exported as plain text, so that the code will be preserved.
…

2 Additional Information

• Idea / concept: Klaus Zimmermann, FH Münster
• Funding: FH Münster
• Maintainer: Heyser, Björn [bheyser]
• Implementation of the feature is done by
• Tested by / status:

3 Discussion

kzimmermann 26.03.2015: The feature is very important for FH Münster, funding is possible.

Heyser, Björn [bheyser] 22. July 2016:

The maintainer supports the idea of having this behaviour configurable. I can imagine, that a single installion is used by multiple user groups that need a different behaviour in this context, so the config setting should be added as test object local setting.

With activated Setting, the stripping of HTML is simply left out prior to the export.

JourFixe, ILIAS [jourfixe], July 25, 2016: We highly appreciate this feature and schedule it for 5.2. But we want to have a global administration setting to avoid that every user for every export has to decide which kind of export should be used.

JourFixe, ILIAS [jourfixe], August 01, 2016: To clarify: depending from the global setting in Administration HTML should either be included or excluded in export files. There is no page where a user can chose if HTML should be included or not.

4 Implementation

There is now a new setting under Administration > Test and Assessment > Settings > Export Essay Questtion with HTML code if this is checked Essay Questions get exported including their HTML Code to Excel.

Test Cases

Test cases completed at August 23th, 2016 by Hölscher, Miriam [miriamhoelscher]

• C12987 : Exportdatei mit HTML-Code erstellen

Approval

Approved at 17 August 2016 by kzimmermann.