Africlock Manual
Menu

Import employees from EXCEL

Import employees from EXCEL
Allows you to create an Excel spreadsheet into which you can enter your initial employee data. The data can then be imported from the spreadsheet into the employee file.
 
11. Create empty EXCEL spreadsheet
Creates an empty Excel spreadsheet containing column headings which indicate what data is required. You will be asked to supply a name for the spreadsheet. When the spreadsheet has been created, enter the data into it. When you have finished, select the applicable employee group, company name and time programme from the three lists shown, decide whether buttons should be assigned automatically or not and click 'Import employees from Excel spreadsheet' to transfer the data into the clock system.
2

Allocate buttons

2. Allocate buttons
If unallocated buttons are available and you select 'Yes', buttons will be automatically assigned to as many employees as possible .
33. Import employees from EXCEL spreadsheet
This opens a window which allows you to select the file containing the employee data. Selecting the file will transfer the data into the system.
 
Employee names; Surname; Display name
Employee number; Bio clock number
Nationality; Country (if foreign)
ID number; Birth date; Date employed
Bank name; Bank branch name; Bank branch code
Bank account number; Bank account type
Gender; Race; Disability
Permanent/Temporary
Occupation; Division
Salaried/Clock worker
Pay frequency; Gross Pay
Fixed wage/Hourly
Hourly tariff
Tax number
Unit number; Complex; Street number; Street name/farm; Suburb
City/town; Postal code; Postal address type; Number
Postal agency; Post office; Postal code
Cell number; E-mail address; Leave type, Days of leave
Employee group; Company; Time programme
The online help was made with Dr.Explain