Import & export

In the “Import & Export” section of the “Attributes” app, you can export standard and category attributes as an .xlsx file which then can be edited in a spreadsheet program such as MS Excel. The same applies to the category relations of the values of list of values attributes. Learn more Using the import functions you can re-import an edited file to update the attribute data in the iPIM system accordingly. Futhermore, you can use this feature to create new attributes in bulk by entering the attribute data in a corresponding file and upload the file into the iPIM system. Less information

4. Enter a file name into the “File name” field .
5. Select the file language from the “Language” menu .

• To trigger the export, click on the DOWNLOAD button .
  A process message is shown. Once the export is complete, the export file can be downloaded via the “Tasks” menu in the header.
• To cancel cancel the process, click on the CANCEL button .

Import standard attributes

The import of attribute data is executed in two steps. In the first step you need to use the “Preview” function. In this step the import file is uploaded and checked. In the second step the “Import” function is used to transfer the attribute data into the iPIM system.

4. Drag the import file over the drop area and drop it there. Alternatively, click on " Browse files" to call up the import file via the file manager.
   The file is loaded into the cache and the file name of the file is shown below the drop area.
5. Select the file language of the import file from the “Language” menu .

• To trigger the import, click on the PREVIEW button .
  A process message is shown. Once the import is complete, the attribute data from the import file is listed in the Attribute list table.
• To cancel cancel the process, click on the CANCEL button .

In order to empty the “Attribute list” table, click on the RESET button.

Using the column header tools you can filter table entries or adjust their sequence. In order to filter table entries you can also use the free-text search. And you can customize the selection of attributes that are shown in the table.

Step 2: Import:

In order to transfer the uploaded attribute data to the iPIM system, proceed as follows:

1. Click on thebutton to access the action menu.
2. Move the mouse cursor over the option “Import” to show the corresponding submenu.
3. Click on the option “Import standard attributes” to update the existing attributes and create the new attributes. As soon as the process is finished, a message with the import statistic will appear and the chips in the columns “Status” and “Operation” will be updated accordingly:
   • SUCCESS: The import was successful.
   • FAILURE The import has failed.
   • UPDATED: The attribute was updated.
   • INSERTED: The attribute was created.
   • ERROR: No operation could be executed.
   • MISSING CATEGORY: The category information is missing.

4. Enter a file name into the “File name” field .
5. Select a file language from the “Language” menu .
6. Select the superordinate taxonomy of the category from the “Versions” menu . Following this, the category directory of the selected taxonomy is shown below the menu.
7. Choose the category from the category directory . Optional: Enter a search term in the search field to filter the list of Categories by a search term.
8. Tick the category to select it.

• To trigger the export, click on the DOWNLOAD button .
  A process message is shown. Once the export is complete, the export file can be downloaded via the “Tasks” menu in the header.
• To cancel cancel the process, click on the CANCEL button .

In the export file, various indicators may appear in the columns for each category. These provide information about the category relation of the respective attribute. x means that there is a relation to the category. o means that there is a relation, but the attribute is optional in this category. m means that there is a link to the category and that the attribute is mandatory in that category. By entering the appropriate indicators before the import, you can set up category relations for attributes.

Import category attributes

The import of attribute data is executed in two steps. In the first step you need to use the “Preview” function. In this step the import file is uploaded and checked. In the second step the “Import” function is used to transfer the attribute data into the iPIM system.

4. Drag the import file over the drop area and drop it there. Alternatively, click on " Browse files" to call up the import file via the file manager.
   The file is loaded into the cache and the file name of the file is shown below the drop area.
5. Select the file language of the import file from the “Language” menu .
6. Select the respective taxonomy from the “Versions” menu .

• To trigger the import, click on the PREVIEW button .
  A process message is shown. Once the import is complete, the attribute data from the import file is listed in the Attribute list table.
• To cancel cancel the process, click on the CANCEL button .

In order to empty the “Attribute list” table, click on the RESET button.

Using the column header tools you can filter table entries or adjust their sequence. In order to filter table entries you can also use the free-text search. And you can customize the selection of attributes that are shown in the table.

Step 2: Import:

In order to transfer the uploaded attribute data to the iPIM system, proceed as follows:

1. Click on thebutton to access the action menu.
2. Move the mouse cursor over the option “Import” to show the corresponding submenu.
3. Click on the option “Import category attributes” to update the existing attributes and create the new attributes. As soon as the process is finished, a message with the import statistic will appear and the chips in the columns “Status” and “Operation” will be updated accordingly:
   • SUCCESS: The import was successful.
   • FAILURE The import has failed.
   • UPDATED: The attribute was updated.
   • INSERTED: The attribute was created.
   • ERROR: No operation could be executed.
   • MISSING CATEGORY: The category information is missing.

Import templates to create new attributes

Via a suitable import template you can create new standard or category attributes in bulk. To do so, enter the attribute data into the corresponding import template file and import it into the iPIM system using the “Preview” respectively “Import” function. For this purpose four different import templates are available:

• Standard attributes DE
• Standard attributes EN
• Category attributes DE
• Category attributes EN

• The import templates shown above are valid from version 5.4.2. With version 5.2.4, the column header “Only color level” was renamed to “Only variant level”. And with version 5.4.2, column headers such as “deDE : Description” were renamed to “deDE : Name”.
• If you specify an attribute group type in the “Group” column of the import file that does not exist or at least does not exist exactly in this notation, it will be created automatically during the import.
• Attribute and value IDs may contain numbers, letters and underscores. All other characters are cleansed upon the import.

4. Enter a file name in the “File name” field .

• To trigger the export, click on the SAVE button .
  Once the export is complete, a success message is shown. The export file can usually be accessed via the local download folder.
• To cancel cancel the process, click on the CANCEL button .

4. Drag the import file over the drop area and drop it there. Alternatively, click on " Browse files" to call up the import file via the file manager.
   The file is loaded into the cache and the file name of the file is shown below the drop area.

• To trigger the import, click on the SAVE button .
  Once the import is complete, a success message is shown. The category relations are updated according to the file.
• To cancel cancel the process, click on the CANCEL button .

Via the button you can empty the cache so that you can upload a new file.

FAQ

What is the “Import & Export” section used for?

In the “Import & Export” section, you can export standard and category attributes as an .xlsx file to edit them outside of the iPIM system in a spreadsheet program. The same applies to the category relations of the values of list of values attributes.

Why do you need to run a preview before the actual import?

In the first step, the import file is checked before the data is transferred into the iPIM system in the second step using the “Import” function.

What do the chips in the “Status” and “Operation” columns mean?

The chips indicate the status of the process: “Success” means the upload respectively import of the attribute was successful, “Failure” means it has failed, “Update” respectively “Updated” means the attribute will be respectively was updated, “Insert” respectively “Inserted” means the attribute will be respectively was created, “Error” means no operation could be executed, and “Missing Category” means the category information is missing.

Which characters can attribute and value IDs contain during import?

Attribute and value IDs may contain numbers, letters and underscores. All other characters are cleansed upon the import.