Batch CSV Exports
Introduction
In this case, the merged file is a CSV file with a row for each record and columns for each chosen metadata field. The CSV export has the following variables
Standard properties of Batches (user, filter, etc)
The separator between rows: fixed at
\nThe separator between columns: fixed at
;The separator inside columns: fixed at
,
Headers
The order of the columns in the CSV export is determined by the order in which the Field Definitions appear in the associated profile. As described in the next section, there are multiple corresponding columns for certain Metadata Field Types.
If a label is defined for a field on the profile, the label will be used as a header. The language is chosen based on the user who started the batch.
If no label is defined for the field on the profile, the header is chosen based on the option ‘HeaderType’. This is set when creating the batch.
DottedKey: the dotted key of the field is used as a header.
LongTranslation: The long translation of the field is used, based on the locale of the user.
Column formatting
The values are determined by the Metadata Field Types of the columns
Field | Columns | Example columns | Example value |
|---|---|---|---|
Single column | Descriptive.Title | Hello world | |
ListField | A single column whose value is the concatenation of the values using another delimiter | Descriptive.Keywords.Keyword | Alice, Bob, Cedric |
MultiItemField | Multiple columns, one for each sub-field, whose value is the concatenation of its subvalues using another delimiter |
|
|
MapField | Multiple columns, one for each sub-field |
|
|
Other Complex Fields | Single column with as value the JSON representation of the field |
|
|