MYOB Exo Time and Attendance accepts a generic data file for import into Exo Time and Attendance. The file format for the data file is specified below.
File Name: times.dat
File Type: Plain text, comma-separated value (CSV). No column headers.
|
File Column |
Description |
Format |
Example |
|
Clock ID |
Clock or Station ID. Number. 2-digit identifier. |
NN |
2 |
|
Date |
Date of the clocking. Note this is a 2 digit year. |
DDMMYY |
130111 |
|
Time |
Time of the clocking in 24 hour time format. |
HHMM |
1654 |
|
Card ID |
A combination of a 3-digit company identifier and a 3-digit card ID. |
NNNNNN |
999001 |
|
Cost Centre |
12-digit cost centre code. Multi-level codes are concatenated together. |
NNNNNNNNNNNN |
123 |