The “Translation import” tab follows on the export of product data in the “Translation export” tab. Here you can re-import the export file as soon as the translated text snippets are entered to update the product data in the iPIM system accordingly.
- In order guarantee a flawless import, format the data in the import file as text.
- Make sure that the import settings match the configuration of the file you want to import.
Configure the import and carry out the preview import
In order to import a file with the translated text snippets, you first have to configurate the import settings:
- Select the appropriate product level from the “Item type” menu
. - Select the appropriate file format from the “Format” menu
. - Select the appropriate language respectively languages from the “Locale” menu
. If you selected the format “XLSX”, you select the languages levels on which attribute values are updated by the import. Make sure you only select languages for which there are corresponding language columns in the import file. If you have selected the format “HTML”, “XLIFF” or “XML”, select the source language of the import file. - If you have selected the format “HTML”, “XLIFF” or “XML”, select the target language of the import file from the “Target locale” menu.
- Select the appropriate context level from the “Context” menu
. - 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.
- Click on the
icon in the “Attributes” section 
to call up the dialog box where you can select the attributes and text tyeps which you want to have updated. In the left column you will see the attributes and text types which could be read from your file. Select the desired attributes respectively text types:
- In order to select an attribute, transfer it from the left column to the right column. The same applies to text types.
- In order to deselect an attribute, transfer it from the right column back to the left column. The same applies to text types.
- Click on the button to finish the selection of attributes respectively text types. The dialog box closes.
- Click on the button
to carry out the preview import. The uploaded product data is shown in the “Preview” table.
Finish the import process
In this step of the import process you can confirm the imported data:
- Click on the button to finish the import process and to update the product data of the listed products according to the uploaded file.
FAQ
Why should the data in the import file be formatted as text?
In order to guarantee a flawless import, the data in the import file should be formatted as text.
Why does the language selection differ depending on the selected file format?
If you selected the format “XLSX”, you select the language levels on which attribute values are updated by the import, making sure you only select languages for which there are corresponding language columns in the import file. If you selected the format “HTML”, “XLIFF” or “XML”, only the source language of the import file is selected at this point; the target language is set separately via the “Target locale” menu.
Why is there only a single menu for selecting the language for .xlsx files?
If you have selected the file format “XSLX”, there is only a single menu for selecting a language. Both the source and target language(s) must be selected here, and all languages for which there are corresponding columns in the import file should be set at this point, since attribute values on the respective language levels are updated by the import.
Why don’t I have to tick any products before finishing the import?
At this point you do not have to tick any products. The data of all the listed products is updated. Ticking products is not necessary unless you want to apply actions from the action menu to particular products.
How can HTML formatted text be turned into plain text upon import?
If the property general.translation.import.texttype.isplain is set to “true”, HTML formatted text is turned into plain text upon the import.
How can I control whether empty values are allowed during import?
As of version 5.4, the property general.translation.import.allowemptyvalues can be used to specify whether empty values are allowed when importing files.
What do I need to make sure of so that the import settings match the import file?
Make sure that the import settings match the configuration of the file you want to import — for example the selected locale(s), context level, and the attributes respectively text types you want to have updated — so that the corresponding columns resp. content of the import file are mapped correctly.