@extends('components.app-layout') @section('title', 'Bulk Import Members') @php $dynamicSubtitle = 'Import multiple members to ' . (isset($organizationSettings) ? $organizationSettings['name'] : 'Presbyterian Church of Ghana'); @endphp @section('subtitle', $dynamicSubtitle) @section('content')

Bulk Import Members

Import multiple church members at once using an Excel file. Streamline your member registration process.

Multiple Members
Time Saving
Validated Data
@if(session('success'))

Import Successful!

{{ session('success') }}

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

Import Failed

{{ session('error') }}

@endif @if(session('import_results')) @php $results = session('import_results'); @endphp

Import Results

{{ $results['success'] }}
Members Imported
{{ $results['errors'] }}
Errors Encountered
@if(!empty($results['error_details']))

Error Details:

@foreach($results['error_details'] as $error)
Row {{ $error['row'] }}:
    @foreach($error['errors'] as $errorMsg)
  • • {{ $errorMsg }}
  • @endforeach
@endforeach
@endif
@endif

Upload Excel File

Select your member data file to import

@csrf
@error('excel_file')

{{ $message }}

@enderror

Important Notes:

  • • Maximum file size: 10MB
  • • Supported formats: Excel (.xlsx, .xls) and CSV (.csv)
  • • Default password for imported members: "password123"
  • • Members with existing phone numbers will be skipped
  • • Email is optional but must be valid if provided

Step-by-Step Guide

Follow these steps for successful import

1

Download Template

Use our pre-formatted Excel template to ensure proper data structure

Click the button below to download
2

Fill Member Data

Enter member information following the template format exactly

Required: First Name, Last Name, Phone, Gender
3

Upload & Import

Upload your completed file and review the import results

Drag & drop or click to select file

Required Fields

First Name
Last Name
Phone Number
Gender

Optional Fields

• Middle Name • Email Address • Date of Birth
• Home Address • Occupation • Marital Status
• Emergency Contact • Ministry Preferences • Special Notes
Back to Members
@endsection