Importing relationships- reference field value

[joanct]

In an effort to get our CI data in SNOW configuration management , we   successfully identified critical CIs from old system and imported CIs into SNOW CMDB tables Now our team wants to import relationships to cmdb-rel-ci table from external source- CSV template extract.We have verified relationship type exists in cmdb-rel-type . But while trying to come up with a web service import set and transform map , we ran into challenges identifying whether its the tablename or the CI name that should be mapped in parent and child fields - so is it the CI name or CI's table name .if its the CI name - say VMserverC23 , is a script required for the parent and child   field on the web service transform map to check that specific CI data being imported exists in their original tables? what is reference field value on transform maps?

[Bhavesh Jain1]

Let me know if that worked.

[satktweet3]

the spreadsheet format in reference means that an administrator needs to fill the information in excel sheet for parent, child and other fields fromt the data they get from CI sources and define a relationship type to import accurately in the cmdb_rel_ci table.is this correct?

[alexei3]

Hello Bavesh, quick question. You said their CVS need 5 fields, but if you analize the [cmdb_cil_rel] table no field is "Mandatory". Is it posible to simply insert 2 fields such as parent and child? Or do I need the whole 5 values?.