Microsoft System Center 2016 Service Manager Cookbook - Second Edition

Using a CSV file to import items into the CMDB

Sometimes you may want to bulk import configuration items into the CMDB. One way to do this is to import them using a Comma-Separated Value (CSV) file containing the CIs that relate to any class type or projection type already existing within Service Manager.

Getting ready

To import data using this method, two files are required, as follows:

• A file containing the CIs to be imported; structured in a comma-delimited method and saved with a .csv extension.
• A file that defines the class types or projection types used by all items in the CSV file. Also, this file defines the order in which the data appears as columns. The file must end with an .xml extension, and the authors recommend that you match the first ...