Feature Wiki
Tabs
Import Booking Objects into Booking Tool
Page Overview
[Hide]1 Initial Problem
It is not possible to import data to the Booking Pool, however entering a lot of topics for a lecture with a large audience, a lot of rooms or many trainers is tideous work.
Typically this data is available and is typed in manually.
2 Conceptual Summary
It should be possible to import Booking Objects from Spreadsheets via the clipboard or to quickly create a number of objects manually via a textarea. Only Title, Description and Nr. of Items are entered. Eventual Metadata is not imported. No formattings are supported, only plain text.
If the booking pool does feature schedules one schedule can be picked for all booking objects created in one batch.
2.1 User Interface Modifications
2.2 List of Affected Views
Booking tool > Booking Objects
2.3 User Interface Details
New "Bulk Creation" button.
Copying data from spreadsheet via clipboard or entering data manually.
Data confirmation screen
Selecting the schedule
3 New User Interface Concepts
none
4 Technical Information
No technical issues.
5 Privacy
For current state on privacy see existing PRIVACY.md.
This feature does not implement any privacy related changes.
6 Security
No security implications.
7 Contact
- Author of the Request: stefan.van-den-kroonenberg@uni-tuebingen.de
- Maintainer: {Please add your name before applying for an initial workshop or a Jour Fixe meeting.}
- 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
Stefan Vejda: I like this feature, because it would be very valuable for my customers that do a lot of trainings. It will save them time and effort.
Killing, Alexander [alex], 10 July 2019: I support the idea. Maybe a spreadsheet xlsx import would be the most popular solution? We could try to make this a reusable workflow which could be configured by transformation objects. This would allow to import, e.g. glossaries or other data from spreadsheets in the future, too.
JourFixe, ILIAS [jourfixe], 29 JUL 2019: We highly appreciate this suggestion and schedule the feature for 6.0. For a first implementation we prefer to use .xlsx-files for import. Other formats could be supported in a second step.
Killing, Alexander [alex], 4 Aug 2022: The proposal has been slightly changed. Instead of selecting the file, the user can now either copy/paste from a spreadsheet or enter the values directly manually. This has some advantages:
- other spreadsheets that serve similarly to the system clipboard should work, too
- no third party library needed
- direct input possible
JourFixe, ILIAS [jourfixe], 22 AUG 2022: We highly appreciate this suggestion and schedule the feature for ILIAS 9. Please modify the suggested workflow as follows:
- Inserting spreadsheet data _and_ choosing schedule should take place on screen 1 (step 1 of process).
- Rendered spreadsheet data should be presented on confirmation modal with option to Create booking objects (or Cancel action).
10 Implementation
Test Cases
Test cases completed on 2022-10-13 by Tödt, Alexandra [atoedt]
Approval
Approved at 2022-11-10 by Riebe, Katharina [kriebe].
Last edited: 26. Oct 2023, 13:19, Tödt, Alexandra [atoedt]