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 indd/mm/yyyy. A few specific fields (map dates,usage_guidelines_untilon archival collection) use nested ISO objects internally.
Multi-value behaviour
- In the single upload form: list-valued fields use the
same_entitycolumn to group rows. - In
album.csvanddefault_values_for_media.csv: place each value on a separate line — nosame_entityneeded.
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.
Unknown columns are silently skipped
A column header is matched (lowercased) against the canonical property key or one of its aliases in the validator. Headers that match nothing are dropped without any warning or validation error — including several columns that ship in the download templates (see Removed / not recognised columns).
| 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 (media) / context_id (map, document) | elody | Contexts | Required on every content entity. Media accepts context, context_id or context_name; the map and document validators only recognise context_id (and the canonical has_context), even though the templates ship a context column |
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 / creator_id | elody | Person | Creator on the entity (media, map, album) |
owner / owner_id | elody | Person | Owner on the entity |
photographer | elody | Person | On media |
person / person_id | elody | Person | Person link on mediafile |
mediafile_creator / creator_mediafile | elody | Person | Creator 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 | text | numeric or text | The templates ship qualityRating, which is not recognised (header matching lowercases to qualityrating) — use quality_rating |
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 / not recognised columns
These appear in the older documentation and/or in the shipped download templates, but do not match any alias in the current validators — values in them are silently dropped:
| Column | Status | Recommendation |
|---|---|---|
creator_person, owner_person | not in validator (ships in media/map templates) | Use creator / owner instead |
mediafile_creator_person, mediafile_owner_person | not in validator (ships in templates) | Use mediafile_creator for the creator; for the owner only the generic owner alias exists |
creator_partner, owner_partner | not in validator (ships in templates) | Use partner (vocab) on the parent media instead |
mediafile_creator_partner, mediafile_owner_partner | not in validator (ships in templates) | Use partner on the parent media instead, or add the alias to mediafile_validator.py if needed |
mediafile_copyright_color | not in validator (ships in templates) | No working alternative today |
qualityRating | not recognised (ships in templates) | Use quality_rating |
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 |