Bulk Asset upload

[manirul]

Hi Team,

I am trying to upload bulk assets in servicenow and its working as well. I have downloaded the hardware asset excel template(alm_hardware.xls) for asset import. But I dont see "Model","Model Category" in the column   list of the downloaded template. Though I could   upload bulk assets without these two fields (even if the fields are mandatory) but I need to   show these fields anyway. How can I get template with these required fields so that I could upload bulk assets with proper relationship with Model.

Thanks

Manirul

[manirul]

HI Deepa,

Here are the models. These are present in Hardware models.

but not sure about the cmdb_model table.

Thanks

Manirul

[Deepa Srivastav]

But I dont see "Model","Model Category" in the column   list of the downloaded template--Its because these columns were not present in the list view...add from gear box and then if you export you will get those columns too...

Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.

Thanks,
Deepa

[manirul]

Hi Deepa,

As Mike suggested, I could download custom template with the following columns:-

But the issue is regarding the referential fields 'Model' and 'Model Category'. I am getting error message when trying   to upload

As you can see the Models are present in the Hardware Models:-

I tried with using other existing models too not just the above two models, but I get the same error. There must be some other way to add these referential fields.

Thanks

Manirul

[Mike Allen]

Show us a screenshot of the model field map in your transform map.

[manirul]

Hi Mike,

Here are the import maps I can see. I have checked the one which is being user for hardware asset upload.

I dont see any import map for model and all.Do I need to create import map for Model too. Please tell me the procedure,I am very new to Servicenow.

Thanks

Manirul