Add Data Import from CSV

[AliiiBenn]

Description

Companies often have employee data in spreadsheets. Importing from CSV would save significant data entry time.

Requirements

1. Import Employees from CSV:

   • Upload CSV file
   • Map columns to fields
   • Validate data before import
   • Show preview before confirming
   • Error report for failed rows

2. Import Templates:

   • Provide downloadable CSV templates
   • Document required columns

3. Duplicate Detection:

   • Check if employee already exists (by name?)
   • Offer to skip, update, or create new

CSV Fields to Support

At minimum:

• firstName, lastName
• email, phone
• positionId, workLocationId
• hireDate, contractType
• agency (for interim workers)

Acceptance Criteria

• Can upload CSV file
• Shows preview of data to import
• Validates required fields
• Shows errors for invalid rows
• Successfully imports valid data

Related

• Issue Add Bulk Operations (Create/Edit Multiple Employees) #101 (Bulk Operations) - bulk create is similar but this is specifically for CSV import