akeneo/excel-connector-bundle

This package is abandoned and no longer maintained. The author suggests using the akeneo-labs/excel-connector-bundle package instead.

Akeneo PIM Excel connector bundle

Installs: 3 195

Dependents: 0

Stars: 15

Watchers: 27

Forks: 7

Open Issues: 3

Type: symfony-bundle

v1.5.2 2015-11-19 15:19 UTC

README

This bundle adds support of Excel XSLX files as a source for initializing catalog structure and import/export of products for Akeneo PIM.

Scrutinizer Quality Score

Requirements

ExcelConnectorBundle Akeneo PIM Community Edition
v1.5.* v1.4.*
v1.4.* v1.3.*
v1.3.* v1.2.*
v1.1.*, v1.2.* v1.1.*
v1.0.* v1.0.*

Installation

From your application root:

$ php composer.phar require --prefer-dist akeneo-labs/excel-connector-bundle:1.5.*

If you want to use the development version (only for test purpose, do not use it in production), replace "1.5.*" by "dev-master" in the previous command.

Register the bundle by adding the following lines:

/* app/AppKernel.php */

// ...
protected function getPimDependenciesBundles()
{
    return [
        // ...
        new Akeneo\Bundle\SpreadsheetParserBundle\AkeneoSpreadsheetParserBundle(),
        new Pim\Bundle\ExcelConnectorBundle\PimExcelConnectorBundle()
    ];
}

Then clean the cache and reinstall the assets:

php app/console cache:clear --env=prod

php app/console pim:install:assets --env=prod

Documentation

See Resources/doc folder for more details on how to set your catalog structure using the init.xslx file.

Supported file

Input file must follow init.xslx structure. Note that the file must be opened with Excel. LibreOffice/OpenOffice are not in compliance with validations data that are available in the spreadsheet.

Importation job

This bundle allows you to import products files directly in the UI through Import > Import jobs. Please note that the init.xlsx import is also available via the UI. However, it should not be used as an import system for entities available within this file (families, categories, etc.) once the catalog structure has been set.

Dependencies

This bundles uses phpoffice/phpexcel and akeneo-labs/spreadsheet-parser-bundle.