A Data Connector import rule can be used to import CMDB locations from a data file. The following instructions describe how this can work. Note: The following instructions can be adapted by the customer to import other associated asset types as well, such as departments.
Part 1: Create a Data File
The customer will need to generate their own .CSV or Excel file that contains a list of the locations they wish to import. Depending on the data classes that are desired to be imported, this file's contents can be as simple as just having the location names, to having many fields. The following provides examples of two different .CSV files that can be used to import locations:
Basic data file
This example includes the column name of "Location Name" with two records to import that only include the location's names.
Complex data file
Location Name, Address, City, State, Zip, Location Manager
Los Angeles, 1000 Westwood Blvd, Los Angeles, CA, 90024, Jim Smith
New York, 100 Park Avenue South, New York, NY, 10003, Janet Davis
This example includes multiple column names with two records that have values for the columns.
Part 2: Create a Data Source
Part 3: Create an Import Rule
How to import data using a Data Connector Import Rule