The PeopleHub file is a fixed-length flat file used to import attendance data into PeopleXD. You can use the column structure and key rules below to ensure your file is set up correctly before importing.
đNote: The column positions and field lengths can vary for different customers and different sources of the file. Always confirm the correct specification for your configuration before building the file.
File column structure
Each record in the PeopleHub file must conform to a strict column structure. An example of the fields, positions, and lengths is shown below:
Field | Start | Length | Notes |
Location | 1 | 4 | Site/depot code |
Employee | 5 | 8 | Employee number |
Day Number | 13 | 2 | Day within the file period |
Run Number | 15 | 3 | Sequence within the day |
Status | 18 | 2 | Attendance status code (e.g. WRK, RW) |
Start Time | 20 | 4 | HHMM format |
End Time | 24 | 4 | HHMM format |
Planned Duration | 28 | 4 | In minutes |
Grade | 32 | 4 | Employee grade code |
NI Number | 36 | 9 | National Insurance number |
Key rules
When building the PeopleHub file, follow these rules to ensure each record is valid:
All fields are fixed-length â padding with spaces is required where values are shorter than the defined length.
Day Number is used to derive the clock date when the Use Day Number for Clock Date parameter in Attendance Shift General Settings is enabled. The clock date is calculated as: File Date + Day Number â 1.
Run Number sequences each clocking event within a day.
â ď¸Important: If fields are not padded to their defined length, the file will not import correctly. Ensure all values are right- or left-padded with spaces as required by your configuration.