Transform metadata from another source into the replayable spreadsheet

Transform a file

Guidelines

Transforms a metadata file into a replayable spreadsheet based on rules defined in a mapping file.

The metadata file should be an Excel spreadsheet or CSV file, with the headers in the first row. The mapping file should be an Excel spreadsheet or CSV file.

The mapping syntax allows four different kinds of transformation.

Simple mapping: The value is transferred as-is to a field in the output data.
Constant data: A value given in the mapping itself is transferred to a field in the output data, with no reference to the input data.
Mapping as variables: Variables are given as the input header in curly brackets. This may be used to insert a mapped value into a constant string ({Dimensions} mm) or to combine two or more input fields into a single output field ({Dimensions} {Units}).
Conditional output: This works in conjunction with one of the three methods above. It states a dependency between two fields, such as that the variable mapping {Dimensions} mm should not be applied if the Dimensions input field does not have a value. This prevents the output mm from displaying when the Dimensions numeric value is absent.

Mapping syntax

The mapping file contains four columns (three if no conditionals are used).

The first column gives the target field -- the field that data will be mapped to in the output (i.e., the column headers in the replayable spreadsheet). Values of this column must be unique.

The second column indicates the source of the data. Its exact syntax depends on the transformation type, as described below. If this column is left blank, the field named in the first column will be created in the output, but will not contain any data.

Simple mapping: the second column contains the header of the column in the input that contains the data.
Constant data: the second column contains the data string to write to output.
Mapping as variables: the second column contains a statement including variables, which are given as input headers in curly brackets.

The third column names the transformation type. If the second column is blank, this column should be blank as well. Otherwise, enter the value as given below.

Simple mapping: map
Constant data: string
Mapping as variables: complex

The fourth column is optional and states a condition that must be met for the rule to generate output. The value of this column is the header of the input column that must have a value for the rule to be applied. If the given input field does not have a value, a blank string is output instead.

Example

Uploaded data file

Uploaded mapping file

The headers druid and sourceId will appear in the generated replayable spreadsheet, even though there is nothing to match them in the source data.
The values in Title and Author will map to ti1:title and na1:namePart respectively.
The value author will map to ro1:roleText only if Author has a value.
The values in Dimensions in mm will map to ph:extent with mm appended only if a value is present.