Announcing the Global SNUG Board of Directors. Learn more here
on 05-16-2018 05:27 AM
CMDB
How to import data? Como importar dados?
01. >> System Import Sets > Load data
https://<instance>.service-now.com/nav_to.do?uri=/create_import_set.do
01.A Type Label:: Will be create a table
01.B Select you file: Your Excel file name
01.C Type Sheet number:: The number of sheet what you'll work in at
01.D Type Header row::. The field names
02. Create Transformation Map
https://<intancename>.service-now.com/nav_to.do?uri=/sys_transform_map.do%3Fsys_id%3D-1%26sysparm_stack%3Dsys_transform_map_list.do
>> System Import set > Create Transform Map
02.A. Type Nane
02.B Select Source Table
02.C Select Target Table
Hardware Model [cmdb_ci_computer]
02.D Save/Submit
03. Auto Map Matching Fields
Using this Excel attached, Service Now will generate your MAP for YOU.
04. Run Transform
>> System Import Sets > Run Transform
https://<intance>.service-now.com/nav_to.do?uri=/run_import.do
04.A Click on Transform Button
04.B Final Results, check your table.
Improving Configuration Item Data Quality
Best Practices for CMDB Data Integration
Thanks for sharing this.