Feature Wiki

Information about planned and released features

Tabs

Data Collection : Provision of an Import Template

Page Overview

[Hide]

1 Initial Problem

It is often difficult to import data collection records. The exact column identifiers of the data table must be used. This import document (XLSX) must be created manually.

This is unnecessarily complicated and prone to errors.

2 Conceptual Summary

  • When the import function is activated, an import file is provided in the appropriate structure.
    • A *.xlsx–File (possibly later an *.ods)
  • The upload form is revised.
    • The tab in which the form is located is overwritten with "Import". All other tab titles are hidden.
    • The message box contains the action "Download import template".
    • The info message is transferred to a message box.
    • The form is converted to KS Forms.

3 User Interface Modifications

3.1 List of Affected Views

  • Content-Tab of Data Collection

3.2 User Interface Details

  • Import of one or more Data Collection Records

3.3 New User Interface Concepts

None.

3.4 Accessibility Implications

Nothing specific.

4 Technical Information

{ The maintainer has to provide necessary technical information, e.g. dependencies on other ILIAS components, necessary modifications in general services/architecture, potential security or performance issues. }

5 Privacy

Nothing specific.

6 Security

Nothing specific.

7 Contact

8 Funding

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

9 Discussion

Kunkel, Matthias [mkunkel], 04 JUN 2024: Will I stay on the tab 'Import' after having clicked on 'Create Import Template File' (I prefer the label 'Download Import Template File'? Or am I redirected somewhere?

JourFixe, ILIAS [jourfixe], 10 JUN 2024: We highly appreciate this suggestion and accept it for ILIAS 10 / trunk. Please clarify in the FR that the structure and column titles have to be created first before a template can be provided. Label for download action should be as suggested by Matthias.

JourFixe, ILIAS [jourfixe], 28 OCT 2024: We highly appreciate this suggestion and re-schedule the feature for ILIAS 11.

JourFixe, ILIAS [jourfixe], 27 OCT 2025: We still highly appreciate this feature and accept it for trunk.

10 Implementation

Feature has been implemented by Joußen, Thomas [tjoussen] and Zych, Matheus [mzych]

The feature is implemented as proposed without any further changes.
Additionally a error was added when a user tries to call the Import UI for an empty/not-importable table.
https://github.com/ILIAS-eLearning/ILIAS/pull/12246

Adapted Import GUI with button to download a generated import template
View after redirection when an import view of an empty table is opened.
Exemplary import table in an XLSX-Viewer

Test Cases

Test cases completed at 21.10.2026 by Szmais, Ingmar [iszmais]

New Case:

  • 93994: Tabellen-Import Vorlage herunterladen

Further the following Cases where adapted/refactored to fit the current state:

  • 93995: Tabellen-Import aktivieren
  • 13650: Tabellen-Import
  • 13649: Tabellen-Export

Privacy

Information in privacy.md of component: no change required

Approval

Approved at 26 OCT 2026 by Rachel Cooper for Landeskoordinationsstelle für Übersetzungsangelegenheiten im Hochschulwesen NRW (supported by Samoila, Oliver [oliver.samoila])

Full Screen

Last edited: Yesterday, 11:51, Samoila, Oliver [oliver.samoila]