How to import external data into Hardware Asset

[Karl27]

Hi I have an asset register which is in Excel and i want to import this into Service-now. Can you advise what is the best way to do this and how this is completed, im new to this area of service-now.

I want to export all my current asset which are recorded in excel into the either the current service-now hardware asset. Any advice guidance would be appreciated.

Would i need to creat a new list of asset and then import ???

[arnoh]

Not just look at the assets, make sure the asset>ci mapping is the way you want it!

Think about what you want from the assets and what info from the assets you want transfered to the CI's and vice versa.

Besides that I would prefer to use this way: load data(your excel), make an import set > transform map(use auto mapping and map assist to match the source fields(your excel) to your target fields(alm_hardware table) and load it that way.

That way you make sure the mapping of the columns from your excel sheet is correct(don't forget to choose the coalesce)

[Karl27]

I want to create my own form to capture, i have the Hardware assets but want to create my own for what we capture. 

[Sergey12]

Hi Karl, why do you need a new form, please elaborate. Recommended way here - using import set -> transform map to upload your Excel inventory to ServiceNow.

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/import-sets/task/...

[Karl27]

I want my own fields and to build from scratch.

[arnoh]

In that case I would suggest make your own Asset module and your own Asset table and form. The way Asset management OOTB is linked with Config management is pretty awesome, but also pretty complicated.

But tbh, your original question has been answered. Best practice is: Use the ootb asset management module.