Importing Consumable Assets

[Steve Rondeau]

I want to import data for consumable assets using the Import Sets.  The Form references fields from other tables, ie Model.Display Name

The Display Name, in my case, is unique to each record.  I want to import the Consumables in but the Display Name does not appear in the Form when I import into the Consumables table.  I did upload the Model and Model Category into their respective tables.  There are too many records to correct each one individually.  

I'm missing something with the references, I believe as part of the import.  Can someone assist?

[Erik Gardner1 · Accepted solution]

Hi srondeau,

Your data source for your import will have an Transform Map connected to it. In the Transform Map there will be a Field Map for the Display Name, i.e. a record mapping your source data source field to the target field in the table you're importing to.

If you open the Field Map for Display Name you'll notice a field called Choice Action. The three options are create, ignore and reject. These choices decide on what to do if you source data for the field does not exist in the referenced table. I.e. should the import create a new record in the referenced table (create), ignore setting the field if the record can't be matched (ignore) but still importing the rest of the record or reject the import row all together if it can't find a reference match. 

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/script/server-scripting/task/t_CreatingAFieldMap.html

Hope that helps!

[Steve Rondeau]

I found the Display name and the Model Category had to be the same.  Once I made those equal, that worked