How to Use the Employee Batch Update (Excel Export and Import) Functionality

In the below illustration, employees email address will be updated using the batch update functionality.

  • 1. Go to Employee and choose Employee list

  • 2. On the toolbar Go to Batch Update

  • 3. Click Export

  • 4. Select Export field (in this e.g “Email”)

  • 5. Click Export

  • Wait until the export is created.

  • After the export is created, an excel file containing the employee’s information is saved to your Downloads folder
  • 6. Go to the folder Downloads and open the excel file and update the missing email address.

  • 7. Save the duly filled excel file.

  • 8. To import the updated, excel file to Sicorax HRMS, Go to Employee and choose Employee list

  • 9. On the toolbar Go to Batch Update

  • 10. click Import

  • 11. Click the arrow to browse the Downloads folder, select the excel file and click open

  • Wait until the import is completed.

  • 12. After the import is completed, go to Employee, Employee list to verify the updated email.


Views
Personal Tools