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.

• 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.