...
Batch exports are Batches that join each record the filter returns into a merged file, for example, a CSV file. The merged file is then ingested as a new record of record type Export and is automatically exported for the user that created the batch. The user then sees the merged file in their downloads in the front end. The contents of the merged file are determined by the chosen format and the profile of the category “Export” which provides what metadata fields are part of the merged file.
Rules
In order to To create a batch export the following rules apply
A valid link to one of the Profiles of the category “Export”
The user must have export rights → https://mediahaven.atlassian.net/wiki/spaces/CS/pages/3938877461/Permissions+Rights#Rights
The user must be a member of at least one group of their organisation
Formats
For now, there is only 1 format, namely CSV.
CSV Export
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 columns in the CSV export are 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.
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
...
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
...
Descriptive.Authors.Author
Descriptive.Authors.Photographer
...
Alice
Bob, Cedric
...
MapField
...
Multiple columns, one for each sub-field
...
Structural.Versioning.Status
Structural.Versioning.Version
...
Head
xyz
32
...
Other Complex Fields
...
Single column with as value the JSON representation of the field
...
Internal.Browses
...
Example
TBC
Clean-up
...
Business Logic
When the batch is complete a new record of record type
Exportis createdPermissions for this record are the read, write and export rights for all internal groups of the user that created the batch
The record type
Exporthas as the information package the valueCipand it hence not visible in the front end in the “all objects” view
Formats
For now, there is only 1 format, namely Batch CSV Exports.
Clean-up
The merged files ingested as records are automatically logically deleted after 2 weeks.
...