ferrero-opentext/Python-Version/config/field_mappings_prod.yaml
nickviljoen b74c9c68aa Fix: EOL/LTD asset type overrides — IP Rights, CreativeX, descriptions
- LTD DAM code confirmed by client: licensingtranslationdocument (was placeholder)
- EOL + LTD: IP Rights forced to "No" (was "Yes")
- EOL + LTD: Remove CreativeX URL and score (not applicable to legal asset types)
- EOL: Description forced to "Legal Studio Name"
- Reorder _apply_asset_type_overrides() to run after _update_creativex_fields()
  so overrides have true final precedence (Box CreativeX was clobbering removals)

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-04-30 13:24:19 +02:00

106 lines
4 KiB
YAML

# MVP Field IDs - Add or remove fields here (no code changes needed!)
# PRODUCTION ENVIRONMENT CONFIGURATION
mvp_fields:
# Asset Info Category
- FERRERO.FIELD.MKTG.ASSET TYPE
- FERRERO.FIELD.FISCAL YEAR
- MAIN_LANGUAGES
- FERRERO.FIELD.ASSETCOMPLIANCE
- ARTESIA.FIELD.ASSET DESCRIPTION
- FERRERO.FIELD.MARKETING.FLAVOUR
- FERRERO.FIELD.MARKETING.SIZE
- FERRERO.FIELD.STATE
- ARTESIA.FIELD.ASSET NAME
- FERRERO.FIELD.SUB BRAND
- FERRERO.FIELD.ASSET VALIDITY START PERIOD
- FERRERO.FIELD.ASSET VALIDITY END PERIOD
# Marketing Category
- MARKETING_TAG
- FERRERO.MARKETING.FIELD.AGENCY NAME
- FERRERO.MARKETING.FIELD.SPOT_VERSION
- FERRERO.MARKETING.FIELD.DIRECTOR_NAME
- FERRERO.MARKETING.FIELD.VIDEO_POST_PROD_COMPANY
- FERRERO.MARKETING.FIELD.VID_POST_PROD_CONTACT
- FERRERO.MARKETING.FIELD.AUDIO_POST_PROD_COMPANY
- FERRERO.MARKETING.FIELD.AUDIO_POST_PROD_CONTACT
# Market Category
- FERRERO.MARKET.FIELD.TYPE_VID
- FERRERO.MARKET.FIELD.IPRIGHT
- FERRERO.MARKET.PROD_COMPANY
- FERRERO.MARKET.FIELD.LICENSIN
- FERRERO.MARKET.FIELD.BUYOUT
- FERRERO.MARKET.FIELD.FERRERO PROPERTY
- FERRERO.MARKET.VID_N_STAT
- FERRERO.MARKET.FIELD.LICENSE
# CreativeX Category (from Box metadata template)
- FERRERO.TAB.FIELD.CREATIVEX # CreativeX Score (Platform > Rating %)
- FERRERO.FIELD.CREATIVEX LINK # CreativeX URL
# Master Asset Lineage (for derivative tracking)
- ARTESIA.FIELD.ASSET_ID # Master Asset DAM ID
# Fields to update from V2 filename
filename_updates:
ARTESIA.FIELD.ASSET NAME:
source: clean_filename
required: true
ARTESIA.FIELD.ASSET DESCRIPTION:
source: subject_title
required: false
FERRERO.FIELD.MKTG.ASSET TYPE:
source: asset_type
required: true
MAIN_LANGUAGES:
source: language_code
transform: uppercase
required: true
# Fields to force to specific values
forced_values:
FERRERO.FIELD.STATE: Local
FERRERO.MARKETING.FIELD.AGENCY NAME: "0000221659" # PROD agency code
# Default values for missing or empty fields
defaults:
FERRERO.FIELD.ASSETCOMPLIANCE: "-"
MARKETING_TAG: "Tag"
FERRERO.FIELD.FISCAL YEAR: "2025/2026"
FERRERO.MARKETING.FIELD.AGENCY NAME: "0000221659" # PROD agency code (exact case required)
FERRERO.MARKETING.FIELD.VIDEO_POST_PROD_COMPANY: "Oliver Marketing Ltd"
FERRERO.MARKETING.FIELD.AUDIO_POST_PROD_COMPANY: "Oliver Marketing Ltd"
FERRERO.MARKET.PROD_COMPANY: "-" # Production House
# Asset type overrides (keyed by 3-letter asset type code)
# Applied AFTER normal field updates and forced values
# Overrides specific fields when a matching asset type is detected in the filename
asset_type_overrides:
EOL: # External Legal Opinion - selected as asset type in naming tool
FERRERO.MARKETING.FIELD.AGENCY NAME: "-"
FERRERO.MARKET.PROD_COMPANY: "-"
MAIN_LANGUAGES: "Global"
FERRERO.MARKET.FIELD.IPRIGHT: "No"
FERRERO.MARKET.FIELD.LICENSIN: "No"
FERRERO.FIELD.ASSET VALIDITY START PERIOD: "" # Remove validity dates for EOL
FERRERO.FIELD.ASSET VALIDITY END PERIOD: "" # Remove validity dates for EOL
FERRERO.FIELD.CREATIVEX LINK: "" # Remove CreativeX URL for EOL
FERRERO.TAB.FIELD.CREATIVEX: "" # Remove CreativeX score for EOL
ARTESIA.FIELD.ASSET DESCRIPTION: "Legal Studio Name"
LTD: # Licensing Translation Document - License claim translations supporting EOL
FERRERO.MARKETING.FIELD.AGENCY NAME: "-"
FERRERO.MARKET.PROD_COMPANY: "-"
MAIN_LANGUAGES: "Global"
FERRERO.MARKET.FIELD.IPRIGHT: "No"
FERRERO.MARKET.FIELD.LICENSIN: "No"
FERRERO.FIELD.ASSET VALIDITY START PERIOD: "" # Remove validity dates for LTD
FERRERO.FIELD.ASSET VALIDITY END PERIOD: "" # Remove validity dates for LTD
FERRERO.FIELD.CREATIVEX LINK: "" # Remove CreativeX URL for LTD
FERRERO.TAB.FIELD.CREATIVEX: "" # Remove CreativeX score for LTD
ARTESIA.FIELD.ASSET DESCRIPTION: "Translation of License claim - For approval purposes only"