References

• This is a sub-issue of [DSpace-CRIS] Data model finalization work (Hierarchical metadata, virtual metadata, etc) #11749

This was initially a sub-issue of #11749. But, as all other tasks in that ticket were solved in 10.0, this ticket is now standalone.

Description

The DSpace-CRIS feature "Bulk Import from Excel File" should be ported to DSpace.

Below is the description from the analysis of DSpace-CRIS and DSpace Differences:

25. Bulk import from Excel File: In the administrative processes section you can upload a particularly structured Excel file to create new items or modify/update existing ones.
    1. Very similar to Bulk Edit via CSV, but using an Excel file.
    2. Excel file has multiple sheets. One is for collection metadata (like in DSpace's bulk edit). One is for hierarchical metadata (e.g. authors and affiliation). One is for the files - includes details about the bitstreams, and adding/removing/modifying bitstreams. Bitstreams are added via a remote URL (HTTP, FTP, SFTP) or a path on the server (starting from a configured folder - for security reasons).
       1. If the bitstream download fails, then it's logged in the output of the process.
    3. Structure of Excel file is checked against the submission forms. If metadata is mandatory, that is enforced on the excel file. If metadata is repeatable, it can also be repeatable in excel.
    4. Can cross reference records in the excel file. Can relate to records using the row id in Excel (like in DSpace CSV), or by using a business identifier (e.g. using ORCID, ROR, etc). This can be configured.
    5. Excel is used here because it allows for multiple sheets. But, you can use LibrOffice or other tools to edit the Excel
    6. Can be used by submitters, but the import occurs in a specific collection
    7. Should be mostly independent of other features