Media Mapping & Correction
Corrects directus_files metadata fields (photographer, copyright,
keywords, dimensions, Primarix provenance, …) from a freshly uploaded Fotoware
Mongo catalog dump. This only updates files that already exist in Directus
(matched by fotoware_mongo_id, falling back to filename) — it never
creates new files, links products to photos, or touches junction-level
is_map/tour32_export data (that stays owned by
Map Media).
1. Upload a Mongo dump
2. Fields to map
| Field | Directus target | Source | Conflict mode | |
|---|---|---|---|---|
| Title | title |
Mongo | follows selected mode | |
| Description | description |
Mongo | follows selected mode | |
| Tags (keywords) | tags |
Mongo | follows selected mode | |
| Is map ("Karte" keyword) | is_map |
Mongo | follows selected mode | |
| Photographer | photographer |
Mongo | follows selected mode | |
| Copyright | copyright |
Mongo | follows selected mode | |
| Company name (Credit) | company_name |
Mongo | follows selected mode | |
| Expiry date | expiry_date |
Mongo | follows selected mode | |
| IPTC creation date | iptc_creation_date |
Mongo | follows selected mode | |
| IPTC creation time | iptc_creation_time |
Mongo | follows selected mode | |
| File size (MB) | file_size_mb |
Mongo | follows selected mode | |
| File format | file_format |
Mongo | follows selected mode | |
| Dimensions (px) | dimensions_px |
Mongo | follows selected mode | |
| Resolution (DPI) | resolution_dpi |
Mongo | follows selected mode | |
| Media size (cm) | media_sizes_cm |
Mongo | follows selected mode | |
| Color space | color_space |
Mongo | follows selected mode | |
| Original filename | original_filename |
Mongo | follows selected mode | |
| Filename (download) | filename_download |
Mongo | follows selected mode | |
| Generated filename | generated_filename |
Mongo | follows selected mode | |
| Fotoware Mongo ID | fotoware_mongo_id |
Mongo | follows selected mode | |
| Fotoware file name | fotoware_file_name |
Mongo | follows selected mode | |
| Fotoware original path | fotoware_original_path |
Mongo | follows selected mode | |
| Fotoware archive | fotoware_archive |
Mongo | follows selected mode | |
| Fotoware created on | fotoware_created_on |
Mongo | follows selected mode | |
| Fotoware updated on | fotoware_updated_on |
Mongo | follows selected mode | |
| Fotoware raw metadata (audit copy) | fotoware_metadata |
Mongo | follows selected mode | |
| Draft status (always "published") | draft_status |
Derived / constant | follows selected mode | |
| Primarix picture ID | primarix_picid |
Primarix (MySQL) | follows selected mode | |
| Primarix filename | primarix_filename |
Primarix (MySQL) | follows selected mode | |
| Primarix workspace | primarix_workspace |
Primarix (MySQL) | follows selected mode | |
| Primarix copyright | primarix_copyright |
Primarix (MySQL) | follows selected mode | |
| Primarix source | primarix_source |
Primarix (MySQL) | follows selected mode | |
| Primarix video ID (mmid, videos only) | primarix_mmid |
Primarix (MySQL, videos) | follows selected mode — runs as a separate pass, matched by filename against Primarix "multimedia" (videos only) | |
| State (geo) | state |
Geo (filename → lookup) | ignores mode — set only if resolved, never cleared | |
| Country (geo) | country |
Geo (filename → lookup) | ignores mode — set only if resolved, never cleared | |
| Destination (geo) | destination |
Geo (filename → lookup) | ignores mode — set only if resolved, never cleared | |
| Folder (directus_folders, mirrors FotoWare archive path) | folder |
Directus folders | ignores mode — set only if resolved, never cleared | |
| Uploaded by (owner, from folder classification) | uploaded_by |
Derived / constant | ignores mode — set only if resolved, never cleared | |
| Keyword links (M2M, full resync) | keyword_ids |
Keywords (M2M) | ignores mode — always resynced/upserted if source has a value | |
| Alt text (de-DE translation, upsert if source has a value) | alt_text |
Mongo | ignores mode — always resynced/upserted if source has a value | |
| Captions (de-DE/nl-NL/de-CH, from pictures_text) | caption_i18n |
Primarix (MySQL) | ignores mode — always resynced/upserted if source has a value |
Primarix (MySQL) fields join by filename against the bestof/karawane
pictures table — make sure the source dumps are fresh (header
buttons) before including them. Folder creates real
directus_folders rows on Apply (never during Preview).
Keyword links and alt text always
fully resync/upsert regardless of the conflict mode below, matching
media-import-full's own fixed behavior for those two — see
docs/DIRECTUS-FILES-FIELD-MAPPING-REFERENCE.md in the repo.
3. Conflict mode
4. Environment & run
Preview result
| Field | Would change | Would clear |
|---|