akeneo/excel-init-bundle

Akeneo PIM Excel initialization bundle

Excel Init Bundle

, _(*1)

, _(*2)

This bundle adds support of Excel XSLX files as a source for initializing catalog structure for Akeneo PIM., _(*3)

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., _(*4)

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., _(*5)

Requirements

Installation

From your application root:, _(*6)

    php composer.phar require --prefer-dist akeneo/excel-init-bundle:3.0

Enable the bundle in the app/AppKernel.php file in the registerProjectBundles() method:, _(*7)

    $bundles = [
        // ...
        new Pim\Bundle\ExcelInitBundle\PimExcelInitBundle(),
    ]

Now let's clean your cache and dump your assets:, _(*8)

    php bin/console cache:warmup --env=prod
    php bin/console pim:installer:assets --env=prod

Documentation

Getting started

See doc/Getting started for more details on how to set your catalog structure using the init.xslx file., _(*9)

See doc folder for more details on how to set your catalog structure., _(*10)

Supported file

Input file must follow init.xslx structure., _(*11)

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., _(*12)

Troubleshooting

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., _(*13)

Dev notes

Unit tests

You can launch the PHPSpec tests with the provided docker-compose.yml file:, _(*14)

docker-compose pull
docker-compose up -d
docker-compose exec fpm composer install --prefer-dist
docker-compose exec fpm ./bin/phpspec run