This article describes the column layout and purpose of each field in the clocking file used by the Jarrison Time Remote Site import process. The same format is used when Jarrison time exports clockings (via Export > Clockings)
The file must follow the exact column order described below to ensure successful importing.
Column Definitions
| Column No. | Column Purpose |
|---|---|
| 1 | Placeholder column reserved for JT import logic |
| 2 | Sequence number for the record |
| 3 | Date and time of transaction |
| 4 | Employee number (unique identifier for the employee) |
| 5 | Direction of the clocking (e.g., In / Out, depending on configuration) |
| 6 | Device name |
| 7 | Placeholder column reserved for JT import logic |
| 8 | Clocking Type, as configured in the Devices setup window |
| 9 | Employee first name |
| 10 | Employee surname |