A web-based database tracking system, custom-built to fit INL Bogotá requirements.
ViewTrack exists to give authorized government logistics personnel a single, secure, web-accessible view of cargo as it moves through the supply chain — from the moment it is received into the warehouse until it departs for its final destination. By extending our locally developed Cargo Management System to the web, we make accurate, real-time shipment status available to the people who need it, wherever they are.
The platform is based on reports from a locally developed Cargo Management System (CMS) that powers most of our functions. The CMS is a Microsoft Access database, highly customizable for our purposes. Its major functions are to track cargo from receipt into the warehouse until departure; provide basic warehouse management capability for storage and inventory; produce a “loading guide” for shipments (consolidations); and deliver order and shipment status to our customers through a variety of customized reports. It can detail line items received and line items shipped, and is suitable for the preparation of all required shipping documentation.
ViewTrack brings these capabilities online. Data from the CMS is exported and uploaded through the Archives module to feed the web platform, where authorized users query it through secure, role-based reports.
Clients — user accounts are created here so personnel can access the archives; accounts can be activated or deactivated at any time. Archives — Excel data is uploaded here to feed the system.
Manage warehouses, statuses and report parameters, manage two-factor authentication and user access, and review the audit log.
The system provides role-based logins for Reports, Warehouse and Web Administration. Each is protected by two-factor authentication: the account password plus a rotating 6-digit code from the user's authenticator app number at sign-in. The Clients submodule lets administrators activate or deactivate any user account, and client accounts are restricted to shipments in their assigned region.
ViewTrack runs on secure U.S. cloud infrastructure: a PostgreSQL database with row-level security, encrypted HTTPS transport, automatic scaling, and a complete audit trail. The site also installs as an app on phones and tablets, with recently viewed data available offline.
README.md for credentials and notes on connecting it to the live PHP/MySQL backend.