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 https://mediahaven.atlassian.net/wiki/spaces/CS/pages/3500245010 (user, filter, etc)
The separator between rows: fixed at
\n
The separator between columns: fixed at
;
The separator inside columns: fixed at
,
Headers
The columns in the CSV export are determined by the order in which the https://mediahaven.atlassian.net/wiki/spaces/CS/pages/2703949892 appear in the associated profile. As described in the next section, there are multiple corresponding columns for certain https://mediahaven.atlassian.net/wiki/spaces/CS/pages/2703753301.
Column formatting
The values are determined by the of the columns
Field | Columns | Example columns | Example value |
---|---|---|---|
| Single column | Descriptive.Title | Hello world |
ListField | Single column who value is the concatenation of the values using another delimeter | Descriptive.Keywords.Keyword | Alice, Bob, Cedric |
MultiItemField | Multiple columns, one for each sub-field whose value is the concatenation of its subvalues delimiter |
|
|
MapField | Multiple columns, one for each sub-field |
|
|
Other | Single column with as value the JSON representation of the field |
|
|