Developed with love by KnpLabs Hire us for your project!
35

ExcelInitBundle

by FriendsOfAkeneo

Setup your Akeneo PIM data with a single init.xls file

Excel Init Bundle

Build Status

alt text

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.

Requirements

ExcelInitBundle Akeneo PIM Community Edition

Installation

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 registerProjectBundles() method:

    $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

Documentation

Getting started

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

See doc folder for more details on how to set your catalog structure.

Supported file

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.

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.

Dev notes

Unit tests

You can launch the PHPSpec tests with the provided docker-compose.yml file:

docker-compose pull
docker-compose up -d
docker-compose exec fpm composer install --prefer-dist
docker-compose exec fpm ./bin/phpspec run
  • Merge pull request #68 from pchasle/patch-1
    By web-flow, 1 year ago
  • Revert PIM dependency to version >=3.0 <4.0
    By web-flow, 1 year ago
  • PIM 3.1.x dependency
    By jmleroux, 2 years ago
  • Pim 3.0 compatibility (#66)
    By web-flow, 2 years ago
  • Merge pull request #63 from akeneo/migration-2.3
    By web-flow, 2 years ago
  • Update README
    By mmetayer, 2 years ago
  • CI: Remove unneeded requirement
    By mmetayer, 2 years ago
  • Apply CI build on PIM's 2.3 branch
    By mmetayer, 2 years ago
  • Merge pull request #64 from akeneo/mmetayer-patch-1
    By web-flow, 2 years ago
  • Update Jenkinsfile
    By web-flow, 2 years ago
  • PIM 2.2 migration (#62)
    By jmleroux, 2 years ago
  • Update README.md (#51)
    By jmleroux, 3 years ago
  • Update Jenkinsfile (#60)
    By web-flow, 3 years ago
  • Updated akeneo version requirements (#61 from francescopis/master)
    By web-flow, 3 years ago
  • Update README.md
    By web-flow, 3 years ago
  • Merge branch 'master' into master
    By web-flow, 3 years ago
  • Updated readme
    By francescopis, 3 years ago
  • Update PIM dependency
    By web-flow, 3 years ago
  • Updated akeneo version requirements
    By francescopis, 3 years ago
  • Update Jenkinsfile
    By web-flow, 3 years ago
  • Merge branch '1.2' into master
    By jmleroux, 3 years ago
  • Add categories import step (#57)
    By web-flow, 3 years ago
  • Add categories step to import job (#56)
    By web-flow, 3 years ago
  • Init CI V2 (#54)
    By web-flow, 3 years ago
  • Fix install fixtures (#55)
    By web-flow, 3 years ago
  • Merge pull request #52 from sebglon/master
    By web-flow, 3 years ago
  • add Jenkinsfile for CI V2
    By sebglon, 3 years ago
  • Update CHANGELOG
    By fitn, 3 years ago
  • Merge pull request #50 from akeneo/EX-28
    By web-flow, 3 years ago
  • EX-28: Fix category reader
    By fitn, 3 years ago