TechNet
Table of contents
TOC
Collapse the table of content
Expand the table of content

How to Import Configuration Items from a CSV File

Bill Anderson|Last Updated: 8/22/2016

Applies To: System Center 2016 Technical Preview - Service Manager

Before you can import data from a comma-separated value (CSV) file, you have to create two files: a data file and a format file. For more information about how to create these files, see About Importing Data From Comma-Separated Files into Service Manager. You can use the following procedure to import the Newcomputers.csv file by using the Newcomputers.xml format file.

To import configuration items from a CSV file

  1. In the Service Manager console, click Administration.

  2. In the Administration pane, expand Administration, and then click Connectors.

  3. In the Tasks pane, click Import from CSV file.

  4. In the Import Instances from CSV File dialog box, do the following:

    1. Next to the XML format file box, click Browse, and then select the format file. For example, select Newcomputers.xml, and then click Open.

    2. Next to the Data file box, click Browse, and then select the data file. For example, select Newcomputers.csv, and then click Open.

  5. In the Import Instances from CSV File dialog box, click Import.

  6. In the Import Instances from CSV File dialog box, verify that the numbers next to Items saved, Instances created in memory, and Instances committed to database are equal to the number of rows in the data file, and then click Close.

You can use a Windows PowerShell command to complete this task. For information about how to use Windows PowerShell to import configuration items from a CSV file, see Import-SCSMInstance.

To validate the import of configuration items from a CSV file

  1. In the Service Manager console, click Configuration Items.

  2. In the Configuration Items pane, expand Configuration Items, expand Computers, and then click All Windows Computers.

  3. In the All Windows Computers pane, verify that the computers in the CSV file are listed.

© 2016 Microsoft