Africlock Manual
Menu

Export attendance records

Export attendance records
11. Comma-delimited file
This option exports comma-delimited attendance records (see Comma-delimited attendance import above). The file format is shown here.
22. Excel file
This option (which requires you to have Excel installed on the same computer as your clocking system) will export attendance records in Excel format.

Export file (CSV, Excel) (attendance records)

Emp no - official employee number, maximum length of string (10); Emp name - Employee's surname and initials
Button number - string (16); Day - name of the day e.g Wed
Date of attendance record; Time of clock movement (in); Time of clock movement (out)
Status/Type - manually edited/clocked
Time due - what is the required time according to the employee's time programme
Standard time - time worked (overtime/short time excluded);
Overtime - what was the amount of overtime worked
Short time - how many hours was the employee short for the day; Total time - Overtime and short time included.
33. Accord
Software Farm's 'Accord' system has the ability to import attendance records. Contact us for advice on the use of this feature.
44. Show Accord data
This will display the Accord export data so that you can check its correctness before running the import function from within Accord.
55. EMWIN
Attendance printout and export file for EMWIN payroll.
 
The online help was made with Dr.Explain