How to Import Excel file record in CMDB table

[ramesh_r]

Hi 

I have excel date with 100 record for CMDB computer table , now i want to insert that all records in CMDB computertable if record is already exist means it should update with existing record.

please help me how to archive this 

[Harsh Vardhan]

you can use data source here..

file type would be "excel"

then create transform map to updated the record in target table. make sure you mark one coalesce while mapping the field. 

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/refere...

https://developer.servicenow.com/app.do#!/lp/new_to_servicenow/app_store_learnv2_importingdata_kings...

[ramesh_r]

Hi

i tried with importset using user record it is showing this below error log

[Harsh Vardhan]

because it has find the user that's why did not insert and given error

can you try with data source and set coalesce on one field to make sure that would be unique and do not insert duplicate record

[Apurva Malewad1]

Hi,

You can do this by using import sets.Import can be done using load data or data source but data source is reusable.

Create transform map and then then do field mapping manually by mapping assist related link or automatically by using auto map matching fields related link on transform map.

For updating the record if its existing you need to make the field you want to be updated as coalesce is true using field maps.

Then run the transform map and see the detail logs whether all rows are transformed successfully or not.

Please mark my answer as correct/helpful if it helps you to find the solution.

Thanks and Regards,

Apurva Malewadikar

www.DXSherpa.com