Workbook → Fleet Entity Mapping
Every column in the client workbooks (Drone Inventory In & Out.xlsx and Sample for Inventory.xlsx) is mapped to a field on a fleet entity — Drone, Deployment, Transfer, RepairTicket, TestSession, CrashReport, Component, GatePass, Invoice or Employee — with a declared data type. The validator walks each sheet, checks column presence, type conformance and required-fill, and reports a status per field.
Sheets mapped
19
Fields mapped
268
Source rows
1,473
OK fields
216
Warnings
28
Errors
24
Drone Inventory
Components ERP
People
Show Store ALLTransfer
Master DC ledger — feeds Transfer.fromLocationId / toLocationId, Transfer.expected (drone count), and updates Drone.locationId for the moved set.
Primary key: DC No.
9 ok 3 warn 0 error· 85 rows
| Source column (workbook) | Target field (entity) | Type | Filled | Type ok | Status | |
|---|---|---|---|---|---|---|
| DATEreq | createdAt | date | 49/85 (58%) | 3 bad | 3 cell(s) do not match type date | |
| Project Code | projectId | string | 58/85 (68%) | ✓ | Valid | |
| Type of drone | droneType | string | 27/85 (32%) | ✓ | Valid | |
| DC No.req | dcNumber | string | 82/85 (96%) | ✓ | Valid | |
| DRONE BOXES | boxes | integer | 82/85 (96%) | 4 bad | 4 cell(s) do not match type integer | |
| Actual No. of DRONESreq | expected | integer | 84/85 (99%) | ✓ | Valid | |
| FROMreq | fromLocationName | string | 83/85 (98%) | ✓ | Valid | |
| TOreq | toLocationName | string | 84/85 (99%) | ✓ | Valid | |
| STORE COUNT | received | integer | 85/85 (100%) | ✓ | Valid | |
| Remarks | notes | string | 51/85 (60%) | ✓ | Valid | |
| POC | actor | string | 5/85 (6%) | 1 bad | 1 cell(s) do not match type string | |
| Documents | documentUrl | url | 76/85 (89%) | ✓ | Valid |
Sample mapped record
{
"createdAt": "2026-02-21T00:00:00",
"projectId": null,
"droneType": null,
"dcNumber": "DC/25-26/UP-007",
"boxes": 41,
"expected": 410,
"fromLocationName": "Udaipur",
"toLocationName": "Store",
"received": 410,
"notes": null,
"actor": null,
"documentUrl": "https://drive.google.com/drive/folders/191-Zi-McXWSbLfLLyffl-w6GEZwHoBNA?usp=sharing"
}