Data Import Center

Import your equipment data from Excel files into the dashboard

Dashboard Ready for Data

Your equipment tracking dashboard is fully functional and ready to display data. The import system is configured to accept your Excel files.

Method 1: File Upload

Upload your Excel file directly through the dashboard interface.

Status: Coming Soon

Method 2: Backend API

Use the backend API endpoint to import from a file path.

POST /api/trpc/import.importEquipmentFromFile

{ filePath: "/path/to/file.xlsx" }

Status: Ready

Excel File Format Requirements

Sheet Names

1-JCDC2-CPC

Required Columns

S.N

Serial number

Fleed code

Fleet code (unique)

Equipment

Equipment type

Status

Normal/Breakdown/Scrap

Activities

Active/Idle

Department

Department name

Capacity

Equipment capacity

Company/Supplier

Supplier name

Dashboard Features Ready

Real-time KPI Dashboard

Live equipment status overview

Advanced Analytics

Charts and forecasting

Breakdown Tracking

Maintenance prioritization

Department Views

Equipment allocation by dept

Advanced Search

Multi-field search capability

Mobile Responsive

Works on all devices