How to Import Configuration Items from a CSV File

Applies To: System Center Service Manager 2010 SP1

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 (https://go.microsoft.com/fwlink/?LinkId=181443). 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 number next to Items saved, Instances created in memory, and Instances committed to database are equal the number of rows in the data file, and then click Close.

Windows PowerShellYou 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 (https://go.microsoft.com/fwlink/?LinkId=203112).

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.

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.