Skip to content
PHP 8.1+ Open source Developer documentation
Tools Packagist
Docs v2.0.6
Documentation versions v2.0.6Current v2.0.5Maintenance v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
MNB PHPExcelDeveloper Guide
AI

Database library

Domain Import Presets

Use built-in schemas for common datasets, then override aliases, mappings, defaults, rules, normalizers, and duplicate keys.

Level
Intermediate
Reading time
9 min
Package
mnb/mnb-phpexcel-database
Updated
DomainImporter::create()importProducts()importUsers()DomainImportRegistry::register()

Use a built-in convenience method#

PHP
$importer = DomainImporter::create();

$result = $importer->importProducts(
    'products.xlsx',
    $pdo,
    'products',
    [
        'batch_size' => 1000,
        'duplicate_strategy' => 'update',
        'unique_by' => ['sku'],
        'failed_rows_csv' => __DIR__ . '/storage/failed-products.csv',
    ]
);

Available built-in domains#

DomainConvenience method
UsersimportUsers()
ProductsimportProducts()
OrdersimportOrders()
InventoryimportInventory()
Students / Attendance / MarksimportStudents(), importAttendance(), importMarks()
Contacts / LocationsimportContacts(), importLocations()
Blog posts / Media / CategoriesimportBlogPosts(), importMedia(), importCategories()

Inspect or extend the registry#

PHP
$registry = DomainImportRegistry::withBuiltIns();
print_r($registry->names());

$registry->register($customPreset);
$importer = DomainImporter::create($registry);