📁 1. Load Legacy Portfolio Dataset
Upload your exported JSON portfolio, paste/edit JSON directly, or download the verified sample reference file.
Click to browse or drop your .json file here
Accepts array of facilities or { "records": [ ... ] }
⚙️ 2. Execution Mode & Ingestion Controls
Execute a safe pre-flight validation check (Dry-Run) or commit records directly into the PostgreSQL database.
🛡️ Run Dry-Run Simulation (Recommended First)
Simulates complete 100% multi-level validation, tests 12-digit Iraqi Civil ID formats, checks for duplicate borrowers, and forecasts migration counts with ZERO writes to database.
🚀 Execute Live Production Migration
Commits facilities to PostgreSQL within atomic database transactions, injects active schedules, locks closed facilities, links customers, and records audit entries.
Why Chunk Size? For large portfolios (e.g. 1,000+ loans), sending everything in one request causes server timeouts and memory spikes. Chunking automatically splits your data into batches and streams them sequentially with live progress.
Target endpoint for the batch processing engine (POST /api/migration/loans/bulk).
🔒 Top Secret Credential: Must be provided manually by the user. The system verifies its authenticity and active status directly against the database before proceeding.