Ci's model id

surya123
Mega Guru

‎08-17-2016 01:58 AM

Hi,

On importing data to CI using an import set , model id data creates a new model( blank name field and display name same as model id of CI) if the same model name doesnot exist in model module.   Why does it dont map to Name field and to display name field? Any thoughts?

0 Helpfuls
  • 2,738 Views
2 REPLIES 2

jake_mckenna
ServiceNow Employee
ServiceNow Employee

‎08-17-2016 05:24 AM

Depdeding on your data you can remap your transform to point reference field to another field on the field mapping to override the default, which is the display value. Create a field map and check out the info around Reference Field Value name.



Another more advanced option is to look to leverage the OOB function MakeandModelJS. This can also be used and is leveraged to help build a model before linking it to a CI or finding one based on the name and Manufacturer. An example usage of this could possibly be:


var mm = MakeAndModelJS.fromNames(source.u_manufacturer, source.u_model, "hardware");

target.model_id = mm.getModelNameSysID();

target.manufacturer = mm.getManufacturerSysID();

0 Helpfuls

Community Alums
Not applicable

‎08-17-2016 05:57 AM

Surya,



First: Do you have Model information available to you in the data you are importing? If so, then you can create the Model as part of the import. To do this, create two Transform Maps to work with your Import Set. One that imports data to the Hardware Model table and the second is the one that you have. I find this to be the easiest way to handle this without scripting, and it ensures that the Model is created before your CI is created.


Just a note on this: Transform Maps should be run in a particular order. It does you no good to run the Model import after the CI import. To facilitate this, name your Model Transform Map in a way that it is alphabetically before the CI Transform Map. The Order field does not seem to do anything. With the Model Transform Map alphabetically first, it will show up in the list of Transforms to apply when you run your transformation and you only need to add the CI Map.



Ben


0 Helpfuls