You can import related code values into a hierarchy in Reference 360.
For example, a location hierarchy is defined with two parent-child relationships between the Country to State code list and State to State Code code lists. If you want to import 1000 related code values into a hierarchy, you can import the source file that contains the required relationship details with the parent and child code values.
The source file that you import must contain the code values of the parent and child code lists. Reference 360 generates the source primary key of relationships with the related parent and child code values. To import the code values, map the source primary key fields from your source file to the target fields.
Note: You can't update existing relationships in a hierarchy because each relationship contains source primary keys with unique codes of the parent and child code values.
The following table lists a sample format of the source primary keys of the relationships along with the related parent and child code values:
TopLevel_spkey
CountrytoState_parent
CountrytoState_child
StatetoStatecode_parent
StatetoStateCode_child
Germany
Germany
Berlin
Berlin
10243
India
India
Delhi
Delhi
110010
Australia
Australia
Sydney
Sydney
2001
The import process verifies the mapping and ensures that the source file contains the same relationships and code values that exist in the hierarchy model. If the source file contains different relationships and code values, the import process fails.