Finding Root Code
To find the root code, we will extract it from the entity. The root code value will be the parent code of the first record of the hierarchical entity we will create.
Before you start
Taleo Connect Client is running and ready for use.
Taleo application is available for integration.
Here's what to do
- Click File, New to open the New Export Wizard.
- In Product pull down menu, Select SmartOrg [Version].
- In Filter, enter letter o.
- Click Organization.
- Select Create new export.
- Click Finish. A New Export editor opens.
- In General tab, select CSV header present. We will use default values for the CSV attributes.
- Select Projections tab.
- Drag and Drop Code, Name, and Level from Entity view to Projections list.
- Select Filters tab.
- Drag Level from Entity view to Filters list and select it.
- In the bottom Data type drop down menu select Integer.
- In value, Enter 0. Level 0 is the root level.
- Save as OrgRoot-export_sq.xml in organization-export folder. Level 0 is the root level.
- Click File, New to open the New Configuration Wizard.
- Select Based on an export specification.
- Click the Browse icon.
- Navigate to organization-export folder.
- Select OrgRoot-export_sq.xml.
- Click on Open.
- Click on Next.
- Select Endpoint.
- Click on Finish. A New Configuration editor opens.
- In General tab, under Request, select Pre-defined value.
- Click the Browse icon. A Select file window opens.
- Navigate to organization-export folder.
- Select OrgRoot-export_sq.xml.
- Click Open. The file path and name are displayed in the dialog box.
- In General tab, under Response, select Generated using
an identifier.
- Click the Browse icon.
- Navigate to organization-export folder.
- Click OK. The file path is displayed in the dialog box.
- Click the Browse icon.
- In the Template dialog box enter [FILE]-[NOW].
- Click OK. [FILE]-[NOW] is displayed in the dialog box.
- Save as OrgRoot-Extract_cfg.xml in organization-export folder.
- Click the Execute the configuration icon. and wait for the workflow to complete the extraction.
- Open organization-export folder.
- Open CSV result file OrgRoot-export_sq-yyyyMMddTHHmmss.csv in a csv editor or notepad
Results:
The root code, organization name, and level are displayed below the header.
Code,Name,Level
ROOT-ORGANIZATION,[en]=New Millenium,0