FellaHost Company Limited

Project Developers & Software Engineering Specialists

Document Reference: Section 24 Deliverables for Software Development Team

System Designation: Integrated Clearing, Forwarding & Logistics System (ICFLS)

Corporate Entity: FellaHost Company Limited

Headquarters: P.O. Box 80079, Dar es Salaam, Tanzania

9. Data Migration Templates & Ingestion Guidelines

Executive Overview

Legacy data from spreadsheet records, isolated accounting software, and manual port manifests must be extracted, cleansed, transformed, and ingested into the ICFLS MariaDB database according to strict ETL validation criteria.

9.1 Core Migration CSV Schemas

9.1.1 Customer Master Template (customers_import.csv)

customer_code,company_name,tin_number,vrn_number,email,phone,credit_limit_tzs,escrow_balance_tzs,status
CUST-001,Kilimanjaro Traders Ltd,104-981-224,40-001241-K,info@kt.co.tz,+255754000111,50000000.00,12500000.00,Active
CUST-002,Victoria Lake Mining Co,118-291-002,,procure@vicmining.co.tz,+255784999888,100000000.00,45000000.00,Active

9.1.2 Vehicle & Fleet Master Template (vehicles_import.csv)

plate_number,trailer_number,make,model,year,payload_tons,fuel_capacity_liters,status
T-882-DFR,T-104-EAA,Scania,R500,2022,32.0,600,Available
T-419-ABC,T-302-BBA,Volvo,FH16,2021,35.0,750,On_Trip

9.2 Ingestion Validation Pipeline

1. Deduplication Phase: Check TIN, VRN, and Container Numbers against active rows. Duplicate records are diverted to migration_rejects.csv.
2. Referential Resolution: Validate foreign keys (e.g. verify customer_code exists prior to attaching jobs).
3. Escrow Custody Reconciliation: Starting balances in escrow_balance_tzs must balance against historical bank ledger deposit statements.

Regulatory Notice

We're Top leading Company Registering under Commercial & Technical ICT Services TIN NO: 189-723-717

FellaHost Company Limited — Project Developers & Engineering Specialists.

Confidential & Proprietary Enterprise Asset — All Rights Reserved.