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.
- Process Result:
- Rows with incorrect formatting or missing mandatory information will not be processed.
- When the process is complete, an information window containing the process result and summary will open.
- 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.