CMDB Transform Map-Model ID not transform

nancyhz
Mega Contributor

I am very new to CMDB implementation. Today, I loaded computer CSV file into ServiceNow instance and created transform map (see the attached screenshot).

I performed transform and all records are transformed into computer (cmdb_ci_computer) table. However, only Model Id record wasn't transformed over for all records.

I know Model Id may relate to Product Model, do I need to anything on product model ?

I will greatly appreciate your feedback.

2 REPLIES 2

prdelong
Kilo Guru

Could be a few things. First of all make sure that the choice action of the u_model mapping is not set to 'ignore.' It should be 'create' by default, but having it set as 'ignore' means that the model_id will not be imported if a match is not found. Also unless you are scripting the transform -- it does not sound like you are -- make sure you use the "reference value field name" for importing to reference fields (ie manufacturer, model ID). The reference value field name in this case would be the "Display Name" field on the cmdb_model field, which is what the model_id records are kept.


nancyhz
Mega Contributor

Hi Payton

You are right, the choice action of the u_model mapping is set to 'ignore.' so it worked after change to "create".

Thank you for your help