Usman Ahmed Laravel Import Export

A PHP 8.3+ / Laravel 12 package with one metadata-driven DataDefinition for imports, exports and spreadsheet templates. Existing chunked imports, exports and template writers are retained.

use UsmanAhmed\ImportExport\Fields\RelationField;

RelationField::make('school')->column('school_id')
    ->excelColumn('School')->exportColumn('School Name')
    ->belongsTo('school', School::class)
    ->importBy('code')->storeUsing('id')->exportUsing('name')
    ->templateUsing('code')->codeAndLabel('name')->dropdown()
    ->required()->exportable();

Register your definition in config/bulk-imports.php, then:

use UsmanAhmed\ImportExport\{ImportManager, ExportManager, TemplateManager};

$template = app(TemplateManager::class)->download('students', $request->user());
$import = app(ImportManager::class)->dispatch('students', $request->file('file'), $request->user());
$export = app(ExportManager::class)->dispatch('students', $request->user(), [
    'format' => 'xlsx', 'fields' => ['student_code', 'name', 'school'],
]);
$updateFile = app(TemplateManager::class)->withData('students', $request->user());

Imports stream into checksummed JSONL chunks and Laravel Bus batches; business writes, receipt and counters commit together. Exports use durable keyset pages, immutable parts and revision fencing. CSV/XLSX processing is bounded by configured chunks; large XLSX exports split sheets automatically. Templates include instructions and bounded option/relation dropdowns. Definitions whitelist fields, aliases, options, validation, normalization and relations.

Backend access defaults to the creator. Guest access is explicitly enabled per package and definition, using expiring, revocable 256-bit bearer tokens stored as hashes. Tenancy is optional. SystemPrincipal supports scheduled/CLI jobs with a stable owner. Optional notifications resolve the stored creator or a verified guest/server recipient. Notification delivery or broker failures do not change a successful import/export into a failure.

Start with installation, quick start, and the complete StudentDefinition. Product and Employee definitions demonstrate reuse. The documentation index covers access, relationships, queues and deployment.

composer install
composer test
composer analyse
composer format:check
composer validate --strict

The pre-rename release verification baseline is summarized in verification, and measured benchmark evidence is retained in performance. Native MySQL/PostgreSQL, Redis/Horizon and S3 deployment still need host-specific validation. Generic pivot/child-sheet synchronization and generic million-row atomic publication remain outside scope. See limitations.

Proprietary license

Copyright © 2026 Usman Ahmed. All Rights Reserved.

This package is proprietary software owned by Usman Ahmed. Use is permitted only under a valid written or commercial license from Usman Ahmed and within that license's scope. Redistribution, sublicensing, public source disclosure, resale, or relicensing requires prior written permission from Usman Ahmed. Authorized integration into client applications does not grant permission to redistribute or sell this package separately.

See LICENSE.md for the full terms. Third-party dependencies retain their respective licenses; their terms are not replaced by this package's proprietary license.