Import of types with parameters

The document shows how to import the assortment (element types) into the system along with any additional parameters defining them. Sometimes, when importing an assortment, we want, in addition to the basic information (type, manufacturer, price), to import any additional parameters that will identify the given assortment. We can store important information there, which we can later use as parameters to perform analyses/automate activities.

Let’s assume that we have an assortment to import, which, in addition to the basic information (type, manufacturer, price), has additional parameters that we want to import. In our case, we want to import an assortment that, in addition to the basic information, has two additional parameters.

We prepare an XLSX file with data for import. In our case, the file contains data about element types along with additional parameters. In our case, we want to import element types that will have one additional parameter: "Rated voltage".

We go to the AMAGE application to the configuration section. We select the data import section and select a specific importer. Here we select Element Types.

Let’s move on to data import. We select the XLSX file with the data to be imported.

We move on to the next stage. We are introducing additional importer options. We select the option for the importer to ignore case during import. In the case of manually completed files, errors in letter size often occur. This option allows you to ignore such differences and not create unnecessary duplicates. Additionally, we select the option to select the column that will be used to map element types. In our case, this is a column with the order number and manufacturer’s name.

We move on to the next step, i.e. defining additional parameters for importing element types. We can define any number of parameters for import. We add them using the (+) button.

We can flexibly define each parameter and determine whether a given parameter property comes from an XLSX file or is permanently defined. In this specific case, we have defined a parameter with the working name "parameter 1", for which the parameter name will come from the import file from column D. The default value of the parameter will be read from column E. However, we set the remaining properties of the parameter to constant values, such as the additional description on "Description from line", the unit of measurement is [V], the column type is a string and the default parameter category is 'category 1'.

We will stick to defining one parameter for the element type. We move on to the next step, i.e. defining the mapping of columns from the XLSX file to columns in the AMAGE system. This is a standard step that allows you to indicate columns for basic data identifying, in this case, the element type. The key parameters are the manufacturer’s name and the type name. All other parameters are optional.

Let’s move on to data import. We import and save data to the system.

As a result, we receive element type data imported into the system along with additional parameters. We don’t have to create parameters manually.

In the AMAGE system, we can import element types with additional parameters. Thanks to this, we can import an assortment into the system that, in addition to the basic information, has additional parameters. In our case, we imported element types that, in addition to the basic information (type, manufacturer, price), had an additional parameter "Rated voltage". Thanks to this, we can flexibly define the assortment in the AMAGE system.