Importing Configuration Items

[CJB]

Hi Everyone, 

Currently, I'm trying to import communication items into ServiceNow from an Excel spreadsheet. I thought the best business practice was to import configuration items, then assets, connecting the two with a coalesce. The coalesce is not working. Instead of importing multiple rows, I decided to just test one record. After importing and transforming, I end up with two assets and two configuration items.

Just to see if something was wrong with the environment, I decided to try importing in a personal instance. I was able to import the configuration item without a problem! The asset was automatically created as well without any issue. One thing I noticed, in my company's environment, the asset is created as just an asset. In my personal instance, it's created as a hardware item.

In my company's instance, all scripts are activated. No scripts have been altered either. Model categories match in both my company and personal environment.

Note: Company is on London. Personal is using Madrid.

[Akshata jamdar]

Hello CJB,

Have you checked CI entry is get duplicated in import set table also or only it gets duplicate after transform map execution that means in the target table?

Regards,

Akshata

[CJB]

Hi Akshata,

It's only after transform map execution. When I import/transform config item, asset is created, but empty. It's the same for when I import/transform asset, the config item is empty. When I coalesce, I thought the two would join.

[Akshata jamdar]

Please refer the below link which is some how similar to this problem, You need to put coalesce for correct filed like serial number, asset tag or any field which will unique from asset and CI ,

https://community.servicenow.com/community?id=community_question&sys_id=31d187a9db98dbc01dcaf3231f96...

This link is much helpful as it explain much about CI and Asset creation using import set. Please go through onece.

Hope this will helps.

Regards,

Akshata.

[CJB · Accepted solution]

Thank you very much for the resource. After messing around a little more, I decided to remove "Asset" from my Comm_CMDB import set. As soon as I did that, it worked! When I had the asset already set up in my Excel document, it would set the asset to blank in the CI and the asset would be completely blank. Removing it did the trick though! Do you know why trying to set up the asset name in Excel would cause issues? Just trying to understand better.