- Updated comment on line 281 to clarify GL is officially GLOBAL
- Removed outdated reference suggesting GL was Greenland
- Mapping GL: GL # GLOBAL remains correct
- Added 14 invalid entries from DAM system (cities, states, regions)
- All invalid entries mapped to XX placeholder
- Total mappings now: 195 (181 valid countries + 14 invalid entries)
Invalid entries added:
- AA: DFI/ASIA (region)
- AP: ANDHRA PRADESH (Indian state)
- BK: BELSK (invalid)
- CB: DFI/CARIBBEAN (region)
- CT: COTTONTAIL (invalid)
- DU: DFIC DUBAI (city)
- HY: HYDERABAD (city)
- II: INTERNATIONAL (not a country)
- IO: DFI/ISOLE (region)
- KA: KERALA (Indian state)
- KK: KARNATAKA (Indian state)
- MH: MAHARASHTRA (Indian state)
- OS: DFI/OVERSEA (region)
- PC: POCOS DE CALDAS (city)
These will map to XX in uploads. Valid country codes will be
updated when confirmed in a few days.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
- Imported all 201 rows from Mapping.csv
- Filtered out 20 invalid entries (cities, states, regions)
- Now contains 181 valid country mappings (ISO -> DAM codes)
- Documented all problematic mappings with data quality issues
Critical mappings:
- Bangladesh (BD) -> BG (conflicts with Bulgaria)
- Bulgaria (BG) -> BU (non-standard)
- India (IN) -> ID (conflicts with Indonesia)
- Indonesia (ID) -> IS (conflicts with Iceland)
- Iceland (IS) -> IC (non-standard)
- Nigeria (NG) -> NA (conflicts with Namibia)
- Namibia (NA) -> NB (non-standard)
- Nepal (NP) -> NE (conflicts with Niger)
- Nicaragua (NI) -> NR (non-standard)
All mappings now apply automatically during A2→A3 uploads
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
- Created config/country_code_mappings.yaml with 165 country mappings
- ISO codes (used in filenames) now map to DAM-specific codes
- Codes under review set to XX as placeholder
- Added load_country_code_mappings() to config_loader.py
- Updated MetadataExtractorMVP to load and apply country mappings
- Added _map_country_code() and _get_field_value() helper methods
- Country mapping applies in both full and folder-only modes
Key mappings:
- BD (Bangladesh) -> BG (DAM code, though appears incorrect)
- DE (Germany) -> DE (same)
- IT (Italy) -> IT (same)
- Most codes under review -> XX (placeholder)
Mapping file can be edited without code changes - updates apply automatically
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
