The system supports bulk importation of employee attendance from a CSV file, this is provides a way to integrate the data provided by external time management systems such as magnetic cards or contactless cards where employees touch / swipe in and touch / swipe out as the leave the company premises. The system can process up to 1,000 individual attendance records at a time and such data is automatically validated and integrated into the system.
From this screen, you will be able to import attendance records using the provided CSV file. Follow the steps below to import attendance records
- Navigate to the import attendance screen by clicking Time > Attendance > Import Records
- Download the sample import file if you don’t already have it by clicking the link under the “Upload Steps” section. Note: If you have data extracted from a magnetic card reader or biometric device, you should download the “import file generator” instead. Once the file opens in Excel you must enable macros for it to work properly.
- Fill in the fields using the field description below
- FullName: This is the full name of the employee namely, first, middle and last name. This field is compulsory
- PunchInDate: This is the attendance start date. This field is compulsory
- PunchInTime: This is the attendance start time. This field is compulsory
- PunchInNote: Any related notes to the punch in event
- PunchOutDate: This is the attendance end date. This field is compulsory
- PunchOutTime: This is the attendance end time. This field is compulsory
- PunchOutNote: Any related notes to the punch out event
- Save the file to a location of your choice
- From the Import attendance screen, click the “browse” button
- Select the save file from the chosen location
- Click the “upload” button