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

[Deepa Srivastav]

Check below for import sets:-

Importing Data Using Import Sets - ServiceNow Wiki

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

Thanks,
Deepa

[manirul]

Hi Deepa/Mike,

I went through the wiki. Its really helpful.

So do I need to create another import set for model for the above scenario? For that, what should be the target table for model and how can I use both the import set for a single upload. Please show me the easiest way so that I can upload the assets with just few basic fields (Among them few are referential fields). An example will help.

Thanks

Manirul

[Mike Allen]

If you click into your transform map, there you can tell it to ignore your reference fields.   In the large majority of use cases, you do not want it creating entries in you reference table.

[manirul]

Hi Mike,

In my case I need to upload bulk assets which eventually contain few reference fields. I should not be ignoring these mandatory fields , then there would be no point in uploading assets. I have worked on many other asset management tool there were option to add and validate the reference fields but very new to servicenow working less than a week.

This is how exactly I want to upload assets through bulk upload procedure. I have created these assets manually.

I have followed many documentation but I think ,I still am stuck.Please help me to achieve this.

Thanks

Manirul

[Community Alums]

Manirul,

If you have all the information you need in the source spreadsheet to create the Model, you can do this with two transform maps that you run in order, Model first and then the Asset. What this does is to ensure that the Model exists before the Asset is created. If the Model already exists, then the Asset will use the existing Model. Just be sure to properly identify the fields you want to use to "coalesce." These uniquely identify the Model or the Asset in the transform map so ServiceNow knows whether to merge or to create a new record.

Ben