Now Debug View shows assets with same rich metadata as A1→A2 Download tab:
Asset Display Features:
- Asset cards with name, ID, type, file size
- "View Metadata" button for each asset
- Expandable metadata sections:
- 📋 Basic Info (brown border) - Brand, Country, Language, etc.
- 🖼️ Content Info (green border) - Width, Height, Duration, etc.
- 📁 Custom Fields by category (yellow border, collapsible)
- Full Raw JSON (collapsible for complete asset data)
Uses MetadataExtractor::extractAllMetadata() for rich data extraction.
Workflow:
1. Select campaign
2. Click Master or Final button
3. See all assets in that folder
4. Click "View Metadata" on any asset
5. See complete metadata organized by category
6. Expand/collapse sections as needed
7. View raw JSON for debugging
Perfect match to Download tab's proven UX pattern.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Fixed folder loading to use exact same logic as Download tab:
- Added missing $configV3 parameter to findMasterAssetsFolder() call
- Now uses same helper functions as A1→A2 Download tab
- Stores assets in debug_campaign_assets (not transformed)
- Displays assets in simple table matching Download tab style
Table improvements:
- Simplified to 4 columns: Type, Asset Name, File Size, Asset ID
- Removed confusing Campaign/Folder and Status columns
- Shows actual file sizes from asset data
- Truncated Asset ID display (first 12 chars)
- Cleaner, more focused view
Should now show ALL assets from the selected folder, not just one.
Uses getAssetsFromFolder() which returns all assets, not just folders.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Fixed:
- Removed duplicate findMasterAssetsFolder() that was causing fatal error
- Function already exists at line 1371 with correct 3-parameter signature
- Kept only extractStatusFromAsset() helper function
The duplicate function declaration was preventing PHP from loading.
Now using existing findMasterAssetsFolder($testRunner, $campaignId, $configV3).
Should fix 500 error when clicking Master/Final buttons.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Fixed:
- Replaced non-existent createAssetManager() with existing helper functions
- Added findMasterAssetsFolder() helper function (mirrors findUploadFolder logic)
- Added extractStatusFromAsset() helper to extract status from asset metadata
- Uses existing getAssetsFromFolder() function to retrieve assets
Now properly:
- Finds Master Assets folder using findMasterAssetsFolder()
- Finds Final Assets folder using findUploadFolder()
- Gets assets using getAssetsFromFolder()
- Extracts status from asset metadata structure
No more 500 errors - folder viewing should work now!
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Fixed button issues:
- Increased button size: font-size 13px (was 11px), padding 8px 12px (was 4px 8px)
- Changed from btn-sm to btn-secondary for better visibility
- Added font-weight: 500 for better readability
- Buttons now more prominent and easier to click
Added JavaScript debugging:
- Console.log statements to track button clicks
- Form submission verification
- Error alerts if forms not found
- Helps diagnose any submission issues
Button improvements:
- Larger, more clickable buttons
- Better visual weight with Montserrat medium (500)
- Proper spacing between Master and Final buttons
- More professional appearance
Check browser console (F12) for debugging info if buttons still don't work.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Fixed:
- Added missing <?php endif; ?> for selected_campaign_debug section
- File now loads properly without parse errors
The endif was missing after the Campaign Folder Contents section
at line 3838, causing "unexpected end of file" error.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Fixed folder selection workflow:
- Now select campaign FIRST, then view its Master/Final folders
- When you select a campaign (radio button), action buttons appear in Actions column
- Click "📂 Master" or "📂 Final" buttons to view that campaign's specific folders
- Much more intuitive - doesn't load ALL folders at once
- JavaScript shows/hides folder buttons based on selection
Fixed table layout:
- Added table-layout: fixed for consistent column widths
- Set specific widths: Select(60px), Name(40%), Number(150px), Status(120px), Actions(150px)
- Added vertical-align: middle for proper cell alignment
- Added text-align: center for Select and Status columns
- Added overflow-x: auto wrapper for responsive scrolling on small screens
New action handler:
- select_campaign_and_view_folders: Stores selected campaign and loads its specific folder
Improved UX flow:
1. Click "Load All Campaigns"
2. See table of all campaigns
3. Select a campaign with radio button
4. Action buttons (Master/Final) appear in that row
5. Click button to view that specific campaign's folder
6. Table columns now properly aligned
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Branding Updates:
- Applied Ferrero brown (#431b06) throughout app (replaced all blues)
- Darker brown (#6b2d10) for gradients and hover states
- Added Montserrat font family across entire application
- Updated header gradient to Ferrero brown tones
- Font weights: 300 (light), 400 (regular), 500 (medium), 600 (semi-bold), 700 (bold)
Debug View Improvements:
- Added Reset/Clear Results button for easy cleanup
- Added "How to use" instructions box with step-by-step guide
- Improved button labels with icons (📂 for folders)
- Enhanced visual hierarchy with Ferrero brown accents
- Better spacing and readability
Color Changes:
- Primary color: #431b06 (Ferrero brown)
- Hover/gradient: #6b2d10 (darker brown)
- Accent backgrounds: #fff9f5 (light brown tint)
- All buttons use Montserrat font with proper weights
- Active tab now uses Ferrero brown with increased weight
UI Enhancements:
- Clear folder navigation instructions
- Reset button appears when results are loaded
- Consistent Ferrero branding throughout
- Professional, clean Montserrat typography
- Improved visual feedback with brown accents
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
New Debug View tab features:
1. Campaign Status Management
- Load all campaigns across all statuses (A1-A6, B1-B2)
- Display in table with campaign name, number, current status
- Radio button selection for choosing campaign
- Dropdown to select target status
- Update button to change status
- Success/failure feedback with before/after status
2. Folder Viewer
- View Master Assets folder (01. Master Assets)
- View Final Assets folder (01. Final Assets)
- Displays folder contents in table
- Shows type (folder/asset), name, campaign ID, status
- Drill down into subfolders with "View Contents" button
- Extracts campaign metadata (Campaign ID, Content Scaling Status)
Action handlers added:
- load_all_campaigns_debug: Loads campaigns from all statuses
- update_campaign_status_debug: Updates selected campaign to target status
- view_master_assets_folder: Views Master Assets folder contents
- view_final_assets_folder: Views Final Assets folder contents
- view_folder_contents: Views subfolder contents (recursive)
Helper functions:
- extractCampaignId(): Extracts FERRERO.FIELD.CAMPAIGN ID from metadata
- extractStatus(): Extracts CONTENT.SCALING.STATUS from metadata
Perfect for testing workflow progression and inspecting DAM folder structure
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Fixes:
1. PHP: Fixed function name
- Changed findFinalAssetsFolder() → findUploadFolder()
- This function already looks for Final Assets folder
- Now PHP interface works without fatal error
2. Python: Search for Global comm campaigns
- Added campaign_type parameter to search_campaigns()
- B1→B2 uses: campaign_type='Global comm'
- A1→A2 uses: campaign_type='Local Adaptation' (default)
3. Python: Fixed log messages
- 'Searching for B1 Global campaigns' (not A1)
- 'No B1 campaigns found' (not A1)
4. Box Folder Configuration
- B1→B2 uses folder: 349261192115
- Folder naming: MASTERS_Campaign_Name
B1→B2 Now:
✅ Searches Global comm campaigns
✅ Filters for B1 status
✅ Uses Final Assets folder (05. not 01.)
✅ Uploads to correct Box folder (349261192115)
✅ Names folders: MASTERS_NUTELLA_PLANT-BASED_LAUNCH
Test:
1. Refresh PHP app - should load now
2. B1→B2 tab should work
3. Python script should find B1 campaigns
🤖 Generated with Claude Code
Fixes:
1. Added debug_all_global_campaigns Handler
- Shows ALL Global comm campaigns
- Displays campaign name, type, status, asset ID
- Collapsible details for each campaign
2. Added Selected Campaign Display
- Shows when B1 campaign is selected
- Includes debug folder structure link
- 'Get Global Master Assets' button
3. Added Debug Global Campaigns Display
- Shows debug results for Global campaigns
- Similar to A1→A2 debug display
Next: User will click debug link to see folder structure
and determine if assets are at root or in subfolder.
Test:
1. Go to B1→B2 tab
2. Click '🔍 Debug: Load ALL Global Campaigns'
3. Should see campaigns list
4. Click 'Load Campaigns (B1)'
5. Select NUTELLA campaign
6. Click '🔍 Debug folder structure' link
7. See what folders/files exist
🤖 Generated with Claude Code
Added to B1→B2 Tab:
1. Clear Workflow Data Button
- 🗑️ Clear button (same as other tabs)
- Clears session data for fresh start
- Shows when tab is active and has data
2. Selected Campaign Display
- Shows selected campaign name and ID
- Displays campaign type (Global Masters)
- Shows asset ID for reference
3. Status Update Section
- Yellow warning box
- Update Status: B1 → B2 button
- Instructions for workflow
4. Fixed update_status_to_b2 Action
- Accepts campaign_id from POST (debug button)
- OR from selected_campaign_b1 (selected campaign)
- Works from both locations
Now B1→B2 Tab Has:
✅ Load B1 campaigns
✅ Debug load all Global campaigns
✅ Clear workflow data button
✅ Campaign selection
✅ Selected campaign display
✅ Update status B1 → B2
✅ Matches A1→A2 functionality
Test: Refresh app and try selecting a B1 campaign!
🤖 Generated with Claude Code
Co-Authored-By: Claude <noreply@anthropic.com>
Added to workflow_v3.php:
Tab Navigation:
✅ New tab button: 🌍 Global Masters (B1→B2)
✅ Tab positioned after Upload from Box
Tab Content:
✅ B1 campaign loading interface
✅ Campaign selection grid
✅ Debug button for all Global campaigns
✅ Status display (B1 badge)
Action Handlers:
✅ load_campaigns_b1 - Load Global campaigns with status B1
✅ select_campaign_b1 - Select a B1 campaign
✅ update_status_to_b2 - Update status B1 → B2
✅ reset_to_b1 - Reset campaign to B1 (for testing)
Helper Function:
✅ loadCampaignsGlobal() - Searches Global comm campaigns and filters by status
The tab is functional for basic campaign selection and status updates.
Next: Add full workflow (download assets, upload to Box, etc.)
Test:
1. Refresh app
2. Click 🌍 Global Masters (B1→B2) tab
3. Click Load Campaigns
4. Should see NUTELLA PLANT-BASED LAUNCH
🤖 Generated with Claude Code
StatusManager Enhancements:
✅ searchGlobalCampaigns() - Search for 'Global comm' campaigns (B1-B2 workflow)
✅ searchAllCampaignTypes() - Search for ALL campaigns (Local + Global)
Workflow Updates:
✅ Debug search now uses searchAllCampaignTypes()
✅ Shows both 'Local Adaptation' and 'Global comm' campaigns
✅ Updated success message: 'Local Adaptation + Global comm'
This fixes the issue where B1 campaigns weren't showing in debug view.
Test:
1. Click '🔍 Debug: Load ALL Campaigns' in any workflow tab
2. Should now see Global comm campaigns with B1/B2 status
3. Example: NUTELLA PLANT-BASED LAUNCH (Status: B1)
Next: Add dedicated B1→B2 workflow tab and status change buttons
🤖 Generated with Claude Code
Added CREATIVEX Field Display:
✅ New dedicated section in metadata viewer
✅ Purple border-left (color: #9b59b6) for visibility
✅ Shows count in summary: 🎯 CREATIVEX Fields (X)
✅ Grid layout: Field Name | Value
✅ Shows field ID below value for reference
✅ Auto-expanded (open attribute)
✅ Applied to both Master Assets and Final Assets views
MetadataExtractor Enhancement:
✅ Extracts all CREATIVEX fields separately
✅ Stores in metadata['creativex_fields']
✅ Handles both regular and tabular CREATIVEX fields
✅ Handles multiple value structures
Display Features:
- Field name as label
- Value displayed prominently
- Field ID shown below (gray text)
- Supports array values (comma-separated)
- Easy to identify with purple color
- Section expanded by default for visibility
CREATIVEX fields will now be prominently displayed in their own
section when viewing Master Assets or Final Assets metadata.
🤖 Generated with Claude Code
Changes:
1. Default Box Folder ID
- Pre-filled with: 348526703108
- Saves time entering same folder repeatedly
- Still editable for different folders
2. Video Dimensions in Upload Manifest
- Extract video metadata via ffprobe (width, height, duration, bitrate)
- Add width and height to upload manifest
- Manifest now includes: file_name, file_type, width, height
- Should fix Content Info showing -1 for Width/Height
3. CREATOR Field Disabled
- "ExternalAgency" value still causes upload failure
- Leaving CREATOR field from master unchanged
- Need to investigate exact field structure
4. Working Field Updates (Re-enabled):
✅ ARTESIA.FIELD.ASSET DESCRIPTION → subject_title from filename
✅ FERRERO.FIELD.STATE → "Local"
✅ MAIN_LANGUAGES → language_code from filename
Upload Flow Now:
1. Parse V2 filename
2. Load master metadata from DB
3. Download file from Box
4. Extract video metadata (ffprobe)
5. Build MVP asset rep with field updates
6. Add video dimensions to upload manifest
7. Upload to DAM
8. Width/Height should populate (not -1)
Logging:
- "VideoMetadata: Extracted - 1024x576, 2s, 1006892 bps"
- "SIMPLE UPLOADER: Adding video dimensions to manifest - 1024x576"
🤖 Generated with Claude Code
UI Changes:
- Box Folder ID input now defaults to: 348526703108
- Pre-filled but still editable
- Saves time re-entering same folder
Field Updates RE-ENABLED (confirmed working):
1. ARTESIA.FIELD.ASSET DESCRIPTION
- Set to subject_title from V2 filename
- Example: "TEST-JOB11"
2. FERRERO.FIELD.STATE
- Force to "Local" for all uploads
- Valid domain value (Global/Local)
3. MAIN_LANGUAGES
- Set from V2 filename language_code
- Example: "de" → "DE"
Field Updates KEPT DISABLED:
- FERRERO.MARKETING.CREATOR
- "Oliver Agency" is invalid (not in 1,893 domain values)
- Keeping master value to avoid validation failure
- Valid options: "ExternalAgency", "ExternalAgencynew"
Video Metadata:
- Extracted via ffprobe (width, height, duration, bitrate)
- Logged for reference
- Not sent to DAM (DAM analyzes automatically)
Result:
✅ Default folder ID saves time
✅ Description from filename
✅ State always Local
✅ Language from filename
✅ All uploads should work
🤖 Generated with Claude Code
New Features:
1. VideoMetadataExtractor class
- Uses ffprobe to extract video technical metadata
- Width, height, duration, bitrate, aspect ratio
- Frame rate, codec info
- Formatted duration (HH:MM:SS:FF timecode)
- Formatted aspect ratio (16:9, 4:3, etc.)
2. Updated MetadataExtractorMVP
- Now accepts local file path parameter
- Extracts video metadata from downloaded file
- Updates fields from V2 filename:
* ARTESIA.FIELD.ASSET DESCRIPTION ← subject_title from filename
* FERRERO.FIELD.STATE ← Always "Local" for uploads
* FERRERO.FIELD.MKTG.ASSET TYPE ← asset_type from filename
* MAIN_LANGUAGES ← language_code from filename
- Adds FERRERO.MARKETING.CREATOR ← "Oliver Agency"
- Logs video dimensions and technical data
3. Workflow integration
- Pass local file path to buildMVPAssetRepresentation()
- Video analysis happens after Box download
- File metadata extracted before upload
Field Updates Summary:
✅ Description → From filename (TEST-JOB11)
✅ State → Local (forced)
✅ Creator → Oliver Agency
✅ Main Languages → From filename (de → DE)
✅ Asset Type → From filename (OLV)
✅ Video metadata extracted (width, height, duration, bitrate)
Next: Test ffprobe extraction and determine where to inject video
technical fields in upload structure (content_info vs metadata).
🤖 Generated with Claude Code
Issue: Final Assets showing only Basic Info and Content Info, no Ferrero metadata
Cause: Display was looking for 'ferrero_fields' but MetadataExtractor creates 'custom_fields'
Fix:
- Changed Final Assets metadata display to use custom_fields
- Now displays all metadata organized by category
- Shows format: 📁 Category Name (X fields)
- Each category is collapsible
- Same structure as Master Assets display
MetadataExtractor creates:
- metadata['basic'] - Basic asset info
- metadata['content'] - Content dimensions/type
- metadata['custom_fields'][Category] - All Ferrero fields organized by category
- metadata['permissions'] - Access permissions
- metadata['renditions'] - Rendition info
Now Final Assets will show ALL uploaded metadata fields organized by category.
🤖 Generated with Claude Code
New Approach:
Instead of sending ALL metadata or just 5 fields, extract ONLY the
MVP fields from the master asset metadata.
MetadataExtractorMVP.php:
- New class dedicated to MVP field extraction
- Lists all 28 MVP field IDs from asset_representation MVP.json
- extractMVPFields(): Searches master metadata for MVP fields
- Preserves exact field structure from master (domain values, tabular fields)
- buildMVPAssetRepresentation(): Creates upload JSON with only MVP fields
- Updates ASSET NAME field to clean filename
MVP Fields Extracted (28 total):
- FERRERO.FIELD.MKTG.ASSET TYPE
- FERRERO.FIELD.FISCAL YEAR
- MAIN_LANGUAGES
- FERRERO.FIELD.ASSETCOMPLIANCE
- MARKETING_TAG
- FERRERO.MARKET.FIELD.TYPE_VID
- 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/END PERIOD
- FERRERO.MARKETING.FIELD.AGENCY NAME
- FERRERO.MARKET.FIELD.IPRIGHT
- FERRERO.MARKET.PROD_COMPANY
- [... and 12 more fields]
Workflow Changes:
- Use MetadataExtractorMVP instead of MetadataMerger for building asset rep
- Extract MVP fields from full master metadata
- Update ASSET NAME to clean filename
- Log how many fields found vs expected
Benefits:
✅ Includes all MVP metadata (not just 5 fields)
✅ Preserves exact field structures from master
✅ Smaller payload than full metadata (~10-15KB vs 128KB)
✅ Should work reliably while including more metadata
Next: Test if uploads now appear in folder with MVP metadata.
🤖 Generated with Claude Code
Issue: Assets reporting HTTP 202 success but not appearing in folder
Hypothesis: Large metadata payload (128KB) may be causing silent failures
Rollback Changes:
- MetadataMerger.buildAssetRepresentation() now creates SIMPLE structure
- Only 5 fields (proven to work):
1. FERRERO.FIELD.MKTG.ASSET TYPE (from filename)
2. FERRERO.FIELD.FISCAL YEAR (default)
3. MAIN_LANGUAGES (from filename)
4. ARTESIA.FIELD.ASSET NAME (clean filename)
5. FERRERO.FIELD.STATE (Local)
- Removed complex master metadata merging
- Added logging for field values
- Pass parsed filename to buildAssetRepresentation()
Test this to see if uploads now appear in Final Assets folder.
Note on DELETE:
HTTP 405 - Method not supported. DAM may not allow DELETE via API.
Need to investigate alternative approach (move to trash, mark as deleted, etc.)
🤖 Generated with Claude Code
debug_assets.php Changes:
- Added delete_asset action handler
- DELETE /v6/assets/{id} API call
- 🗑️ Delete button for each asset
- Confirmation dialog before delete
- Auto-refresh folder after delete
- 🔄 Refresh button to reload folder assets
- Success/deleted message display
workflow_v3.php Changes:
- Show upload folder ID in success message
- Add 🔍 View in Final Assets Folder link
- Direct link to debug_assets.php with folder ID
- Pass upload_folder and master_asset_id in response
Features:
✅ Delete test assets easily
✅ Refresh folder to see latest uploads
✅ Direct link to view uploaded assets in folder
✅ Confirmation before delete
✅ Auto-redirect after delete
Usage:
1. Upload asset → Click 🔍 View in Final Assets Folder link
2. See all assets in that folder
3. Click 🗑️ Delete to remove test assets
4. Click 🔄 Refresh to reload after upload
🤖 Generated with Claude Code
Database Changes:
- ALTER TABLE master_assets ADD COLUMN full_metadata JSONB
- Stores COMPLETE DAM asset metadata (no 5,000 char truncation)
- PostgreSQL JSONB type for efficient storage and querying
DatabaseClient Changes:
- Added full_metadata to INSERT and ON CONFLICT UPDATE
- Store complete json_encode($assetData) in full_metadata column
- Simplified description to just Box info (no metadata)
- Log metadata size when storing
- NO TRUNCATION - preserves all fields
Workflow Changes (workflow_v3.php):
- load_master_metadata: Read from full_metadata JSONB column
- upload_from_box: Read from full_metadata JSONB column
- Both endpoints now get COMPLETE master metadata
- Added logging for metadata size verification
Impact:
BEFORE: Only 5,000 chars stored (truncated)
AFTER: Full metadata stored (10,000+ chars, all fields preserved)
Next Step:
Re-download master assets to populate full_metadata for existing records.
New downloads will automatically use the new column.
🤖 Generated with Claude Code
New Features:
- Added 'Get Final Assets' button in Download (A1→A2) workflow
- View uploaded/localized assets in Final Assets folder
- Display metadata for final assets (same format as master assets)
- Shows asset name, ID, type, size, metadata model
Backend:
- Added get_final_assets action handler
- Loads assets from Final Assets folder (findUploadFolder)
- Uses same getAssetsFromFolder helper as Master Assets
Frontend:
- 'Get Final Assets (Uploaded)' button next to 'Get Master Assets'
- Final Assets list with expandable metadata
- Metadata display includes:
- Basic Info (name, type, size, model)
- Content Info (dimensions, format, etc.)
- Ferrero Fields (all custom metadata)
UI Styling:
- Green border-left for Final Assets (vs blue for Master)
- Same metadata extraction using MetadataExtractor
- Collapsible metadata view per asset
This allows users to verify uploaded assets and review their metadata.
🤖 Generated with Claude Code
Changes:
1. Added uploadWithMetadata() method to AssetUploaderSimple
- Accepts custom asset representation from MetadataMerger
- Same proven structure as uploadFile() but with custom metadata
2. Fixed database metadata extraction in upload_from_box
- Metadata stored in description field, not separate column
- Extract JSON after 'DAM Metadata JSON:' marker
- Parse and store in masterAsset['metadata']
3. Updated upload call to use uploadWithMetadata()
- Rename temp file to clean filename before upload
- Pass merged asset representation
- Upload to correct folder
This fixes all the upload processing errors.
🤖 Generated with Claude Code
The metadata is stored in the description field, not a separate metadata column.
Updated both AJAX endpoints to extract JSON from description field.
Format: 'Box File ID: xxx\nDAM Metadata JSON:\n{...}'
Changed:
- Removed 'metadata' from SELECT query
- Extract JSON from description field after 'DAM Metadata JSON:' marker
- Parse JSON and store in masterAsset['metadata']
This fixes the upload process to correctly load master metadata.
🤖 Generated with Claude Code
DatabaseClient uses standard constructor, not singleton pattern.
Changed all DatabaseClient::getInstance() to new DatabaseClient()
This fixes the upload_from_box AJAX endpoint fatal error.
🤖 Generated with Claude Code
Critical bug fix - upload_directory was always NULL because
uploadFolderId wasn't being passed to storeMasterAsset().
Now passes uploadFolderId as 5th parameter.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
When user clicks 'Get Master Assets', now also:
- Finds Final Assets folder in campaign
- Stores folder ID in session
- Shows in success message
This folder ID is passed to Box upload → stored in database upload_directory column.
Later used for A2→A3 upload workflow to know where to upload files back to DAM.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Workflow now:
1. Get Master Assets → Also finds Final Assets folder
2. Download & Upload to Box → Passes upload folder ID
3. Database stores upload_directory = Final Assets folder ID
This ensures each asset record has the DAM upload target folder stored for later use in A2→A3 workflow.
UI shows upload folder ID in success message.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Box upload results now display:
- Tracking ID with green highlight
- Clickable Box link with icon
- Database storage status (✅ Stored or ❌ Failed)
- ID source (database_direct, random, etc.)
Makes it clear when database integration is working.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Database Integration:
- IDGenerator now connects to PostgreSQL (localhost:5433)
- Generates tracking IDs with uniqueness check against master_assets table
- Fallback to random if database unavailable
- Direct PDO connection to ferrero_tracking database
DatabaseClient:
- Stores master assets in PostgreSQL
- Records: tracking_id, opentext_id, Box links, full metadata JSON
- Updates on conflict (upsert pattern)
- Stores box_file_id and box_url for reference
Box Metadata Enhancement:
- Uses Box metadata template API (enterprise/ferreroDAMMetadata)
- Stores full DAM metadata JSON in 'Ferrero-DAM-Metadata' field
- Fallback to file description if template not configured
- Handles template conflicts (updates existing)
Box Upload Results Now Show:
- Unique tracking ID (from database)
- Box file links (clickable)
- Database storage status
- ID source (database_direct, random, etc.)
Complete workflow: DAM → Download → Generate ID → Upload to Box → Store in DB
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Box OAuth requires app to be configured for client credentials grant.
Using developer token as fallback (valid 60 minutes).
User needs to:
1. Go to https://app.box.com/developers/console
2. Generate new Developer Token
3. Update token in code (expires hourly)
OR configure Box app for OAuth 2.0 client credentials grant.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
New Box Integration Features:
- BoxClient class for Box API operations
- IDGenerator for 6-character unique IDs (A-Z a-z 0-9)
- Auto-create campaign folders in Box
- Rename files with unique ID suffix (filename_ID.ext)
- Upload metadata JSON to Box custom fields
- Track Box file IDs and URLs
Download Workflow Enhancement:
- New button: '📥📦 Download & Upload to Box'
- Downloads from DAM → Uploads to Box
- Each file gets unique 6-char ID
- Creates campaign folder: {campaign_id}_{campaign_name}
- Results show: original → renamed filename with ID
Box Configuration:
- Developer Token: e7Q1kS6rOM1tH2ezzCg4KgRfcyNW2JHI
- Root Folder: 348304357505
- OAuth creds in Box-config.json
ID Generation:
- Phase 1: Random 6-char (current)
- Phase 2: PostgreSQL DB via REST API (ready to integrate)
Metadata Storage:
- Stored in Box file description (custom metadata field later)
- Full DAM metadata JSON preserved
- Includes: asset_id, campaign info, all metadata fields
Ready for testing! Download workflow now stores assets in Box with tracking.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
AssetUploaderSimple - exact copy of standalone logic:
- Only 5 metadata fields (not 17)
- Same field order and structure
- Same cURL options
- Produces ~1200 byte payload like standalone
Test upload now uses AssetUploaderSimple for exact match.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Standalone test now accepts token as command line argument instead of
trying to get new token (credentials may have changed).
UI now shows OAuth token in expandable section for copying to standalone test.
Usage: php test_upload_standalone.php "eyJraWQiOiI0Y..."
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
Test upload was passing null for master asset, causing it to use
minimal structure instead of the full Postman metadata.
Now passes dummy master asset to trigger buildAssetRepresentationFromMasterAsset()
which contains all 17 required metadata fields.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
New test upload panel in Upload workflow:
- Upload directly to any folder ID (bypasses campaign selection)
- Pre-filled with test folder: e96080ba0cd1427d253a28a87504b6665eaa02cb
- Folder ID can be edited for testing different folders
- Shows success/failure with full error details
- Uses same upload mechanism as regular workflow
Use case:
- Test if specific folders allow uploads
- Bypass campaign workflow for testing
- Verify folder permissions
- Isolate upload issues
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
New feature in Download workflow (A1→A2):
- Added '💾 JSON' button next to each master asset
- Downloads complete asset metadata as JSON file
- Filename format: {assetname}_metadata.json
- Pretty-printed JSON for readability
Use case:
- Inspect full metadata structure
- Reference for upload field requirements
- Debug metadata field values
- Documentation of master asset data
Buttons per asset:
- 📥 Download (file)
- 💾 JSON (metadata)
- 📋 View (toggle metadata display)
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude <noreply@anthropic.com>
