Model field is empty after importing asset data

LeeC
Tera Contributor

Hello all.  I am extracting data from an old Flexera database and importing that data into a ServiceNow instance.  I'm using the template created from the Hardware Asset table (right-click on column header and select import to create import template).  There is a limited amount of asset data available from the Flexera database, so not many fields are populated in the import template.  The issue I am having is that when I then load the data from the template, the asset records are created, but the Model field is empty.  All other fields load correctly.  

I am attaching some screenshots that show (1) the "Computer" model category, (2)  a sample of a Hardware Model that's included in the template, and (3) the filled in import template to create 35 asset records.

Can anyone explain to me why the Model is not being filled in the asset record when I upload the import template?

Thanks!

1 ACCEPTED SOLUTION

MercBuilding
Giga Guru

Hi @LeeC ,

    Please make sure that models are present before importing the data. If the models are not present you need to create them before importing asset data since it is a reference field, the entry needs to be present in database first.

 

Hope this helps!

 

Thanks,

Sravanthi

View solution in original post

2 REPLIES 2

MercBuilding
Giga Guru

Hi @LeeC ,

    Please make sure that models are present before importing the data. If the models are not present you need to create them before importing asset data since it is a reference field, the entry needs to be present in database first.

 

Hope this helps!

 

Thanks,

Sravanthi

Thanks Sravanthi.  The Hardware Models are already set up and in the database, but the import didn't pick them up for some reason.

Lee