Import excel to ActiveRecord models
using composer
composer require gevman/yii2-excel-importsupports array parameter with following attributes
filePath- full path to excel file to be importedactiveRecord- ActiveRecord class name where imported data should be savedscenario- ActiveRecord scenario, if leave empty no scenario will be setskipFirstRow- if true will skip excel's first row (eg. heading row), otherwise will try save first row alsofields[]- array of field definitions
attribute- attribute name from Your ActieRecord classvalue- if callable passed it will receive current row, and return value will be saved to AR, otherwise it will find element which key is passed value in current row
validates each populated AR model, and returns false if there's any error, otherwise it will return true
Saves populated AR models, and returns an array of each saved AR model's primary key if models is not validated yet, it will validate all models before save
Will return array of AR model errors indexed by row's index
Will return array of populated AR models
- Define Fields
$uploadedFile = \yii\web\UploadedFile::getInstanceByName('file');
$importer = new \Gevman\Yii2Excel\Importer([
'filePath' => $uploadedFile->tempName,
'activeRecord' => Product::class,
'scenario' => Product::SCENARIO_IMPORT,
'skipFirstRow' => true,
'fields' => [
[
'attribute' => 'keywords',
'value' => 1,
],
[
'attribute' => 'itemTitle',
'value' => 2,
],
[
'attribute' => 'marketplaceTitle',
'value' => 3,
],
[
'attribute' => 'brand',
'value' => function ($row) {
return strval($row[4]);
},
],
[
'attribute' => 'category',
'value' => function ($row) {
return strval($row[4]);
},
],
[
'attribute' => 'mpn',
'value' => function ($row) {
return strval($row[6]);
},
],
[
'attribute' => 'ean',
'value' => function ($row) {
return strval($row[7]);
},
],
[
'attribute' => 'targetPrice',
'value' => 8,
],
[
'attribute' => 'photos',
'value' => function ($row) {
$photos = [];
foreach (StringHelper::explode(strval($row[11]), ',', true, true) as $photo) {
if (filter_var($photo, FILTER_VALIDATE_URL)) {
$file = @file_get_contents($photo);
if ($file) {
$filename = md5($file) . '.jpg';
file_put_contents(Yii::getAlias("@webroot/gallery/$filename"), $file);
$photos[] = $filename;
}
} else {
$photos[] = $photo;
}
}
return implode(',', $photos);
}
],
[
'attribute' => 'currency',
'value' => 13,
],
],
]);- Validate, Save, and show errors
if (!$importer->validate()) {
foreach($importer->getErrors() as $rowNumber => $errors) {
echo "$rowNumber errors <br>" . implode('<br>', $errors);
}
} else {
$importer->save();
}of just
$importer->save();
foreach($importer->getErrors() as $rowNumber => $errors) {
echo "$rowNumber errors <br>" . implode('<br>', $errors);
}
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent