Importing Configuration Items

CJB · ‎05-10-2020

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.

CJB · ‎05-11-2020

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.

View solution in original post

Akshata jamdar · ‎05-11-2020

Thank you for marking the answer as helpful.

Am not sure but, I think this might happens because when you create any asset the display name field is read only and will get auto populated when you select model and model category. It is the combination of both if try to push it static it would not allowed. This is just a thought of mine. hope this will make sense

Thank and Regards,

Akshata

CJB · ‎05-23-2020

That makes sense. Thank you.