Task 16: Employee Bulk Import

Test Cases

ID	Scenario	Expected Result	Status
T16-01	Admin/HR uploads valid employee CSV	Import succeeds with success count and no failed rows
T16-02	Admin/HR uploads valid employee XLSX	Import succeeds with success count and no failed rows
T16-03	Missing required import columns	Returns 422 with missing column message
T16-04	Duplicate employee_number/work_email in file	Duplicate rows are rejected and listed in error report
T16-05	Existing employee_number/work_email already in DB	Row is rejected and listed in error report
T16-06	Unknown entity/department/role name	Row is rejected with mapping validation error
T16-07	HR imports row with role Admin	Row is rejected
T16-08	Partial import (some pass, some fail)	Valid rows are created; failed rows appear in downloadable CSV report
T16-09	Download error report URL returned by import API	CSV report downloads successfully

Demo Walkthrough

1. Download sample CSV from the Import dialog
2. Prepare a CSV with 5 valid rows and 2 invalid rows (duplicate email, bad entity)
3. Upload the file → Show success summary: 5 imported, 2 failed
4. Download error report → Show specific error for each failed row
5. Verify imported employees appear in the employee list
6. Try uploading as Employee role → Show 403