Operations Control
Tracker Import
AD
Datalink Tracker Upload
Expected sheets: PAT_H_S_E_ SCAN, cables, boxTopoRelation, Power Test Result disabled, box.oaiObject, and Power Test Result_OLD.
Validation Rules
1Duplicate DU IDRule
2Duplicate FAT Name inside DURule
3Duplicate box serial QRRule
4Missing latitude or longitudeRule
5Cable without source/destinationRule
6OUT_PORT count over model capacityRule
7IN_PORT missingRule
8Cascade port conflictRule
Workbook Mapping
The import layer stores raw rows first, then converts approved records into master tables.
| Sheet | Primary Purpose | Key Columns | Destination |
|---|---|---|---|
| PAT_H_S_E_ SCAN | DU and box master | DU ID, XBOX, HUB, FAT Name, GPS, serial | du_master, boxes, box_ports |
| cables | Cable inventory per DU/FAT | fiberCores, length, snCode | cables |
| boxTopoRelation | Topology and ports | portInfo.portCode, portInfo.portType | box_connections |
| Power Test Result | Optical test results | Port No., power dBm, result | power_test_results |