Bulk User Upload

Purpose - Ingest a list of employees, students, or school users at once from Excel or CSV.

Who Can Use It

• DHE Admin (bulk schools and bulk users).
• School Admin (bulk employees and bulk students, scoped to their school).

Key Capabilities

• Accept .xlsx or .csv file uploads.
• Auto-detect user type from the request ( employee , student , or school).
• Pre-validate every row and return a downloadable text file listing errors when validation fails.
• On success, create user accounts, assign roles, and return the same file with a newly-added user ID column so the caller can round-trip the identifiers.
• Employee bulk upload attaches records to the given school user ID.

Rules & Restrictions

• The uploader must be login.
• Uploads with any validation error are rejected as a whole; the errors file is returned instead of a partial success.
• Employee and Student rows must have unique email and unique phone within their scope; duplicates across the same scope are rejected.
• Row order in the returned file matches the input file for traceability.