Exporting Language Codes

Language codes can be exported in CSV-report format. The user can identify the language code associated to multilingual fields, allowing the exported string to be matched to the locale.

Taleo Connect Client is running and ready for use.

Taleo application is available for integration.

1. From TCC open New Export Wizard File>New>New Export Wizard.

   The New Export Wizard opens.

2. In Product pull down menu, Select SmartOrg [Version].
   1. In Filter, enter letter o.
   2. Click on Organization.
   3. Select Create new export.
   4. Click on Finish.

   A New Export editor opens.

3. In General tab, Other information, Export mode, select CSV-report from pull down menu. header present.
4. In General tab, Other information, select CSV header present.

   We will use default values for the CSV attributes.

5. Select Projections tab.
6. Drag and Drop Name from Entity view to Projections list.
   1. Select Name in projection list.
   2. Select Alias and enter ParentName in dialog box.
   3. Click Field open window button.
   4. Select Show the value only in the default locale.
   5. Click OK
7. Drag and Drop Code from Entity view to Projections list.
   1. Select Code in projection list.
   2. Select Alias and enter ParentCode in dialog box.
8. Drag and Drop Children,Name from Entity view to Projections list.

   Expand Children and BaseComposite to expose Name.

   1. Select Children,Name in projection list.
   2. Select Alias and enter ChildName in dialog box.
   3. Click Field open window button.
   4. Select Show values in all locales.
   5. Click OK.
9. Click Add.
   1. Select Add a multilingual field projection.
   2. Click OK.
   3. Select multilingual field projection.
   4. Select Alias and enter ChildLocale in dialog box.
   5. Select Locale from Field pull down menu.
   6. Drag and drop the Children relation into the Relation dialog box.
10. Select Filters tab.
    1. Drag Code from Entity view to Filters list and select it.

       By default first Value is set to Code, Data type is set to Field, and Operator is set to Equals.

    2. Set second Value to CPCORP0.
    3. Select String from pull down menu for second Data type.
11. Save as OrgLocale-export_sq.xml in organization-export folder.

    Folder structure is described in Installation section.

12. From TCC open New Configuration Wizard File>New>New Configuration Wizard.

    The New Configuration Wizard opens.

13. Select Based on an export specification.
    1. Click the Browser button.

       A Select folder window opens.

    2. Navigate to organization-export folder.
    3. Select OrgLocale-export_sq.xml.
    4. Click on Open.
    5. Click on Next.
    6. Select Endpoint.
    7. Click on Finish.

    A New Configuration editor opens.

14. In General tab, under Request, select Pre-defined value
    1. Click the Browser button.

       A Select file window opens.

    2. Navigate to organization-export folder.
    3. Select OrgLocale-export_sq.xml.
    4. Click on Open.

    The file path and name are displayed in the dialog box

15. In General tab, under Response, select Generated using an identifier
    1. Click the Browser button.

       A Select folder window opens.

    2. Navigate to organization-export folder.
    3. Click on OK.

       The file path is displayed in the dialog box

    4. Click the Browser button.

       A Choose Identifier window opens.

    5. In the Template dialog box enter OrgLocale-[NOW]
    6. Click OK.

       OrgLocale-[NOW] is displayed in the dialog box

16. Save as OrgLocale-Extract_cfg.xml in organization-export folder.
17. Click the Execute the configuration icon and wait for the workflow to complete the extraction.
18. Open organization-export folder.
19. Open CSV result file OrgLocale-yyyyMMddTHHmmss.csv in a csv editor or notepad

ParentName,Parentcode,ChildName,ChildLocale 
Corporate Headquarters,CPCORP0,Research & Development,en 
Corporate Headquarters,CPCORP0,Investigatiión y desarrollo,es 
Corporate Headquarters,CPCORP0,Recherche et développement,fr 
Corporate Headquarters,CPCORP0,Human Ressources,en 
Corporate Headquarters,CPCORP0,Recursos humanas,es 
Corporate Headquarters,CPCORP0,Ressources humaines,fr 
Corporate Headquarters,CPCORP0,Production,en 
Corporate Headquarters,CPCORP0,Producción,es 
Corporate Headquarters,CPCORP0,Production,fr 
Corporate Headquarters,CPCORP0,Finance,en 
Corporate Headquarters,CPCORP0,Finanzas,es 
Corporate Headquarters,CPCORP0,Finance,fr 
Corporate Headquarters,CPCORP0,Sales,en 
Corporate Headquarters,CPCORP0,Ventas,es 
Corporate Headquarters,CPCORP0,Ventes,fr