Installation
As of version To avoid complex adjustments of the configuration, version |
Depending on the requirements, different installation options are available.
Install as Composer Project
To install the package as a new project, assuming the composer is available, open a console and enter
composer create-project techdivision/import-cli-simple --no-dev
It will clone the repository from the internal Gitlab and install Pacemaker Community Edition (CE), that’s all.
Install as Composer Library
The second option, and in most Magento 2 projects the preferred way, will be the installation as a Composer library. For example, if you want to deliver it with your Magento 2 project, please add
{
"require": {
"techdivision/import-cli-simple" : "3.8.x"
}
}
to your Magento 2 composer.json
file. Then run
composer update
from your Magento 2 root directory, and you’re all set up.
Use as PHAR
The last, but for sure not the worst installation option, is to download the latest PHAR from our Github release page and make it executable, e.g. with wget
wget https://github.com/techdivision/import-cli-simple/releases/download/3.8.12/import-cli-simple.phar \
&& sudo chmod +x import-cli-simple.phar
To install the PHAR in your actual Magento 2 installation, move it to <MAGENTO-ROOT>/bin/import-cli-simple.phar
or, to install it globally, to /usr/bin/import-cli-simple.phar
. Now you ready to use it.
Add Missing Indexes
As the Pacemaker Community Edition (CE) functionality differs from the Magento 2 standard, for performance reasons, it is necessary to add some essential indexes manually. To do that, open a MySQL command line, connect to your MySQL server instance and enter the following SQL statement
ALTER TABLE `eav_attribute_option_value` ADD INDEX `EAV_ATTRIBUTE_OPTION_VALUE_VALUE` (`value` ASC); \
ALTER TABLE `catalog_product_entity_int` ADD INDEX `CATALOG_PRODUCT_ENTITY_INT_VALUE` (`value` ASC); \
ALTER TABLE `catalog_product_entity_varchar` ADD INDEX `CATALOG_PRODUCT_ENTITY_VARCHAR_VALUE` (`value` ASC); \
ALTER TABLE `catalog_product_entity_decimal` ADD INDEX `CATALOG_PRODUCT_ENTITY_DECIMAL_VALUE` (`value` ASC); \
ALTER TABLE `catalog_product_entity_datetime` ADD INDEX `CATALOG_PRODUCT_ENTITY_DATETIME_VALUE` (`value` ASC); \
ALTER TABLE `url_rewrite` ADD INDEX `URL_REWRITE_ENTITY_ID` (`entity_id` ASC); \
ALTER TABLE `url_rewrite` ADD INDEX `URL_REWRIRE_ENTITY_TYPE_ENTITY_ID` (`entity_id` ASC, `entity_type` ASC); \
ALTER TABLE `catalog_product_entity_media_gallery` ADD INDEX `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE` (`value`);
When using the Magic 360 component, additional the following indexes need to be added