ETIM-Mapper 6.10.0 User Manual

File/Import

Excel template-based classification import – in practice, classification is performed most often on the basis of the existing files containing the list of products, such as pricelists. Except prices, these files usually contain values of some basic parameters that must be assigned to the appropriate parameters required by the ETIM standard. To start the classification work, such list of products should be transformed into Excel template (see below) and imported to the classification software. For example, if you know in advance the ETIM description of your products, you can generate the import templates (Excel files) for the corresponding ETIM class or classes. ETIM templates contain the structure of the ETIM classes with all required features and values to be used within this class. In this way, the whole ETIM classification can be prepared in Excel templates and then the template files filled with the product data can be imported into the classification software. It is the easiest and recommended way, under the condition that you know in advance the ETIM description of your products. In the same way it is possible to generate BMEcat template (Excel file) for product information, such as: general, ordering, packaging, pricing, MIME information and ETIM class codes. In similar way, the usage of the ETIM-Mapper template allows to import all product data used internally in ETIM-Mapper application, such as labels and additional technical description. All incorrect information is omitted during the import process, for example: values with incorrect header names, incorrect codes of ETIM classes, features or values, incorrect types of values, etc. To see how to generate Excel template files, go to the next section.

BMEcat file import – if you have previously classified product information in the BMEcat format (supported files in BMEcat version 1.2 and 2005), it is possible to import the whole classification automatically.

The following options are available for the import of products existing already in the database (duplicate handling):

Please note for the "merge" option (in the case of existing product):

In order to speed up data transfer and to avoid problems with uploading large files (over 128MB) it is recommended to import compressed (zipped) files.

File/Templates

With the ETIM-Mapper templates it is possible to prepare or manage all the product information in an Excel files and import it automatically into the application. The information in all templates should be structured in columns. The first column should contain the product’s IDs: in the first row there should be the text "ID" and other rows should contain a unique identifier for each product (for ex. the catalogue number, reference number, GTIN, etc.). Other columns should contain the most accurate description of the product, depending on the template type and its particular tab.

There are three types of templates:

BMEcat data template – it is a template for structured BMEcat information (general, ordering, packaging, pricing, MIME and ETIM class information). There is only one BMEcat template file for all products, because the structure of the information included in this template is common for any products, regardless on ETIM classification.

ETIM data templates – to facilitate the preparation of structured product information it is possible to take advantage of the Excel templates files for any ETIM class (EC) or group of classes (EG). Template files contain a separate Excel sheet for each ETIM class with a two-rows header. The second row of the header contains a list of all features (EF) required by ETIM for the given class (each feature in a separate column) and the first row contains a list of possible values (EV) that can be used in each column.

ETIM-Mapper data template – certain information can be used only internally in the ETIM-Mapper application: this information concerns labels and additional technical description. This template contains two main tabs:

File/Export

The default values of all export settings can be customized in the "Settings/Export" tab.

ETIM version – products are exported by default in the current version of the ETIM. You can select a previous ETIM version.

Data export format – the default formats of exported files is BMEcat ETIM 2005 (XML file). Besides, the following formats are available:

All files are exported in a compressed form (zipped).

Export options – available depending on the chosen format:

Create a link to the current export – you can create an "export link" to the current export form. You can distribute such link to the data receiver, instead of sending him a catalogue file. The receiver will be able to download your file (no login needed) according to selected export settings. All generated exports links are available in the "Settings/Export links" tab.

Classification

Classifying screen is the main component of the application. It is divided into two parts:

Products – it contains a list of all user products. The elements of the list are: product ID, completeness of product description, ETIM class identifier (if the class has been assigned) and name of the product. If the product has a label or photos, their presence is indicated by icons. It is possible to sort products, and filter them to restrict the number of displayed products, which greatly simplifies the navigation. To start the classification process, one product must be selected in this screen.

Classification window – it is the most important part of the application: all the values for the ETIM and BMEcat description are entered here. The window consists of seven tabs:

A completeness of the product description is measured in each information category: ETIM, general, order, packing, price and MIME. The completeness description for every category represents the coverage of the mandatory fields, required by ETIM International*. The total completeness of the product description is a weighted average of the values in each category. The completeness indicators (total and for each category) for a single selected product are shown in the classification window tabs.

* The completeness measure is based on the fields, which are mandatory in at least one country (such fields are marked in bold in the application).

Products

This screen allows you to manage classified products. There are following tabs:

Products loaded – this tab contains a list of all the products loaded for classification. This tab allows you to filter products: you can use a set of filters for each column (the completeness of the product description can be use in filters, among others filtering criteria). Filter can be saved ("Save filter") – in this way, the list of products "seen" by a particular user will be limited to products that meet the criteria set in the filter. Some special characters can be used in filter: % (percent) or (underscore), denoting respectively any text or any single character. The active filter is signaled – name of the currently selected filter is displayed in red. The filter will remain active until it is removed or modified. You can define several filters, but only one of them can be active. In the "Products loaded" tab, it is possible to sort the products by a particular column or delete the selected product from the list. Group modification for multiple product is possible for certain features. To collectively modify such parameters of selected products, you must open the modification form (link: "Modification for multiple products"), then enter the corresponding values for the columns to be modified and click the button "Save" (that appears when at least one of the form fields is modified). Columns for which values are modified are highlighted in light blue. Note: activating the form for any column without typing values can mean the propagation of an empty value. To deactivate such column, you should click on this column once again.
This screen offers also a possibility to add a new product manually (icon: ). To create a new product, you only need to provide its unique identifier. The remaining elements of the description should be completed in the Classification screen or by import.
You can also create a new product based on an existing one by copying its description, classification and labels – the so-called "product cloning" function (icon: ) is used for this purpose. It is required to provide only an unique identifier of the new product. The other elements are copied from the original.

Products by ETIM – list of classified products is available in this tab. Products are grouped according to the ETIM classification (group/class/products). A list of products classified in a single class helps to check the correctness of filling of individual parameters of every product. This tab allows you to sort, filter and globally modify parameters of selected products. The special characters: % (percent) or _ (underscore) can be used in the filter, denoting respectively: any text or any single character. To collectively modify such parameters of selected products, you must open the modification form (link: "Modification for multiple products"), then enter the corresponding values for the columns to be modified and click the button "Save" (that appears when at least one of the form fields is modified). Columns for which values are modified are highlighted in light blue. Note: activating the form for any column without typing values can mean the propagation of an empty value. To deactivate such column, you should click on this column once again.

Migration ETIMv6 → ETIMv7 (optional tab) – migration of product description from ETIM version 6 to version 7 the following situations are possible: change of class, loss of feature or value of alphanumeric feature, new feature or value of alphanumeric feature. In this section there is a list of classified products, affected by the migration (if there were no such products, this tab is not visible or is empty). They are called "products for approval". The following changes in the classification of products are shown:

In this view, the user can filter products and modify values globally for multiple products (button "Save") and approve its migration (button "Confirm"). In this way, the modification and the approval of all migrated products can be done in one place. All the products approved by the user are no longer visible on this tab. It is recommended to review and approve all products affected by the migration. In order to verify the initial number of products for approval, click on the link "show initial list".

Statistics

Statistics tab shows you the total average completeness of the product description and average completeness description in each information category: ETIM, general, order, packing, price and MIME. Besides these completeness indicators, there are pie-charts showing the distribution of products in five ranges of the description completeness:

This product distribution can be helpful to improve and monitor the completeness of the product description.

Settings

This screen allows to personalize the application parameters for each user. There are following tabs:

Account – user account settings (e-mail, password, interface language).

Company – information about the provider of product data.

Export – default values for all export options.

Classification – setting of the following parameters for product classification:

Labels – creation, modification and removal of labels, for product identification. The user defines labels by entering name, description, and selecting a unique symbol (colored badge with letter). If existing label is deleted, it is removed from all products marked with it. In addition to the visual indication of products, the label can also be used to filter products.

Filters – user can view, rename, delete or activate defined product filters.

Export links – it allows to view, edit and delete defined export links. Export links can be used by data receivers to download files without having to log on to the application. Export links can be created in the tab: "File/Export".

Disk space – allows you to place MIME files (photos, drawings, certificates, index cards, etc.) available for customers.

Start using ETIM-Mapper

Contact

MediaLab s.c.
Bożena Rożenek, Zbigniew Rożenek

Beskidzka 25
91-612 Lodz, Poland

+48 512 555 879
+48 42 209 14 39
+48 42 633 29 46

zbyszek@medialab.pl
gnowak@medialab.pl


Some of our customers

TelevesUTC Fire & SecurityGrudnikPokójHeliosSocomec