Thanks Alex_Perretti. I have gone through the tech document # TEC479515
I am successful with using xml for the relationship mapping for CIs using grloader. We have huge CI data in spreadsheet which needs to be loaded along with relationship mapping. Converting the spreadsheet to xml with the multiple child nodes is more consuming. So we wanted to use the spreadsheet format to load the data.
We used the below format and loaded using gr loader.
name | class | system_name | dns_name | is the child of |
CI_item_1 | Zone | CI_item_1 | CI_item_1.dsn | CI_item_Parent |
internally in grloader, this gets converted to an xml format as below
<GRLoader>
<relation>
<!--ERROR: Dependent CI not found.-->
<type>is the child of</type>
<delete_flag></delete_flag>
<provider>
<id>628193FE541FAF4C850AD1B319C509D9</id>
<name>CI_item_1</name>
<system_name>CI_item_1</system_name>
<dns_name>CI_item_1.dsn</dns_name>
</provider>
<dependent>
<!--ERROR: Dependent CI not found. -->
<name>CI_item_Parent</name>
</dependent>
</relation> .....
But the grloader expects like below.
<GRLoader>
<relation>
<!--ERROR: Dependent CI not found.-->
<type>is the child of</type>
<delete_flag></delete_flag>
<provider>
<id>628193FE541FAF4C850AD1B319C509D9</id>
<name>CI_item_1</name>
<system_name>CI_item_1</system_name>
<dns_name>CI_item_1.dsn</dns_name>
</provider>
<dependent>
<!--ERROR: Dependent CI not found. -->
<name>CI_item_Parent</name>
<system_name>CI_item_Parent</system_name>
<dns_name>CI_item_Parent.dsn</dns_name>
</dependent>
</relation> ....
We cannot have like this in spreadsheet. Let us know what spreadsheet format we should use in excel when we need to map more than identifier for the provider or dependent CI.