Data Collection : Provision of an Import Template

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

• Author of the Request: Samoila, Oliver [oliver.samoila]
• Authority to Sign off on Conceptual Changes: Seeland, Per Pascal [PerPascalSeeland], Samoila, Oliver [oliver.samoila]
• Authority to Sign off on Code Changes: Seeland, Per Pascal [PerPascalSeeland], Szmais, Ingmar [iszmais]
• Implementation of the feature is done by: {The maintainer must add the name of the implementing developer.}

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.

10 Implementation

{ The maintainer has to give a description of the final implementation and add screenshots if possible. }

Test Cases

Test cases completed at {date} by {user}

• {Test case number linked to Testrail} : {test case title}

Privacy

Information in privacy.md of component: updated on {date} by {user} | no change required

Approval

Approved at {date} by {user}.