How can I import hardware assets where the model category (UPS) is not unique?

[Bobby Campbell]

I'm trying to import ~100 rows of data into the alm_hardware table. The issue is that the Model Category field value (UPS) isn't unique, even though both of these are OOTB categories:

1. Model Category 1: UPS (with a parent category of Facilities).  I don't want to use this one. But import always chooses it.
2. Model Category 2: UPS (with an empty parent category). This is the one I want to use.

How can I force it to choose the 2nd UPS model category so that the assets and CIs are created in the correct tables?

I've attempted to use the sys_id instead of "UPS" in the Model category column, but this didn't work for me.

[Swapna Abburi · Accepted solution]

Hi @Bobby Campbell 

Can you share the screenshot of Field mapping for Model Category in your transform map? if you are using sys_id, I think you need to update "Referenced value field name" in field mapping to 'sys_id'.

[Bobby Campbell]

@Swapna Abburi thank you for the direction!  I updated Referenced value field name to sys_id and it worked perfectly.