Import GUI

The Import GUI is an add-on for:
  • Magento 2 Community Edition (CE)

  • Magento 2 Enterprise Edition (EE)

The Import GUI enables store operators and Magento backend users to:
  • Upload import files, e.g., in CSV format

  • Creating the .ok file and starting the import process

Use one of the following provided methods:
The CLI manually using the following command:
bin/magento pacemaker:import <ID>

Configure the GUI

When using the GUI with Magento 2 Enterprise Edition (EE), the configuration can be found under the Magento backend path Stores  Configuration  TechDivision  Pacemaker  Upload and should contain the displayed values.

Configuration in Magento Backend
Configuration in Magento Backend

GUI settings

  • Caching during the import is not very helpful, because the main impact on the performance will have the CRUD operations that can not be cached

  • In case the import is processed over a network e.g., in the cloud, it can be helpful to lower the time necessary to load the data from the DB

  • Additionally, the cache warming functionality will only work if the cache will get enabled

  • See the Pacemaker Community Edition

Option Default Description

Commandline

vendor/bin/pacemaker

Path to the Pacemaker executor, the default value is vendor/bin/pacemaker

The configuration value for Commandline should be set to the Pacemaker CLI that has to get used to create the .ok file that is necessary to start the import.

Working Directory

var/pacemaker/import

Path to the Pacemaker working directory

As a pipeline should get used to importing the files, the configuration value for Working Directory has to be the same as for the Pacemaker Enterprise Edition Working directory, but without the leading var/.

Enable CRON

No

Enable/disable the Magento CRON

  • The configuration for Enable CRON must not get set to Yes

  • In certain situations, the Magento default CRON will get used to start the import and transfer through the corresponding pipeline

Line Count System.log

1000

Number of displayed log lines for the system log

Upload files

The GUI offers the possibility of the settings for the import process to upload CSV files, e.g., the mode to use add-update.

Depending on the GUI configuration and the Pacemaker Enterprise Edition used, the uploaded files will be imported directly or by one of the pipelines.

  • In combination with Pacemaker Enterprise Edition and the configuration described above, the upload GUI can only get used to uploading files

  • It is not possible to configure the import itself since the import is taken over and executed by the pipeline configuration

  • The configuration has no effect

Upload GUI settings for import files

Upload GUI for import files
Upload GUI
Option Default Description

Entities

--Please Select--

Default Magento Entity Types

  • Advanced Pricing

  • Products

  • Customers and Addresses (single file)

  • Customers Main File

  • Customer Addresses

  • Using the Entities drop-down list, the entity type that matches the uploaded files must be selected

  • If the entity type does not match the file name, an error will be raised

  • If the entity Product is selected, the additional dropdown Import Mode will be displayed.

Operation

add-update

Defines the type of operation to perform for a data import

see Magento 2 Community Edition (CE) Shortcuts

  • validate

  • convert

  • add-update

  • replace

  • delete

Additional Parameters

Archive Artifacts

Check if you want to archive the import as artifact

Debug Mode

Check if you want more options for the import mode

  • If checked the additional dropdown Import Mode gets displayed with additional options

Import Mode

Default

The Default import mode imports all the data that is available in the file, even the data has changed since the last import or not.

Change-Set Detection

The import mode Change-Set Detection will compare the data (configurable change-sets) from the database with the one found in the import files and only updates the DB if the data has been changed.

It can improve performance massively in add-update mode, as invoking DB CRUD operations are very performance intensive.

  • The mode Change-Set Detection will be the default mode when importing data via default Pacemaker pipeline.

It should be considered well also to activate the cache warming functionality, because this can additionally have a significant impact on performance because all the data to be compared to, will be loaded during the bootstrap process in a very efficient manner.

Timestamp Detection

Single Transaction

Check if you want to run the import a single transaction

Cache Enabled

Check if you want to enable the cache for the import

Log Level

warning

Set the desired log level

The log file named system.log gets placed in the import artifacts or archived artifact directory, if the appropriate checkbox gets set

  • debug

  • info

  • notice

  • warning

  • error

  • critical

  • alert

  • emergency

File Upload

Dialog to upload a desired import file