Attendance Import

Attendance Import is under Attendance.

The purpose of Attendance Import is to import the attendance record generated from the attendance device (including Finger Scan, Smart Card, Proximity, Bar-code Strip, Magnetic Strip or Computer Data Input) into HRPro.

The Attendance Import Formats are based on the different Import Files given by different Attendance Devices. Attendance File Format is defined at Attendance Module Setup, you can define up to 3 attendance import formats. 

The check box Delete existing Period Attendance Records in the database before import and the drop-down list Period to Import are visible only when the option Ignored Import Period Checking in Attendance Module Setup is not checked. 

Make sure the check-box option Enable Attendance Record in Employee Master, HR Info Tab is ticked for those employees that are required to record the attendance. 

Please note that when rerun attendance import, the system will not update the in/out time if the in/out time is not equal to the card in/out time. 

i.e. if the in/out time is amended, it is protected and attendance import only updates the card in/out time. 

To delete the imported Attendance Records by period, use the  Delete existing Period Attendance Records button in Attendance Update

There are 4 general purpose Attendance Formats that based on Excel File.

Format 1 - Excel General (Single Date Time Format)

This format required that the Date and Time information are stored in one column and in Excel's Date Format

Sample Excel File: GeneralExcelSingleDateTimeAttendanceFormat.xlsx⇩ 

The column IOMODE (time definition) is optional (See What is In Out Mode?) if omitted, it defaults to 99 (First In, Last Out).

Or you can add a GeneralExcelSingleDateTimeIOMode key in HRPro.config)

Field Mapping

Format 2 - Excel General (Date and Time Format)

This format required that the Date and Time information is stored in two separate columns and the Date Column in Excel's Date Format and the Time Column are in MM:SS format 

Sample Excel File: ExcelGeneralDateAndTimeFormat.xlsx⇩

The column IOMODE (time definition) is optional (See What is In Out Mode?) if omitted, it defaults to 99 (First In, Last Out)

Or you can add a GeneralExcelSingleDateTimeIOMode key in HRPro.config)

Field Mapping

Format 3 -  Excel General (Multiple Times Format) 

Separate columns for Work In, Work out etc.

Format 43 -  Excel (Timesheet without Time Clock Info)

Like Format 3, the Attendance Import File Format 43. Excel (Timesheet without Time Clock Info) can support a lot of Excel formats, here is one of the examples, (Sample Excel File TimeSheet.xlsx⇩)

The OT (hrs) will distribute to OT Hours (Workday), OT Hours (Rest day), OT Hours (Saturday/Off), OT Hours (SH), OT Hours (PH -SH)  in Attendance Record automatically according to Roster Table/Global Working Hrs/Holiday Table Settings.

Format 57-  Excel General [Multiple DateTimes Format]

This format required that the Date and Time information is stored in one column and in Excel's Date Format and Separate columns for Work In, Work out etc.

p.s. Format 1, 2, 43, and 57 are not applicable to Desktop Client.