Attribute Translations Export/Import – CPQ Online Help


This shows you the differences between two versions of the page.

adminhelp:productadministration:pattributes:attributetranslationsimportexport [2016/02/24 07:45]
adminhelp:productadministration:pattributes:attributetranslationsimportexport [2018/08/10 08:26] (current)
Line 1: Line 1:
-======Attribute translations export import======+====== Attribute Translations Export/Import ====== 
 +To translate multiple attributes easily in one Excel file, go to **Import/Export** > **Attribute Translations Export/Import**. On this page you can select individual attributes or an entire attribute type to export, update their translations in the Excel file and import the file in CPQ. 
 +  - In **Step 1**, select the attributes to export. 
 +     * **Select by Attribute Name** - enter a search term or specific attribute names. All attributes that match the search term will be exported. 
 +     * **Select by Attribute Type** - select an attribute type and pertaining attributes will be exported. \\ Combining two search queries is also possible (e.g. attributes with //Color// in their name that pertain to the attribute type **Container**). 
 +  - In **Step 2**, select the languages to export. 
 +  - Click one of these export buttons: 
 +     * **Export Attributes Translation** - exports translations for all attribute types except **Container**. 
 +     * **Export Containers Translation** - exports translations only for **Container** attributes. \\ An Excel file is downloaded to your computer. Attribute IDs, default names and translations in the selected languages, if defined, are displayed in the file. Also, a separate sheet contains attribute values with corresponding translations. If **Container** attributes are exported, the file contains separate sheets for translating container columns, properties and validation messages. 
 +  - Update attribute translations in the dedicated columns. 
 +  - In **Step 3**, upload the Excel file. \\ The button on the right is for uploading files with container attribute translations and the button on the left for files with all other attribute types. 
 +     * Click {{:adminhelp:productadministration:pattributes:cpq_ch_browse_attributes_translations_icon.png?15}} 
 +     * Browse for your file. \\ The name of the selected file shows in the bar. 
 +     * Click **Apply Template**. \\ A success message displays. \\ Otherwise, if the import file contains invalid records, an error message pops up. 
 +     * Click **Import report**. \\ Invalid records are marked in red and errors are described in the **Error** column. 
 +When you or your underlying users select a language in CPQ, if translations were imported for the attributes, the system will display them in the **Catalog**.
-This feature provides you with the ability to export attributes that you want to translate to different languages. You can choose which attribute to export by typing its name, or selecting attribute type. Also you select one or more languages to what you want to translate attributes. Selected attributes are exported as an excel document where you can insert translations for selected languages. Once you fill in desired translations, you can import that file. All translations are stored in the database. This feature supports translations for standard attributes and container attributes. 
-===== Example ===== 
-Import/export attributes translations can be found under **Setup** -> **Import/export** -> **Attribute Translations Export/Import** (See figure A) 
-{{ :adminhelp:productadministration:pattributes:1.png }} 
-;#;// Figure A - Attribute Translation menu //;#; 
-On the translation page there are a few options for you to choose in order to select which attributes you want to translate for any language. (See figure B) 
-{{ :adminhelp:productadministration:pattributes:2.png }} 
-;#;// Figure B - Attribute translations page //;#; 
-In the first step (attribute selection step) there are two available filters. First filter allows you to type attribute names which you want to export. If you want to export all attributes of particular type, then use second filter within step 1. (See figure C) 
-{{ :adminhelp:productadministration:pattributes:c.png }} 
-;#;// Figure C - Attribute name filter //;#; 
-In the second step there is a filter where you can select a language that you want to translate for a specific attribute(s). You can select on or more languages. (See figure D) 
-{{ :adminhelp:productadministration:pattributes:d.png }} 
-;#;// Figure D - Language filter //;#; 
-Once you selected a desired attribute and language, click on Export Attribute translations button. You will download an excel file that will have a few columns. (See figure E). There will be a separate column for each language that you selected.  
-{{ :adminhelp:productadministration:pattributes:3.png }} 
-;#;// Figure E - Exported attributes as an excel (.xlsx) file //;#; 
-Type your translations into the respective columns. (See figure F) 
-{{ :adminhelp:productadministration:pattributes:4.png }} 
-;#;// Figure F - Translations entered into the excel file //;#; 
-Once you are finished, load your document by clicking on upload button and then click on button Apply Template. (See figure G) 
-{{ :adminhelp:productadministration:pattributes:f.png }} 
-;#;// Figure G - Uploading translations //;#; 
-Your translations will be uploaded and a success message is displayed.  
-{{ :adminhelp:productadministration:pattributes:success.png }} 
-;#;// Figure H - Success message displayed //;#; 
-<note>Similar applies for a container attributes.</note> 
You are here: CallidusCloud CPQ Online HelpAdmin Page HelpProduct AdministrationAttributesAttribute Translations Export/Import