Upload Different File

@csrf

Column Mapping

Match each file column to the corresponding database field

@foreach($headers as $index => $header)

Column {{ $index + 1 }}: {{ $header }}

@endforeach

@foreach(['email', 'first_name', 'last_name', 'org_name', 'profile_url', 'type', 'valid'] as $field) @endforeach

Default Values

Used when values are not provided in the file

Default Type

Default Validity

Duplicate Handling

What to do when an email already exists

Skip duplicates

Keep existing records unchanged

Update duplicates

Overwrite existing records with new data

Data Preview

First 5 rows from your file

@foreach($headers as $header) @endforeach @foreach($preview as $row) @foreach($row as $cell) @endforeach @endforeach

{{ $header }}
{{ $cell }}

Cancel

@php // Helper function to guess field based on header name function guessField($header) { $header = strtolower(trim($header)); $mappings = [ 'email' => ['email', 'e-mail', 'email_address', 'emailaddress'], 'first_name' => ['first_name', 'firstname', 'first', 'fname'], 'last_name' => ['last_name', 'lastname', 'last', 'lname', 'surname'], 'org_name' => ['org_name', 'organization', 'org', 'company', 'organisation', 'org_name'], 'profile_url' => ['profile_url', 'url', 'website', 'profile', 'org_url'], 'type' => ['type', 'category', 'segment'], 'valid' => ['valid', 'is_valid', 'verified', 'status'], ]; foreach ($mappings as $field => $keywords) { foreach ($keywords as $keyword) { if (str_contains($header, $keyword)) { return $field; } } } return ''; } $this = new class { public function guessField($h) { return guessField($h); } }; @endphp