Install the Excel Connector Bundle

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

The Excel Connector Bundle contains utility classes to create Excel connectors. It also provides a method to initiate the PIM with a single Excel file. Remember to do a full backup of your folders/files and database before proceeding.

  • Set the memory_limit variable in your installdir/php/etc/php.ini file to 1000M. To know the total memory available, execute the command free -h. Modify the memory_limit value using the terminal:

      $ sudo nano installdir/php/etc/php.ini

    Edit the memory_limit value. It’s recommended that you restore the default value after you install the Magento Connector Bundle.

      memory_limit = 1000M
  • Go to the directory where Akeneo files are located and use Composer to install the Magento Connector Bundle.

      $ cd installdir
      $ cd apps/akeneo/htdocs
      $ php composer.phar require --prefer-dist akeneo/excel-init-bundle:2.0.*
  • When the installation finishes, enable bundles in the app/AppKernel.php file, in the registerProjectBundles() method. Add this lines in the file just after your app bundles should be registered here:

      new Pim\Bundle\ExcelInitBundle\PimExcelInitBundle(),
  • Clear the cache to avoid problems by running these commands:

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

It is very important to apply read, write, and execute permissions (recursive) to the cache folder after clearing the cache if you are running it with root privileges.

$ sudo chmod -R 775 var/cache
  • Update the following permissions/ownership:

      $ sudo chmod -R 775 var/cache var/logs
      $ sudo chown -R bitnami:daemon vendor var/cache var/logs

Continue the installation according to the Akeneo official documentation.

Last modification April 8, 2020