@extends('admin.layouts.app') @section('title', 'Import External Jobs') @section('content')
Total Jobs
{{ $stats['total_jobs'] }}
External Jobs
{{ $stats['external_jobs'] }}
Last Import
{{ $stats['last_import'] ?? 'Never' }}

Bulk Import External Jobs

Upload Excel or CSV file to add external job postings (apply externally via URL).

Step 1: Download Template

Choose your preferred format:

Recommended: Excel template includes instructions, descriptions, and formatting.

How to Import:

  1. Download the Excel or CSV template above
  2. Fill in job details (use sample rows as a guide)
  3. Ensure external_application_url is filled for each job
  4. Save and upload the file below
  5. Review the import summary

Template includes {{ count($columns) }} fields:

{{ implode(', ', $columns) }}

@csrf

Step 2: Upload File

@if ($errors->any())

Import failed:

    @foreach ($errors->all() as $error)
  • {{ $error }}
  • @endforeach
@endif @if(session('status'))
{{ session('status') }}
@endif

Accepted formats: .xlsx, .xls, .csv (Max size: 10MB)

@error('file')

{{ $message }}

@enderror
← Back to Jobs

What happens during import?

  • File validated for correct format and required fields
  • Employers automatically created if they don't exist
  • Jobs created with "Apply Externally" enabled
  • External application URLs configured for each job
@endsection