Back to Home

Data Migration

Structured loads into the remote STC database and dedicated UIs to review or correct migrated rows.

DND Tariff · Country workspace Matrix view by country: ports, charges, periods vs container buckets. Filter (e.g. Export + Demurrage), click cells to edit calendar days, currency, and rates. DND Tariff Lines Master Browse, filter, add, edit, and delete rows in stc_development_v1.dnd_tariff_lines_master. Matches workbook DND_Tariff_Lines_Master (country, port, charge type, periods, rates, and long text fields). DND Tariff · Period columns × equipment Spreadsheet-style F (free days), P1…Pn (period lengths), R (rates), TA (thereafter), plus a day timeline strip (like a 31-day Gantt). One row per equipment + lane. Same filters, flat grid, and cell editing as the country workspace.

Import from Excel

Create the table once, then load the sheet Data from your workbook (same column headers as the template).

cd backend npm run dnd:create-table npm run dnd:import-xlsx -- "D:/path/DND_Tariff_Lines_Master_v1.2.xlsx" --truncate

Omit --truncate to append. Database host and credentials come from MCP_DATABASE_* in backend/.env (never commit secrets).