Batch Exports

Introduction

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 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 \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 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

Example

TBC

Clean-up

The merged files the batch exports create are automatically logically deleted after 2 weeks.