Africlock Manual
Menu

Export clock movements

Export clock movements
11. Comma-delimited file
This writes clock movements into a file that can be opened by Excel or any other program that recognizes the CSV format. It is also useful if you need to export data from this system to another Africlock system, on which you would select 'Import data: Clock movements: Comma-delimited file'.
22. Excel file
This option (which requires you to have Excel installed on the same computer as your clocking system) will create an export file in Excel format.
 

Export file format (CSV, Excel) (clock movements)

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 clock movement
Time in - Time of clock movement
Status - unconverted, converted or ignored
Repeats - amount of repeated clock movements
Clock name - on which clock did the employee clock
33. Pairs per day (CSV)
Create a CSV file showing the clock movements in pairs.

Export file format (pair - CSV)

 
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 clock movement
Time of clock movement (in)
Time of clock movement (out)
The online help was made with Dr.Explain