Using an example, this chapter explains how to export product data for translation and how to re-import the translated file in order to update the product data in iPIM accordingly.
Step 1: Export product data
In this step, the aforementioned product data for the products in the worklist “WL24” is exported as a .xlsx file. This comprises the german attribute values of the localized attribute “DT704-Devicetype” and the german texts of the text type “Plain”. Hereby, the data on the product level and on the main context level “Customer” is exported. To do so, proceed as follows:
- Go to the “Translation export” tab of the “Product data update” app.
- From the menu, select the option “Worklist”.
- Choose the worklist from the directory structure. Possibly use the text search to filter the selection of worklists by a search term.
- Click on the worklist to select it.
- From the “Layer” menu, select the option “Product” in order to export data on the product level.
- From the “Format” menu, select the option “XLSX” in order to export product data as a .xlsx file.
- From the “Context” menu, select the appropriate context level (in this case “Customer”).
- From the “Source locale” menu, select the source locale as well as the target locale.*
- Select the attribute respectively the text type to be translated. To do so, click on the
button to call up the corresponding dialog box.
- Transfer the attribute respectively the text type from the left column to the right column by clicking on them. Possibly use the text search to filter the list of attributes and text types by a search term.
- Click on the button to finalise the attribute and text type selection. Following this, the dialog box closes.
- Click on the button in the lower right corner to trigger the download of the translation file. Once the download is complete, you can usually find the file in your local download folder.
Step 2: Insert the translations
In the step, the translations are entered into the translation file. To do so, proceed as follows:
- Open the translation file in a spreadsheet software.
- Insert the translations in the appropriate table cells and save the file.
Step 3: Import the translation file
In this step, the translation file is re-imported into the system in order to update the product data in iPIM accordingly.
Step 3.1: Configure the import
In this step, the import is configured according to the properties of the translation file. To do so, proceed as follows:
- Go to the “Translation import” tab of the “Product data update” app.
- From the “Item type” menu, select the appropriate product structure level (in this case “Product”).
- From the “Format” menu, select the file format of the translation file (in this case “XLSX”).
- From the “Locale” menu, select the locales of the translation file (in this case “German” and “English”).
- From the “Context” menu, select the appropriate context level (in this case “Customer”).
- Drag the translation file over the drop area and drop it there. Or click on the “
Browse files” button to call up the translation file via the file manager. Following this, the file is loaded into the cache and the file name is shown below the drop area. - Select the attribute respectively the text type that are to be updated by the import of the translation file. To do so, click on the button to call up the corresponding dialog box.
- Transfer the attribute respectively the text type from the left column to the right column by clicking on them.
- Click on the button to finalise the attribute and text type selection. Following this, the dialog box closes.
The import configuration is now complete.
Step 3.2: Execute the import
In this step, the import file is loaded into the system. To do so, proceed as follows:
- Click on the button to load the translation file into the system. If the process was successful, a corresponding message will appear and the data from the file is shown in the table of the right-hand card.
Step 3.3: Accept the translation data
In this step, the translated product data is accepted in order to update the product data in iPIM accordingly. To do so, proceed as follows:
- Click on to accept the data. If the process was successful, a corresponding message will appear.
The product data is now updated according the translation file.