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 File given by different Attendance Devices. Attendance File Format is defined at Attendance Module Setup, you can define up to 2 attendance import formats.
The check box Delete existing Period Attendance Records in database before import is visible only when the option Ignored Import Period Checking in Attendance Module Setup is not checked.
When Attendance Import File is not given and the Delete existing Period Attendance Records in database before import is checked. All the attendance records of the given period will be deleted from the system.
Please note that when rerun attendance import, system will not update the in/out time if the in/out time not equal to card in/out time.
i.e. if the in/out time is amended, it is protected and attendance import only update the card in/out time.
There are 4 general purpose Attendance Formats that based on Excel File can be used.
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.
Format 2 - Excel General (Date and Time Format)
This format required that the Date and Time information are stored in two separate columns and the Date Column in Excel's Date Format and the Time Column are in MM:SS format
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 format, here is one of the example, (Sample Excel File TimeSheet.xlsx⇩)
The OT (hrs) will distribute to OT Workday (hrs), OT Restday (hrs), OT Saturday (hrs), OT SH (hrs), OT PH -SH(hrs) 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 are 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, 57 is not applicable to Desktop Client.