Attendance Import

Attendance Import is use 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.

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

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 Format 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



The column IOMODE (time definitionis optional (See What is In Out Mode?) if omitted, it is default 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 are 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 definitionis optional (See What is In Out Mode?) if omitted, it is default to 99 (First In, Last Out)
    Or you can add a GeneralExcelSingleDateTimeIOMode key in HRPro.configHRPro.config Settings)
    Field Mapping

    Format 3 -  Excel General (Multiple Times Format) 
    Separate columns for Work In, Work out etc.

    Sample Excel File: GeneralExcelAttendanceFormat.xlsx 
    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)





    See also: