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

[Mike Allen]

You can create your own template for this.   Just go to a list view, add the columns that you want to use, then export the list.   That will give you a template for re-importing data.

[manirul]

Hi Mike,

Thanks for quick reply.

I see some error when uploaded the assets.

Error Message:-"Model, a record with the same reference name already exists in the table"

I can understand Model and Model category both are reference fields and is probably not available in the destination table alm_hardware.So how can I input these fields when uploading bulk.    

I am using the following simple template for import:-

Thanks

Manirul

[Community Alums]

This error (Fields ignored because they don't exist in the target table) makes me think that when you tried to upload your spreadsheet, you tried to load the data into an existing import set table that did not have these fields. You would need to create a new table if you are working with a new template.

[Deepa Srivastav]

Is this model category present in the model category table and also is this model present in cmdb_model table?