Data Source
How attendance records would flow from the existing turnstile system into this dashboard. Nothing is connected in this prototype.
Proposed data flow
Read-only extraction — existing attendance, payroll and HR systems remain unchanged
Existing attendance system
Product/version to be confirmed — sample assumes Lenel OnGuard turnstile IN/OUT events at sample sites BL & BK
Read-only extract
Connection method: to be confirmed (file export, database view or API). Sync schedule: to be confirmed.
Working Hours Monitoring
Pairing, calculation, exceptions & reports
Example import outcomes · illustrative
Sample states to show how results would be reported. Not real imports.
SuccessfulExample
4,812 records imported
All rows matched known badge IDs and valid timestamps.
PartialExample
4,790 imported · 14 rejected
14 rows had an unknown badge ID; held for review, not counted in hours.
FailedExample
0 records imported
Export file not found at the scheduled time; previous data kept unchanged.
Import history
Simulated entries
| Time (MYT) | Type | Received | Processed | Review |
|---|---|---|---|---|
| 16/11/2026 06:00 | Scheduled daily batch (simulated) | 41 | 40 | 1 |
| 15/11/2026 06:00 | Scheduled daily batch (simulated) | 121 | 117 | 4 |
| 14/11/2026 06:00 | Scheduled daily batch (simulated) | 143 | 139 | 4 |
| 13/11/2026 06:00 | Scheduled daily batch (simulated) | 132 | 128 | 4 |
| 12/11/2026 06:00 | Scheduled daily batch (simulated) | 141 | 137 | 4 |
| 11/11/2026 06:00 | Scheduled daily batch (simulated) | 95 | 92 | 3 |
Sample raw scan preview
Format assumed for the demo — to be matched to the customer's actual attendance-system export
| EmployeeID | Timestamp | Direction | Terminal |
|---|---|---|---|
| PG10203 | 2026-11-15 21:24:51 | OUT | BL-Main Gate T1 |
| PG10581 | 2026-11-15 20:17:43 | OUT | BL-Main Gate T2 |
| PG10441 | 2026-11-15 20:01:28 | OUT | BL-Main Gate T2 |
| PG10301 | 2026-11-15 19:38:41 | IN | BL-Main Gate T1 |
| PG10441 | 2026-11-15 17:43:08 | IN | BL-Canteen T3 |
| PG10581 | 2026-11-15 13:20:50 | IN | BL-Canteen T3 |
| PG10581 | 2026-11-15 12:40:32 | OUT | BL-Canteen T3 |
| PG10308 | 2026-11-15 08:25:06 | OUT | BL-Main Gate T1 |
| PG10301 | 2026-11-15 08:25:06 | OUT | BL-Main Gate T1 |
| PG10609 | 2026-11-15 08:23:20 | OUT | BL-Main Gate T1 |
| PG10280 | 2026-11-15 08:21:06 | OUT | BL-Main Gate T1 |
| PG10469 | 2026-11-15 08:20:41 | OUT | BL-Main Gate T1 |
| PG10413 | 2026-11-15 08:18:25 | OUT | BL-Main Gate T1 |
| PG10294 | 2026-11-15 08:18:03 | OUT | BL-Main Gate T1 |
| PG10399 | 2026-11-15 08:15:46 | OUT | BL-Main Gate T2 |
| PG10560 | 2026-11-15 08:14:11 | OUT | BK-Lobby T2 |
| PG10392 | 2026-11-15 08:12:05 | OUT | BL-Main Gate T2 |
| PG10266 | 2026-11-15 08:11:10 | OUT | BL-Main Gate T1 |
| PG10287 | 2026-11-15 08:09:42 | OUT | BL-Main Gate T2 |
| PG10532 | 2026-11-15 08:08:44 | OUT | BK-Lobby T1 |
| PG10616 | 2026-11-15 08:07:16 | OUT | BL-Main Gate T2 |
| PG10539 | 2026-11-15 08:07:55 | OUT | BK-Lobby T2 |
| PG10420 | 2026-11-15 08:05:14 | OUT | BL-Main Gate T1 |
| PG10476 | 2026-11-15 08:03:47 | OUT | BL-Main Gate T1 |
| PG10378 | 2026-11-15 08:03:29 | OUT | BL-Main Gate T2 |
| PG10371 | 2026-11-15 08:03:37 | OUT | BL-Main Gate T1 |
| PG10406 | 2026-11-15 08:00:38 | OUT | BL-Main Gate T1 |
| PG10203 | 2026-11-15 07:54:32 | IN | BL-Main Gate T1 |
| PG10581 | 2026-11-15 07:53:55 | IN | BL-Main Gate T2 |
| PG10441 | 2026-11-15 07:36:32 | IN | BL-Main Gate T2 |