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. |