Error Importing data through Excel template into Hardware Asset

[Luiz Lucena]

Hello friends,

I'm trying to import hardware asset data into the alm_hardware table, almost 2000 computers and monitors.
As always, I first created the Model for those that were not in the Product Model table first. Some of those models already exist in the instance.
However, when the import tool completes, I'm getting these message:

The model is there, unless if I'm missing something:

Any clues?

[Najmuddin Mohd]

Hello @Luiz Lucena ,

Another alternative would be to write Transform script, onBefore which would GlideRecord the Model table and search with the name and return the SysId, which would be mapped to the target field.

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

[Luiz Lucena · Accepted solution]

Hello @Najmuddin Mohd 

I figured out we need to do. 
The Excel file had the Model as, i.e.:, "Precision 3490".
But in fact, what needs to have is the Display Name as shown in the image below:

After updating the Excel file replacing all values with the correct Display Name for each model in the file, we're back to business.

Appreciate your input though.