Model ID import with IntegrationHub ETL

[Damhoej]

I am trying to figure out how to populate Model ID attribute when importing from excel file using IH ETL.

When I select model_id it just ignore the value and leave the attribute empty. No error or any indication that it did import the value.

Any idea how to fix that?

[sandeepdutt]

Hi @Damhoej ,

You can use this solution : Model ID Population using IH-ETL - ServiceNow Community

[Damhoej]

It does not work.

I have tried all the clense methods and none of them are working.

I still get an empty model id attribute

[Sandeep90]

Ensure you are doing a lookup on cmdb_model when configuring IHETL, doesn't have much detail but the model_id should be sent with sys_id or configure display name to do automatic lookup. 

[Damhoej]

i can not do a lookup on a new model.

have you tried to import a server ci from excel and select model id in the transform map?

It just ignores that field