cmdb ci relation load import set

[Naveen87]

Hi Developers,

I'm trying to Import data using Load Data on CI relationship table.

Trying to build relationship between Business application & technical service table.

I observed a problem,

When both Bus App & Service has same name then the relationship is not build & get this error

I also tried to add class name in the Load sheet to avoid the confusion for the system but then I get the error which says class field does not exist on relationship table & it can't read it.

Please suggest how to tackle this.

We have 500-700 records where relationship needs to be created & they have same name in Bus app & Services.

Thank you.

[Aman Kumar S]

Hi @Naveen87 ,

How are you doing the field mapping?

Instead of doing the field to field mapping, use script to map.

Something like:

var parent = new GlideRecord (source.parent_class);

parent.get('name', source.parent_name)

return par.sys_id;

[sourav1999]

• The relationship between Configuration Items (CI) and Configuration Management Database (CMDB) is that CMDB is a repository of CIs.

• CIs are the items that are tracked and managed in the CMDB.

• CIs can be imported into the CMDB using the CI Loader set.

• The CI Loader set allows for the import of CIs from various sources, such as spreadsheets, databases, and web services.

For asking ServiceNow-related questions try this :

For a good and optimistic result, please visit this website. It uses a Chat Generative Pre-Trained Transformer ( GPT ) technology for solving ServiceNow-related issues.

Link - https://nowgpt.ai/

For the ServiceNow Certified System Administrator exams try this :

https://www.udemy.com/course/servicenow-csa-admin-certification-exam-2023/?couponCode=NOW-DEVELOPER