MEMOEXP

Our System Center Memo

SCSM Import Incident Classification Categories

Importing Incident Classification is important, but out of the box we cannot do such import through the CSV file if the Classification has multiple tiers. In this blog, I will show you how to import Incident Classifications with multiple tiers.

Before I begin, let me say that this is not my work. I got the solution on this blog and just made more elaborations here. Now lets begin.

First download the Excel file (EnumCreator.xlsx)

1. When you open up your Excel Sheet, these 3 fields marked with a X are fields where you need to modify. In this case for me, I put this.

Management Pack ID: Incident.Classification.1 (Key in whatever you want, but only alphanumeric characters or periods are allowed. No spaces.

Management Pack Version: 7.0.6555.115 (To get your version, launch SCSM console, under help, click “About Microsoft System Center Service Manager”. Look at the Product version, that is supposed to be your Management Pack Version.

Management Pack Name: Incident Classification 1 (Key in whatever you want)

image 

 

2. Refer to the Excel file on how you’re going to structure your data. I think it’s pretty easy to get the idea, but hard for me to explain it here. There are some extra things I’d like to highlight though. Notice the IncidentClassificationEnum under the Root Level (if from another MP) column? You must have this there for every new root classification.

image

 

3. If you’re using the Excel I gave you, noticed that at row 220, there is an entry at Column A called
IncidentResolutionCategoryEnum? Refer to Step 2. Replace IncidentClassificationEnum with IncidentResolutionCategoryEnum if you’re trying to import Incident Resolution (The dropdown that Analyst gets to choose when resolving an Incident).

image

 

3. After you’re done structuring your data, notice that there is a big green column above? Copy the contents in that column and paste them in a notepad file, then save it as an XML file. The file name must be the same as your Management Pack ID (We keyed that in step 1), in this scenario the file name should be Incident.Classification.1.xml

image

 

4. Next, launch your SCSM Console, under Administration > Management Packs, click Import.

image

 

5. Browse to the XML file you created earlier

image

 

6. Click Import

image

 

7. We see that the Management Pack is imported successfully. Click Ok.

image

 

8. Open up your Incident screen, go to the Classification Category, and there we go! The classifications are all there in the format we want.

image

 

Possible Errors

 

A) If you encounter the error below, it is because your Management Pack ID that you keyed in at your Excel file is not the same as your file name. Refer back to Step 3 above.

image

 

B) If you encounter the error below, it is because your excel sheet has way too many entries and it couldn’t finish copying everything from the green bar into the XML file. Personally I’ve tried a little over 100 entries and it worked. If you have more, continue in a separate MP import.

image

 

C) If you get the error below, it is because your data structure in the Excel sheet is not in the right format. Use my Excel sheet again as reference and structure it properly.

image

 

D) If you get the error below, it is because the IncidentClassificationEnum isn’t where it’s supposed to be. Refer back to Step 2 above.

image

Note!

With this solution you’re actually importing Management Packs. Make sure you do not delete those MPs in the future.

That should cover most of it. If you still face other problems, let me know and I’ll assist you.

Advertisements

November 17, 2011 - Posted by | System Center Service Manager (SCSM)

4 Comments »

  1. Will this work for 2012 as well?

    Comment by Python | May 31, 2012 | Reply

    • Yeap it will.

      Comment by James | June 23, 2013 | Reply

  2. Im getting this error “A BOX” unexpected token. The expected token is ‘=’ Line 6, Position 1

    Its not a “A BOX” its actually a symbol of a box. I checked the code at line 6 and I can’t find anything.

    Comment by Joseph Camaci | April 16, 2014 | Reply


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: