Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

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

...

  • Descriptive.Authors.Author

  • Descriptive.Authors.Photographer

...

  • Alice

  • Bob, Cedric

...

MapField

...

Multiple columns, one for each sub-field

...

...

  • Head

  • xyz

  • 32

...

Other Complex Fields

...

Single column with as value the JSON representation of the field

...

  • Internal.Browses

...

 

Example

TBCBatch CSV Exports.

Clean-up

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

...