Metadata enrichment via Excel file
This Step Plugin enables the enrichment of metadata within a METS file based on data from an Excel file.
Overview
Introduction
This plugin allows metadata to be read from an Excel file and added to existing structural elements.
Installation
To install the plugin, the following file must be installed:
To configure how the plugin should behave, various values can be adjusted in the configuration file. The configuration file is usually located here:
Overview and functionality
To put the plugin into operation, it must be activated for a task in the workflow. This is done as shown in the following screenshot by selecting the plugin plugin_intranda_step_excelMetadataenrichment
from the list of installed plugins.
Since this plugin should usually be executed automatically, the work step should be configured as automatic in the workflow.
After the plugin has been fully installed and set up, it is usually executed automatically within the workflow so that there is no manual interaction with the user. Instead, the workflow invokes the plugin in the background and performs the following tasks:
First, a suitable Excel file is searched for. The configured path is searched. If a single Excel file exists there, it is opened regardless of its name. If there are several Excel files, it is expected that the Excel file is named after the process name.
If an Excel file is found, the metadata is read. All existing structure elements are listed and checked whether they contain a metadatum that corresponds to the configured value in the field <docstructIdentifier>
. If this is the case, the Excel file is searched for a row in which the metadatum was used in the column configured in the field <excelIdentifierColumn>
. If it is found, the metadata of the row is added to the structure item.
Configuration
The configuration of the plug-in is structured as follows:
The block <config>
can occur repeatedly for different projects or work steps in order to be able to carry out different actions within different workflows.
The field <excelFolder>
defines where the Excel file is searched for. The Goobi internal variables can be used to define e.g. the process folder or the master folder. Alternatively, an absolute path can be specified where all excel files to be imported are located. If there is more than one excel file in the configured directory, a file 'PROCESSNAME.xlsx' is expected.
The fields <docstructIdentifier>
and <excelIdentifierColumn>
are used to define the name of the metadatum and the Excel column via which the individual lines of the Excel file can be assigned.
The configuration of the metadata and personal data to be imported is already described here:
https://docs.goobi.io/goobi-workflow-plugins-en/import/intranda_import_excel#import-metadata
https://docs.goobi.io/goobi-workflow-plugins-en/import/intranda_import_excel#import-of-persons
Last updated