Commit graph

  • 9e92db185a Feature: Apply naming-tool pre-upload metadata overrides on A2→A3 upload main nickviljoen 2026-05-19 12:06:06 +02:00
  • 4e9fb6d18f Feature: Add check_campaign_status.py read-only status lookup nickviljoen 2026-05-13 20:27:37 +02:00
  • db35697091 Feature: Add Spotify (SPT) to social media codes nickviljoen 2026-05-11 21:14:29 +02:00
  • c12aef0eb1 Fix: Populate MAIN_LANGUAGES in folder-only mode (-N) uploads nickviljoen 2026-05-08 21:19:09 +02:00
  • 6d6213024a Fix: Merge A+B live campaigns into single CSV for OMG nickviljoen 2026-05-04 17:36:43 +02:00
  • 28586308d7 Docs: Refresh A1 empty-folder doc and LTD asset type notes nickviljoen 2026-04-30 18:19:06 +02:00
  • ba4f1a9bf7 Feature: Global live campaigns CSV + B4 closure flow nickviljoen 2026-04-30 18:12:49 +02:00
  • b74c9c68aa Fix: EOL/LTD asset type overrides — IP Rights, CreativeX, descriptions nickviljoen 2026-04-30 13:24:19 +02:00
  • 5909e017a4 Reporting: Format CreativeX score as '100 (DV360)' in B1→B2 emails nickviljoen 2026-04-29 12:04:27 +02:00
  • 8bf8dc1325 Fix: Recursively walk metadata_element_list when extracting CreativeX nickviljoen 2026-04-29 11:53:15 +02:00
  • a463eb42f8 Diagnostic: Recursively walk nested metadata_element_list for CX search nickviljoen 2026-04-29 11:49:54 +02:00
  • 3c69e7545a Fix: Escape literal % in LIKE pattern in B1 metadata diagnostic nickviljoen 2026-04-29 11:47:21 +02:00
  • 23bcc057c5 Diagnostic: Inspect B1 master metadata structure for CX fields nickviljoen 2026-04-29 11:45:35 +02:00
  • b9d5ac9feb Backfill: One-shot script to populate CX scores for existing B1 masters nickviljoen 2026-04-29 11:40:48 +02:00
  • f28b5221f7 Enhancement: Capture CreativeX score on B1→B2 global masters nickviljoen 2026-04-29 11:31:07 +02:00
  • 74977f2366 Rename: SDA asset type → LTD (Licensing Translation Document) nickviljoen 2026-04-28 21:05:44 +02:00
  • 0f49cc6cbc Enhancement: SDA (Supporting Documents for Approval) asset type nickviljoen 2026-04-28 16:08:03 +02:00
  • 90f326aecb Enhancement: Treat empty A1 folders as expected workflow nickviljoen 2026-04-28 15:20:41 +02:00
  • ab557b78de Fix: Skip permanently-failed campaigns before A1 per-run cap nickviljoen 2026-04-28 14:54:36 +02:00
  • 2c06f3936f Reporting: Split new vs previously-downloaded assets in A1→A2 / B1→B2 emails nickviljoen 2026-04-23 14:11:00 +02:00
  • d83e41707c Docs: Update README with asset type mapping changes and current date nickviljoen 2026-04-16 17:44:55 +02:00
  • 455cc1bf2a Update asset type mappings per Scaling Agencies Metadata List nickviljoen 2026-04-16 17:40:21 +02:00
  • 695eefadf3 Fix: Recurse into subfolders with numeric extensions (e.g. "2.0") nickviljoen 2026-04-10 09:46:32 +02:00
  • 0408d282a5 Revert "Fix: Skip subfolders with numeric extensions in B1→B2 downloads" nickviljoen 2026-04-10 09:44:41 +02:00
  • 4dff200e10 Fix: Skip subfolders with numeric extensions in B1→B2 downloads nickviljoen 2026-04-10 09:42:29 +02:00
  • 39a495e4cc Fix: Skip already-processed assets on B1→B2 retry runs nickviljoen 2026-04-10 09:07:07 +02:00
  • de04cfc8fb Docs: Update README and CLAUDE.md with folder-only template and EOL workflow ppr nickviljoen 2026-03-31 21:34:06 +02:00
  • 03c5ab65a8 Docs: Update README and CLAUDE.md with folder-only template and EOL workflow nickviljoen 2026-03-31 21:33:35 +02:00
  • 95edece5f3 Enhancement: EOL (External Legal Opinion) workflow nickviljoen 2026-03-31 15:53:37 +02:00
  • 33e71be453 Fix: Template-based folder-only mode for -N flag uploads nickviljoen 2026-03-31 15:53:10 +02:00
  • 37097d2148 Enhancement: Template-based folder-only mode and EOL workflow nickviljoen 2026-03-31 15:52:22 +02:00
  • 5905f3262a Fix: Folder-only mode metadata format for PROD DAM compatibility nickviljoen 2026-03-25 12:31:02 +02:00
  • 2ec22c62a5 Fix: Folder-only mode metadata format for PROD DAM compatibility nickviljoen 2026-03-25 12:24:44 +02:00
  • 51e915e67c Add global_master_tracking_id to link A1→A2 local assets to B1→B2 global masters nickviljoen 2026-03-21 13:12:55 +02:00
  • 7412019053 Update: Move ELO to asset type, add VOD social media code, remove OLV asset type nickviljoen 2026-03-16 21:21:44 +02:00
  • 78a4ca0976 Fix: CreativeX score supersede now matches base filename ignoring timestamp suffix nickviljoen 2026-03-13 21:12:50 +02:00
  • 4dded5de14 Fix: Send Mailgun API emails one recipient at a time nickviljoen 2026-03-13 13:39:55 +02:00
  • e6a6357403 Update Mailgun test: try US/EU endpoints, handle non-JSON errors nickviljoen 2026-03-13 13:29:27 +02:00
  • 467a735e94 Add Mailgun recipient format test script nickviljoen 2026-03-13 12:54:44 +02:00
  • dc779724fc Add Mailgun API support for PROD email notifications nickviljoen 2026-03-12 14:39:16 +02:00
  • 96b33fa084 Fix: Correct MARKETING_TAG parent_table_id in folder-only mode nickviljoen 2026-03-11 16:13:11 +02:00
  • 6bc1b397d0 Fix: Use simple value structure for non-domain default fields in folder-only mode nickviljoen 2026-03-11 16:07:21 +02:00
  • 6e0bb08a5f Fix: Add type field to folder-only mode (-N) metadata values for DAM API nickviljoen 2026-03-11 16:03:02 +02:00
  • faa33cf44f Fix: Use DomainValue wrapper for non-tabular default fields in folder-only mode (-N) nickviljoen 2026-03-11 15:30:46 +02:00
  • 7deb9db0a5 Fix: Update MAIN_LANGUAGES values array for tabular fields in DAM upload nickviljoen 2026-03-05 17:26:31 +02:00
  • 8299a87180 Fix: Update MAIN_LANGUAGES values array for tabular fields in DAM upload nickviljoen 2026-03-05 17:26:31 +02:00
  • 63e42d1196 Fix: Don't send generic CreativeX URL when no score exists nickviljoen 2026-02-24 17:42:57 +02:00
  • 74141689e6 Enable FERRERO.MASTERASSETIDS and multi-master support for PROD nickviljoen 2026-02-13 18:12:30 +02:00
  • f6c84762ae Fix: Map CreativeX API channel/publisher to DAM platform names for PROD nickviljoen 2026-02-13 17:43:58 +02:00
  • 052558961a Revert "Fix: Add YouTube platform mapping and social media code fallback for CreativeX" nickviljoen 2026-02-13 17:17:06 +02:00
  • ad714d4b14 Revert "Fix: Add YouTube platform mapping and social media code fallback for CreativeX" nickviljoen 2026-02-13 17:16:41 +02:00
  • 799b6d50e8 Fix: Add YouTube platform mapping and social media code fallback for CreativeX nickviljoen 2026-02-13 17:00:35 +02:00
  • e327502723 Fix: Add YouTube platform mapping and social media code fallback for CreativeX nickviljoen 2026-02-13 17:00:35 +02:00
  • 9dbb7ce8d9 Revert "Fix: Re-enable FERRERO.MASTERASSETIDS field for PROD single-master uploads" nickviljoen 2026-02-13 16:41:57 +02:00
  • ea85749e0a Fix: Re-enable FERRERO.MASTERASSETIDS field for PROD single-master uploads nickviljoen 2026-02-13 14:20:01 +02:00
  • a2f1954038 Fix: CreativeX tracking ID fallback, filename stripping, and social media codes nickviljoen 2026-02-13 13:25:08 +02:00
  • 98826d51c4 Fix: CreativeX tracking ID fallback, filename stripping, and social media codes nickviljoen 2026-02-13 13:24:23 +02:00
  • 6517a4f83f Fix: Skip FERRERO.MASTERASSETIDS field on PROD - field not yet configured nickviljoen 2026-02-13 12:33:43 +02:00
  • b89a44984d Fix: Pass notifier to process_box_file and use case-sensitive Master ID check nickviljoen 2026-02-13 11:50:15 +02:00
  • 27916062ff Fix: Pass notifier to process_box_file and use case-sensitive Master ID check nickviljoen 2026-02-13 11:49:21 +02:00
  • 636b555d9d Fix: Define master_opentext_ids variable in A2→A3 and add multi-master support nickviljoen 2026-02-13 11:37:18 +02:00
  • 1b4e1a1cbc Fix: PPR MASTERASSETIDS payload updated to free text tabular field format nickviljoen 2026-02-09 15:28:37 +02:00
  • d72d37a83d Enhancement: Campaign re-opening support and PPR master asset ID registration nickviljoen 2026-02-05 21:07:13 +02:00
  • 26363f772d Enhancement: Campaign re-opening support and PPR master asset ID registration nickviljoen 2026-02-05 21:06:14 +02:00
  • 444ac7ac6d Fix: PPR multiple master asset IDs now correctly populate MASTERASSETIDS field nickviljoen 2026-02-03 21:02:09 +02:00
  • 57b4df2799 Security: Remove database password from permanently failed email template nickviljoen 2026-02-02 07:24:49 +02:00
  • fc9539d4b5 Security: Add .env files to .gitignore nick.viljoen 2026-01-31 18:07:44 +00:00
  • c90032b1d9 Fix: A1 retry logic now catches folder not found errors nickviljoen 2026-01-31 19:34:29 +02:00
  • e1f15ea632 Add A1 retry logic and orchestrator off-hours cadence nickviljoen 2026-01-31 17:38:57 +02:00
  • b7e0430636 Fix: Prevent DAM folder creation attempts causing timeouts nickviljoen 2026-01-30 10:34:53 +02:00
  • 04eccab9e7 Enhancement: Add environment-specific configurations and metadata improvements nickviljoen 2026-01-28 20:41:21 +02:00
  • f83b4fae3e PPR Environment: Use SIMPLE metadata structure for tabular fields nickviljoen 2026-01-23 16:52:50 +02:00
  • 272dd98d09 Field Mapping Update Agency Name nickviljoen 2026-01-20 19:46:31 +02:00
  • 5a2273459c Fix: Restore MAIN_LANGUAGES and defaults to exact working structure from before Jan 19 changes DJP 2026-01-20 08:37:41 -05:00
  • 827a90ae71 Fix: Restore field_value wrapper to MAIN_LANGUAGES and defaults - revert to working structure DJP 2026-01-20 08:06:52 -05:00
  • 27c23bd98f Enhancement: Add timestamps to batch entries in daily report for better identification DJP 2026-01-19 15:16:13 -05:00
  • a5b4c78b01 Fix: Increment campaigns_processed for file-based workflow batches to show in breakdown DJP 2026-01-19 15:13:58 -05:00
  • 72a02b3667 Fix: Add batch entries to workflow breakdown for file-based workflows in daily report DJP 2026-01-19 15:12:48 -05:00
  • 331f47d9ef Fix: Correct summary block parsing in daily report to capture all workflow activity DJP 2026-01-19 15:09:40 -05:00
  • 7eb99536b7 Fix: Add parsing for all workflow summary patterns in daily report DJP 2026-01-19 15:05:27 -05:00
  • e77a385cce Fix: Remove field_value wrapper from MAIN_LANGUAGES to resolve null value error DJP 2026-01-19 12:07:43 -05:00
  • a74d0914f9 Fix: Change date field type from 'date' to 'string' for MM/DD/YYYY format DJP 2026-01-19 11:59:13 -05:00
  • 4279bbc229 Fix: Correct JSON nesting for MAIN_LANGUAGES and Default Tabular Fields DJP 2026-01-19 11:55:58 -05:00
  • c01b69e2fb Fix: Add MetadataTableFieldRow wrapper to all Tabular Fields (MAIN_LANGUAGES, CreativeX, Defaults) DJP 2026-01-19 11:50:33 -05:00
  • 4a1a4fffa0 Fix: Update Asset Validity date format to MM/DD/YYYY DJP 2026-01-19 11:38:23 -05:00
  • fae3111467 Fix: Update Asset Validity date format to YYYY-MM-DD DJP 2026-01-19 11:23:33 -05:00
  • e2c2719055 Fix: Add MetadataTableFieldRow wrapper to Tabular Master Asset ID field DJP 2026-01-19 10:51:20 -05:00
  • 4b5cb0a98a Fix: Correct inner column ID for Tabular Master Asset ID field DJP 2026-01-19 10:45:47 -05:00
  • 2ef92674d3 Feat: Add subfolder path to A2->A3 email notifications DJP 2026-01-19 10:20:51 -05:00
  • ee6afe0888 Feat: Configurable Master Asset ID & Fix Date Type DJP 2026-01-19 09:40:55 -05:00
  • 0f984f3d7b Fix: Update asset validity date format to ISO-8601 string DJP 2026-01-16 13:53:41 -05:00
  • 631dba4390 Fix campaign ID storage - always set local_campaign_id DJP 2025-12-22 11:37:58 -05:00
  • 5586dcc5de Simplify derivative storage - only store dam_asset_id DJP 2025-12-22 10:16:14 -05:00
  • c901a79e24 Fix A2→A3 email template and database logging issues DJP 2025-12-22 10:12:36 -05:00
  • 222a53f466 Fix date field type error for ASSET VALIDITY START/END PERIOD DJP 2025-12-19 23:02:55 -05:00
  • 5e8745580a Fix folder detection for folders with periods (v2) DJP 2025-12-17 13:14:59 -05:00
  • 6d7aa7e95a Fix folder detection for folders with periods in names DJP 2025-12-17 13:06:02 -05:00
  • 599d468e44 Add Master Asset ID field to A2→A3 uploads DJP 2025-12-15 17:28:30 -05:00
  • 022f232224 Fix UnboundLocalError in A1->A2 uploader and add error email DJP 2025-12-10 08:36:16 -05:00
  • a7d17dd00d Add CSV attachment with campaign details to A1 and B1 success emails DJP 2025-12-07 19:27:36 -05:00