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]

Hi ,

I think I figured it out. This is happening because the columns name should be same as label...but the sheet you downloaded has back end name...please change that and check, it should solve your issue...I uploaded below file and it uploaded successfully...

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

Thanks,
Deepa

[manirul]

Hi Deepa,

Here are the scenario what I am seeing till now.

Scenario 1:-

Excel sheet with dummy data which you provided for upload. I tried to upload this.

After uploading the excel I am seeing the below screen. The error says:- "Model, a record with same reference name already exists in the table"

Scenario: 2

So I thought there must be some issues with the models. So I used some different models as you can see (Note:- These models are already there in the system. I did not create any new model)

Now when I tried to upload this new excel I saw the below screen which says:- "The following fields have been ignored,because they don't exist on the destination table:Model,Model Category"

I still completed the import and I saw the assets are imported like this

So I further delve down to analyze the issue. As I could understand, here is the transform map u_imp_tmpl_alm_hardware which is being used to upload asset in the real table alm_hardware

Details of the   table transform map u_imp_tmpl_alm_hardware

Here is the Mapping Assist screenshot .I could not find out Model and Model Category is Mapped with any source fields.

Here is the complete list of mapping for reference:-

Data Viewer

---

Show

Imp Tmpl Alm Hardware Viewing: Field Value Cost center Installed Acquisition method Checked out Asset tag test3 Assigned Depreciation Beneficiary Ordered Serial number Scheduled retirement Order received Cost Support group Department Assigned to Due in Justification Purchased Retired date Depreciation effective date Comments Salvage value Substate Vendor Parent Checked in Managed by Owned by Company Stockroom Invoice number GL account State PO number Due Warranty expiration Lease contract Reserved for Request line Location Resale price Supported by Disposal reason

Hardware Viewing: Field Value Cost center IT Installed 2013-11-20 23:00:00 Acquisition method Checked out Asset tag P1000479 Assigned 2014-04-21 00:00:00 Depreciation SL 5 Years Beneficiary Ordered 2013-09-15 00:00:00 Serial number BQP-854-D33246-GH Scheduled retirement Order received 2013-10-09 00:00:00 Cost $1,799.99 Support group Department IT Assigned to Miranda Hammitt Due in Justification Purchased 2013-09-28 Retired date Depreciation effective date 2013-11-21 23:00:00 Comments Salvage value $0.00 Substate Vendor Apple Parent Checked in Managed by Owned by Company ACME China Stockroom Invoice number GL account State In use PO number PO100004 Due Warranty expiration 2016-11-20 Lease contract Reserved for Request line Location 2500 West Daming Road, Shanghai Resale price $0.00 Supported by Disposal reason

Please let me know if anything need to be added in transform map or any important point I am missing.Please help me to get rid of this issue.

Thanks

Manirul

[Deepa Srivastav]

Hi Manirul ,

Instead of using the existing transform map you can create your own with the fields you want to upload, that would be easy ... else map model and model category from source table to target table ... You can try with just few fields...just keep the column headers same as in list view and then you don't need to manual map each field, you can click 'Auto map matching fields'..

Don't forget to mark all the posts helpful/like which were helpful to you

Thanks,

Deepa

[manirul]

Hi Deepa,

I was creating a new transform map but it was asking for a Source Table as you can see in the screenshot   and I used the same table u_imp_tmpl_alm_hardware (not many tables available in the drop down) which was being used by the last transform map which we were using.

but this source table Imp Tmpl Alm Hardware[u_imp_tmpl_alm_hardware] does not contain   any field like Model or Model Category whereas these fields are present in target table. So I did not find any option to Map these target table fields with Source table.So unless and until these fields are mapped, how can we upload and transform the data.

If we look into the source fields of the Imp Tmpl Alm Hardware table   Model and Model Category is not available so cant be mapped with target. See Screenshot.

Could you please show me your transform map which you used to upload assets.There must be Model and Model category also present there and mapped with target table or some other way for mapping with target table.

Thanks

Manirul

[Deepa Srivastav · Accepted solution]

Follow the steps in the below link...i.e create new table.

I want to import data to new table by excel file

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

Thanks,
Deepa