CSV column reference

The full list of columns accepted by the upload form and the shared-drive importer, with their target types and links to the entities they reference.

Type legend

• elody — a UUID or the human-readable title/name of an existing entity in the VLIZ DAMS. The link column points at the list view.
• vocab — an identifier from the VLIZ vocab server (or its title, if it resolves uniquely). Marine regions, projects, partners and events are typically vocab-backed.
• text — free text, optionally formatted (e.g. URL).
• date — date in dd/mm/yyyy. A few specific fields (map dates, usage_guidelines_until on archival collection) use nested ISO objects internally.

Multi-value behaviour

• In the single upload form: list-valued fields use the same_entity column to group rows.
• In album.csv and default_values_for_media.csv: place each value on a separate line — no same_entity needed.

Column reference

Refresh from validators

Every row below was reconciled against the JSON-schema validators in clients/vliz-dams/client-collection-module/api/apps/vliz/validation/. Where the previous documentation marked a column as vocab but the validator expects an Elody-stored entity, the type has been corrected.

Column	Type	Target / format	Notes
same_entity	text	grouping identifier	Required in upload-form CSV; not used in shared-drive CSVs
type	elody	media, mediafile, … (pre-filled)	Identifies the row's entity type
filename	text	filename incl. extension	Required on mediafile rows
title	text	free	Entity title
description	text	free	—
external_link	text	URL	—
coordinates	text	latitude, longitude (DD)	Geographic coordinates on Album/Media (free-text representation)
locality_text	text	free	Geographic description
context	elody	Contexts	Required on every content entity
album	elody	Albums	Parent album
archival_collection	elody	Archival collections	Parent archival collection
collection_part	elody	Collection parts	Parent collection part
keyword / media_keyword	elody	Keywords	On media
mediafile_keyword	elody	Keywords	On mediafile
language	elody	Languages	—
asset_category	elody	Asset categories	—
confidentiality	elody	Confidentiality	On mediafile
location_type	elody	Location types	Stored as has_location
marine_region	vocab	marine region (MRGID or title)	—
event	vocab	event	—
project	vocab	project	—
partner	vocab	partner	—
creator_person	elody	Person	Was previously typed vocab — corrected
owner_person	elody	Person	Was previously typed vocab — corrected
photographer	elody	Person	—
person	elody	Person	Generic Person link
mediafile_creator_person	elody	Person	On mediafile
mediafile_owner_person	elody	Person	On mediafile
media_license / license	vocab	License	On mediafile
embargo	text/date	embargo expression	Free text or date
usage_guidelines	text	free	Mediafile usage notes
usage_guidelines_until	date	dd/mm/yyyy	Mediafile-level expiry
quality_rating (also qualityRating)	text	numeric or text	—
content_drager	text	physical carrier (e.g. digital, film)	Mediafile
technical_origin	text	digitisation method	Mediafile
projection	elody	Projections	Map only
content_map_type	elody	content map type	Map; required
formal_map_type	elody	formal map type	Map; required
content_document_type	elody	content document type	Publication/Document; required
formal_document_type	elody	formal document type	Publication/Document; required
archive_creator / creator_id	elody	Person	Required on ArchivalCollection
scale	text	e.g. 1:50000	Map
date_description	text	free	Map; required

Removed / deprecated columns

These appeared in the older documentation but no longer match the current validators:

Column	Status	Recommendation
mediafile_creator_partner	not in validator	Use partner on the parent media instead, or add the alias to mediafile_validator.py if needed
mediafile_owner_partner	not in validator	Same as above
creator_partner, owner_partner (generic)	not on Album / Media validators	Use partner (vocab) instead

Added since the previous documentation

These exist in the validators today but were not in the older column overview:

Column	Type	Where
archival_collection_id / archival_collection	elody	Album, Media, Map, CollectionPart
collection_part_id / collection_part	elody	Media
creator_id / creator	elody	Album, Media, Mediafile
locality_text	text	Album, Media
technical_origin	text	Mediafile
belongs_to_parent	elody	Mediafile (versioning)
min_location, max_location, spatial_coverage, scale	mixed	Map
date_of_creation, date_of_publication, date_of_last_revision, content_date	nested date	Map