CSV Import of Objects

Sometimes it is necessary to import a bunch of objects at the same time, for instance when you create a new custom class for managing objects that only live in Service Manager and cannot be imported by using connectors. For this case the CSV-Import is exactly what you are looking for. The process is straightforward.

For a successful Import-Process you need two files. The first file contains the data that needs to be imported, the second file contains the data structure of the data file. In this example I’m going to import some Software-Objects that should be instantiated. I want to import values for the following attributes:

  • Product Name
  • Display Name
  • Publisher
  • Version
  • Locale ID
  • Is Virtual Application (true/false)

First, I create the data file that uses comma-separated values.

clip_image002

Then, an XML file must be created that holds the exact Identifiers of the needed properties. If you are unsure what the exact names are, you can easily verify those by using the Authoring Tool. Just start the tool and switch to the Class Browser. Search for “Software Items”.

clip_image004

If you show the details of the class and the attributes, you can see the ID or Internal Name.

clip_image006

The XML file then looks something like this. The Class-ID in this example is “System.SoftwareItem” and the different attribute-IDs are listed in the correct order (compared to the Data file).

clip_image008

Now it’s time to start the Import Process. This is done by using the Service Manager Console. In the “Administration”-Section you have to start the “Import from CSV file”-Task and specify the correct path to the two files.

clip_image010

clip_image012

After a successful Import, the new objects should be visible in the appropriate configuration items view.

clip_image014

Successful Importing!
Regards Marcel

About Marcel Zehner

Microsoft Azure MVP
This entry was posted in SCSM and tagged , , . Bookmark the permalink.

9 Responses to CSV Import of Objects

  1. Pingback: System Center Service Manager information(blog) overview - System Center Service Manager

  2. Pingback: CSV-Import of Objects using Type Projections | SCSMfaq.ch

  3. Pingback: System Center Service Manager information(blog) overview … | The People Search System

  4. Mario Gil says:

    Good day, I wonder if the same to import categories and subcategories of incidents, thks.

  5. Mario Gil says:

    Thks for this helpful tool, Im asking it works for SCSM 2010 sp1, thks a lot.

  6. Pingback: SCSM: Using multiple key properties in classes | marcelzehner.ch

  7. Usman says:

    anyone have a example or help me in creating a runbook to bulk import AD user accounts details from XML/CSV file into system center Orchestrator, which will create AD accounts, put them in groups and then create their exchange mail accounts.

    Thank you
    Usman

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s