Skip to end of banner
Go to start of banner

Batch CSV Exports

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

This is feature is part of release 24.2

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

Field

Columns

Example columns

Example value

Simple Fields

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

  1. Descriptive.Authors.Author

  2. Descriptive.Authors.Photographer

  1. Alice

  2. Bob, Cedric

MapField

Multiple columns, one for each sub-field

  1. Structural.Versioning.Status

  2. Structural.Versioning.Id

  3. Structural.Versioning.Version

  1. Head

  2. xyz

  3. 32

Other Complex Fields

Single column with as value the JSON representation of the field

  • Descriptive.LimitedCategories

 JSON

{
"Category": [
{
"En": "Amphibian",
"Nl": "Amfibie",
"Uri": "..."
},
{
"En": "Reptile",
"Nl": "Reptiel",
"Uri": "..."
}
]
}

Business Logic

  • No labels