How to import external data into Hardware Asset
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2020 02:31 PM
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 ???
- Labels:
-
Service Desk

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2020 07:04 PM
Hey Karl,
I would do it from the list view as shown bellow
or
- Go to system import sets-->load data module
- Enter table name..chose file(.xls file)
- Make sure 1st row in excel match fields in your destination table.so it will automap.
- Then click on create transform link
- Give it a name, select destination table(table in which u want to upload data)
- Click on automap matching fields..if required fields do not match then click on mapping assist and match fields.
- Set coalesce true to anyone field from related list. it will be your unique field
- Click transform
Let me know if you have any other question!
Best,
Mokemal!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 07:08 AM
Great cheers i will take a look at this and feed back thanks so much for your prompt response.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-21-2020 04:27 AM
I have looked in to the import tool and can complete. What i would lie to do is add a new form in so i can determine all the new assets under a different heading, is there a way to create a new heading under portfolio which says Assets 2020 for example and create my own form to capture what is required??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-21-2020 04:46 AM
Hi karl,
What you want exactly.In snow there is already table is present to store asset(alm_hardware)so why you need to store asset in your own form?
Regards,
Monali