Skip to content
Documentation
Admin Operations
Data Transfers
Entries-Exit Records

Bulk Entry-Exit Records

The Bulk Entry/Exit Entry screen is a convenient tool that allows you to record Entry/Exit movements for multiple employees simultaneously using Excel. This saves time and speeds up the data entry process.

Steps for Bulk Entry/Exit Records

Follow the steps below to perform Bulk Entry/Exit records.

  • Download Blank Entry/Exit Record Template:
    • Go to the Data Transfers > Entry/Exit Movements page.
    • Click the Download Blank Entry/Exit Template File button.
    • The Excel file will be downloaded to your computer.
  • Fill in Entry/Exit Information:
    • Open the downloaded Excel file.
    • Starting from the first empty row, enter the data for each employee to be recorded for Entry/Exit, considering the following warnings.
      • Entry/Exit Information must be filled according to the column headers in the template.
      • All fields are mandatory. They must be filled completely.
      • Employee Code must match the system records.
        • Employee Codes and information will be found on the "Employee List" sheet in the template Excel file. You can copy the Employee Codes from here.
      • For Location No, enter the relevant numbers indicated on the "Location No" sheet in Excel.
      • For Device No, enter the relevant numbers indicated on the "Device No" sheet in Excel.
      • For the Entry Direction field:
        • "1" for Entry
        • "0" for Exit
      • Entry/Exit Date should be in the format "Day.Month.Year". Example: 01.04.2024
      • Entry/Exit Time should be in the format "Hour:Minute". Example: "09:00", "18:00"
    • Save the Excel file after filling in the entry/exit data.
⚠️
Device No must match the associated Location No.
  • Start Bulk Registration Process:
    • Return to the Bulk Entry/Exit Records page.
    • Click the Select File field.
    • Select the filled Excel file and click the Open button.
    • Click the Upload Filled Entry/Exit Template File button.
    • Click the Start Bulk Entry/Exit Transfer button.
  • Check Process Result:
    • When the process is complete, an information window containing the process result and summary will open.
      • Process Result:
        • If all rows are recorded, it will say "Successful".
        • If there are erroneous rows, it will give a "Error!" warning.
          • Error-free records will be saved. No further action is required.
      • Bulk Process Summary:
        • Total Rows: Total number of rows uploaded in the template.
        • Successful Transactions: Number of rows successfully recorded.
        • Erroneous Transactions: Number of erroneous rows not recorded.
    • Rows with incorrect formatting or missing mandatory information will not be processed.
  • Correct Erroneous Rows:
    • If there are erroneous rows, they will be returned as an Excel file.
    • Click the Download Excel File button to download and open the file containing only the erroneous rows.
    • The reason for the error will be written at the end of each row.
    • Correct the errors and save the Excel file.
    • Start the Bulk Registration Process for the saved file.
The note "Bulk Transfer Entry/Exit" will be shown for Entry/Exit records added by bulk transfer on the relevant screens.
💡
You can check the successfully recorded Entry/Exit records on the Attendance Transactions > Attendances screen.