Excel Init Bundle
This bundle adds support of Excel XSLX files as a source for initializing catalog structure for Akeneo PIM.
This extension replaces the ExcelConnectorBundle for Akeneo PIM >= 1.6.
Be carefull to use the new
init.xlsx file of this bundle as there are some structure modifications.
Note: this bundle is not compatible with Excel 2003 xls files. Editing the XLSX file with LibreOffice/OpenOffice is also not supported as it can lead to unwanted behavior.
|ExcelInitBundle||Akeneo PIM Community Edition|
|v2.1.*||>= v2.2 - < 3.0|
|v2.0.*||v2.0 - v2.1|
From your application root:
php composer.phar require --prefer-dist akeneo/excel-init-bundle:3.0
Enable the bundle in the
app/AppKernel.php file in the
$bundles = [ // ... new Pim\Bundle\ExcelInitBundle\PimExcelInitBundle(), ]
Now let's clean your cache and dump your assets:
php bin/console cache:warmup --env=prod php bin/console pim:installer:assets --env=prod
See doc folder for more details on how to set your catalog structure.
Input file must follow init.xslx structure.
Note that the file should be opened with Excel. LibreOffice/OpenOffice are not fully in compliance with validations data that are available in the spreadsheet.
The import fails when importing families
Check that your channels names are correct in both family and channel tabs. You might have a typo in the channels tab and not in the family tab. You will have to remove the mispelled channel once you corrected this.
You can launch the PHPSpec tests with the provided
docker-compose pull docker-compose up -d docker-compose exec fpm composer install --prefer-dist docker-compose exec fpm ./bin/phpspec run