Importing assets not updating Category Model and description.

[jjones4773]

Importing the spreadsheet of assets does not import the Model Category or description.   Any reasons as to why?   Also, once imported, you can't go back and update those fields either.

Any information would be helpful.

Thanks.

Jason

[Pradeep Sharma]

Hi Jason,

Have you checked import logs?

Viewing the Import Log - ServiceNow Wiki

[jjones4773]

Pradeep,

The logs presented no errors or warnings.   However, the import tool displayed the following:

[Community Alums]

Jason,

The Model Category is a reference field, so it works a little differently on an import. For Assets, I recommend that you have values for the Model category in your import data that exactly match existing Model categories in ServiceNow. Model categories determine when to create a CI from imported asset, so you do not want to do this on the fly.

With this in mind, I have a couple suggestions:

• Verify your import data to ensure the value you are importing as Model category exactly matches an existing value.
• Set the Choice action (see Create a field map in the documentation for more details on this field) for the Model category field in the Transform Map to reject if the value does not exist. Rejected records will display in the import log. This ensures the Model category exists before you can import that record.

If you need a new Model category, create it manually prior to your import so you can define the appropriate CI Class and Asset Class before your import.

Model is also a reference field, but this is something you could create as part of the import. You could do this through a script, but I usually do this as part of a second Transform Map. You can apply the Model transform map first to ensure the Model exists when you import the asset. This is what we do in the Asset Management training course.

What do you mean by Description? Are you talking about the Display name? This is generated automatically based on the Asset tag and Model.

Ben

[joeyfrease]

I'm having similar issues with Easy Import and referenced fields.   The Model and Model Category values, Display Names both, are not being used in an Import to create a new record.   The values in the non referenced fields are taking fine, Asset tag, Serial Number etc.

Here's my situation.

Instance : Istanbul

Role : admin

Target Table : alm_hardware

Easy Import action , ie create new alm_hardware

NO updates to underlying transform map

Using XLS template NOT XLSX template for following reason:

        Had to create system property to get around the issue with xlsx Import templates being corrupt.   See HI response below.

        ServiceNow KB: Trying to create an xlsx format template fails for tables containing a curre...

Using display name copied straight from SN HW model table.

Using model category tied to HW Model , singular value, only Computer.

Import is "successful" , no error in log indicating an un ref'd HW Model

        (worth noting that when I used the sys_id of the model or the Name it did give me the error saying un ref'd model value).

Issue 1 - Preview data shows NO Model and Model Category in the temp import set.   The fields were created however they were empty.

Issue 2 - During preview data I add the values that were in the template into the temp import set.   Click Complete Import and yet still no Model and Model Category in the resulting new alm_hardware record.

issue 3 - Previous to 1 and 2 taking place I saw that the Model and Model Category fields from the Import template were NOT created in the temp import set.   But this didn't happen again...

Thank you,

Any help is greatly appreciated