@extends('layouts.app') @section('title', 'Import Attendance') @section('content')

Import Attendance

Import attendance data from CSV or Excel files

@csrf
@error('file')

{{ $message }}

@enderror

Import Instructions

  • Supported formats: CSV, XLSX, XLS
  • Maximum file size: 10MB
  • CSV format should have columns: email, date, punch_in_time, punch_out_time, notes
  • Date format: YYYY-MM-DD (e.g., 2024-01-15)
  • Time format: HH:MM:SS or HH:MM (e.g., 09:00:00 or 09:00)
  • Users must exist in the system (matched by email)

Sample CSV Format

email,date,punch_in_time,punch_out_time,notes
john@example.com,2024-01-15,09:00:00,17:30:00,Regular day
jane@example.com,2024-01-15,08:45:00,17:15:00,Early arrival
bob@example.com,2024-01-15,09:15:00,17:45:00,Late arrival
@if(session('success'))

Import Successful

{{ session('success') }}

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

Import Error

{{ session('error') }}

@endif @if(session('errors') && count(session('errors')) > 0)

Import Warnings

    @foreach(session('errors') as $error)
  • {{ $error }}
  • @endforeach
@endif
@endsection