@extends('layouts.user') @section('title', 'Employee Import Settings') @section('content') @if(session('success'))

{{ session('success') }}

@endif @if(session('error'))

{{ session('error') }}

@endif

Employee Import Settings

Import employees from CSV or Excel files with custom column mapping

Back to Employees

Step 1: Upload File

Select your CSV or Excel file

@csrf
@error('csv_file')

{{ $message }}

@enderror

Supported: CSV, XLSX, XLS (Max: 10MB)

Or
Download Sample Template

Import Instructions

Follow these steps

How to Import:

  1. 1 Download the sample template or prepare your CSV/Excel file
  2. 2 Fill in employee data according to the column headers
  3. 3 Upload your file using the form on the left
  4. 4 Map your CSV columns to database fields
  5. 5 Review the preview and confirm import

Important Notes:

Required: Employee ID, First Name, Email, Phone, Gender
Unique: Employee ID and Email must be unique
Dates: Use YYYY-MM-DD format (e.g., 2024-01-15)

Available Database Columns

All fields you can import

Below are all available columns in the employee database. You can map your CSV columns to any of these fields during import.

@php $groupedColumns = collect($employeeColumns)->groupBy('category'); @endphp
@foreach($groupedColumns as $category => $columns)

{{ $category }}

@foreach($columns as $column)

{{ $column['label'] }}

{{ $column['name'] }} @if(isset($column['note']))

{{ $column['note'] }}

@endif
@if($column['required']) Required @else Optional @endif
@endforeach
@endforeach
@endsection