Translation export

In the “Translation export” tab you can export product data as a file to have it translated. This comprises product data such as localized attributes or product texts. Later you can import the translated file in the “Translation import” tab to update the product data in the iPIM system accordingly.

Select Source

In the “Select source” card you can specify the products whose product data you want to export to have them translated. In this regard, you have the options to access a worklist which contains the desired products, you can determine the products from the “Active selection” as a source or you can assemble a given list of products by using the list search.

Select a worklist as a source

You can select the products of a worklist as the source for the export file. To do so, proceed as follows:

  1. In the “Select source” card, select the option “Worklist” from the corresponding menu .
    Chevron rightThe worklist directory is shown below the menu.
  2. Optional: Use the text search to filter the selection of shown worklists a search term. To do so, enter the search term in the search field .
  3. Choose the worklist from the worklist directory .
  4. Click on the worklist to select it.

Specify the active selection as a source

You can specify the products from the active selection as the source for the export file. To do so, proceed as follows:

  • In the “Select source” card, select the option “Active selection” from the corresponding menu.

Assemble a group of products using the list search

You can use the list search to assemble a given group of products which then can be used as the source for the export file. To do so, proceed as follows:

  1. In the “Select source” card, select the option “List search” from the corresponding menu .
  2. Enter the appropriate product numbers in the “Number list” field . You can seperate the product numbers by semicolons or line breaks.
Note
At this point, the list search can only be applied to product numbers.

Configuration

Via the input mask of the “Configuration” card you can configurate your export file. To do so, proceed as follows:

  1. To select a product structure level, select the corresponding option from the “Layer” menu . You can choose between the options “Product”, “Variant” and “Item”.
  2. To select a file format, select the corresponding option from the “Format” menu . For example, you can export the product data as a .xlsx, .xml or .html file.
  3. To select a context level, select the corresponding option from the “Context” menu .
  4. To select a source language, select the corresponding option from the “Source locale” menu . IMPORTANT: If you select the file format “.xslx”, you also have to select the intended target language in this menu, so that the export file contains a column with empty cells where the translated text can be inserted. This is crucial for the mapping when you later re-import the file. If you just overwrite the cells with the original source language text, the original text will be overwritten in iPIM when you import the file.
  1. To select the target language, select the corresponding option from the “Target locale” menu . IMPORTANT: This menu only appears if the user selects the file formats “.xliff”, “.xml” or “.html”.
  2. To select the attributes or text types whose attribute values respectively product texts you want to have translated, click on the button to call up the corresponding dialog box.
  1. Select the attributes respectively text types:
    • To select an attribute, transfer it from the left column to the right column . The same applies to text types.
    • To deselect an attribute, transfer it from the right column back to the left column. The same applies to text types.
  2. Click on the APPLY button  to finish the selection of attributes respectively text types and to close the dialog box.
  1. Click on the DOWNLOAD button, in order to create the export file. If the process was successful, a corresponding message will appear.

Usually, the export file can be found in your local download folder. Following this, you can make the translations, enter them into the export file and re-import the file in the “Translation import” tab in order to update the product data of the respective products accordingly.

FAQ

Why do you also have to select the intended target language for the .xlsx file format already at this point?

If you select the file format “.xslx”, you also have to select the intended target language in the “Source locale” menu, so that the export file contains a column with empty cells where the translated text can be inserted. This is crucial for the mapping when you later re-import the file.

When does the “Target locale” menu appear in the configuration?

The “Target locale” menu only appears if you select the file formats “.xliff”, “.xml” or “.html”.

Why isn’t it enough to just select the source language for the .xlsx format?

Only if you also select the intended target language for the .xlsx format does the export file contain a column with empty cells where the translated text can be inserted. This column is crucial for the mapping when you later re-import the file. If you just overwrite the cells with the original source language text, the original text will be overwritten in iPIM when you import the file.

What happens after downloading the export file?

Usually, the export file can be found in your local download folder. Following this, you can make the translations, enter them into the export file and re-import the file in the “Translation import” tab in order to update the product data of the respective products accordingly.