BundyPlus Timeclock File Format
The MYOB BundyPlus G6 Series Timeclock produces a data file for import into Exo Time and Attendance. The file format for the data file is specified below.
File Name: TRANSACTIONS.TXT
File Type: Plain text, comma-separated value (CSV). No column headers.
Field Name |
Data Type |
Length |
Description |
SiteID.ClockID |
Numeric |
4.4 |
The Site ID and Clock of the clock where the employee clocked in/out. Composed of the four-digit Site ID and four-digit Clock ID separated by a period, i.e. NNNN.NNNN. |
EmployeeID |
Numeric |
6 |
The identification of the employee that clocked in/out. Composed of the Company Card number (padded with zeros if less than three digits) and Employee Card number (padded with zeros if less than three digits). |
Date |
Character |
10 |
The date that the employee clocked in/out, in the format DD/MM/YYYY. |
Time |
Character |
8 |
The time that the employee clocked in/out, in the format HH:MM:SS. |
Department |
Numeric |
11 |
Optional field. Denotes the department code the employee used when they clocked in/out. |
Cost Centre Code Level 1 |
Numeric |
13 |
Optional field. Denotes the Cost Centre code (level 1) the employee used when they clocked in/out. |
Cost Centre Code Level 2 |
Numeric |
13 |
Optional field. Denotes the Cost Centre code (level 2) the employee used when they clocked in/out. |
Cost Centre Code Level 3 |
Numeric |
13 |
Optional field. Denotes the Cost Centre code (level 3) the employee used when they clocked in/out. |
Cost Centre Code Level 4 |
Numeric |
13 |
Optional field. Denotes the Cost Centre code (level 4) the employee used when they clocked in/out. |
Cost Centre Code Level 5 |
Numeric |
13 |
Optional field. Denotes the Cost Centre code (level 5) the employee used when they clocked in/out. Should be left blank, as Exo Time and Attendance supports four levels of Cost Centres only. |
This is a placeholder for topic contents.