Export Assignment Data to Excel

1 Initial Problem

By now (v8), data from the "Assignments" tab of a study programme cannot be exported in order to use them in other software (e.g., for reports or statistical research).

2 Conceptual Summary

We suggest to add an opportunity to export those data to .xlsx or .csv, in a similar way as data can be exported from the "Members" tab of courses or groups.

3 User Interface Modifications

3.1 List of Affected Views

• "Assignments > Export Data" (new view)

3.2 User Interface Details

S. analogously the view offered in courses and groups.

3.3 New User Interface Concepts

• Another view "Export Data" is available in the "Assignments" tab.
• This view offers to buttons "Start CSV Export" and "Start Excel Export".
• Starting the workflow, a list of possible data types is offered (i.e., columns that can be displayed in the "Assignments" tab).
• Clicking "Start ... Export", a file of the chosen type is created and offered for download in the "Export Data" view.
• Existing export files can be downloaded or deleted.

3.4 Accessibility Implications

none

4 Technical Information

There might be suitable general implementation that could be used to implement this. If this is the case, we will document that accordingly after the implementation.

5 Privacy

Although an export of assignment data technically already happened once an html is build and hits a clients computer, a more structured export in the form proposed here is deemed to be a more privacy related feature. Hence, this probably should be discussed with privacy officers of an organisation.

6 Security

none

7 Contact

• Author of the Request: Suittenpointner, Florian [suittenpointner]
• Maintainer: Klees, Richard [rklees]
• Implementation of the feature is done by: Klees, Richard [rklees]

8 Funding

If you are interest in funding this feature, please add your name and institution to this list.

• CaT Concepts and Training GmbH

9 Discussion

JourFixe, ILIAS [jourfixe], 02 OCT 2023: We highly appreciate this suggestion and schedule the feature for ILIAS 9.

10 Implementation

The feature is implemented as described. The according privacy settings are available and will be respected.

Test Cases

Test cases completed at 2023-10-26 by Suittenpointner, Florian [suittenpointner]

• C51298: Zuweisungen exportieren (TopNode, XLSX)
• C51299: Zuweisungen exportieren (SubNode, CSV)
• C51300: Export-Dateien sortieren
• C51301: Export-Dateien paginieren
• C51302: Export-Dateien löschen

Privacy

INo PRIVACY.md is available atm. Sadly, the Study Programme never received funding for this documentation effort, as other components did. If you are interested to contribute here, feel free to contact Klees, Richard [rklees].

Approval

Approved at 2023-10-30 by Zimmermann, Markus [markus.zimmermann]