Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Tom Wheeler — Wed, 27 Feb 2013 16:08:19 GMT

I have a customer on a 2012 SP1 and I imported a load of lists using this tool which was really helpful.

However, I can't now add child items within the console. The problem appears to be that the console is trying to save the new Enum into the "Out the box" management pack (unsealed) and then reference my custom management pack (also unsealed) and we know that an unsealed mp cannot reference an unsealed mp.

So I tested by sealing my custom mp (just contains the MP from the EnumCreater) and then adding a new child Enum in the console and it stored it to the "out the box" mp without issue.

Am I missing a trick here? Is it just a given that if you use this tool you cannot add to it using the console?

Any help much appreciated!

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Travis Wright MSFT — Tue, 12 Feb 2013 23:51:27 GMT

@francky18 - You need to either remove the Parent="" attribute or you need to provide a value for the parent enumeration.

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

francky18 — Tue, 12 Feb 2013 10:27:43 GMT

I wanted to create a simple list which has been created in Custom_ManagmentPack. The name of the list is WIFILogonAccount.

I opened your excel file and remove all data. I've just entered MP IP, MP version, MP name and put 2 values in Level 1.

I copied the xml code and tried to import into scsm 2012 SP1.

<ID>WifiAccountList</ID>

</Identity>

<Name>Wifi Account List</Name>

</Manifest>

</EnumerationTypes>

</EntityTypes>

</TypeDefinitions>

</DisplayString>

</DisplayString>

<Name>Wifi Account List</Name>

</DisplayString>

</DisplayStrings>

</LanguagePack>

</LanguagePacks>

</ManagementPack>

I received an error code:

: XSD verification failed for the management pack. [Line: 9, Position: 3]

The element 'Manifest' has incomplete content. List of possible elements expected: 'References'.

So i added <References/> before </Manifest> but I received another error:

: XSD verification failed for the management pack. [Line: 15, Position: 73]

The 'Parent' attribute is invalid - The value '' is invalid according to its datatype 'ManagementPackIdentifierReference' - The Pattern constraint failed.The Pattern constraint failed.

So can you help me to create a simple list in a cutom management pack ?

Thank you.

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Josh — Thu, 29 Nov 2012 16:47:28 GMT

I am having trouble using the tool to create a new list.

I downloaded and saved the tool. Then I took the following steps.

1. Changed MP ID - CustomCMFunctionalDeptList

2. Left MP version to 1.0.0.0

3. MP name - Custom CM Functional DeptList

4. Unprotected Sheet, and cleared the dependant MP info

5. cleared all data from the table

6. Added values for my new list starting at Level 1, populated level 1 and 2

And the MP output remained blank. But I found at the bottom of the EnumID and EnumParentID columns there is a dropdown, that if I select "none", it then populates the MP output cell.

So I copied the cell to notepad, saved as XML, "CustomCMFunctionalDeptList.xml" but when I try to import it I get the following error,

'(shows a small box here)'is an unexpected token. The expected token is '='. Line 6, position 1.

Any assistance would be appreciated, I really dont want to manually create this list. :)

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Christopher Mank — Fri, 06 Jul 2012 17:27:08 GMT

Hey Travis,

First off, kudos on the EnumCreator tool. It saves so much time in generating the XML for you.

Secondly, I had a suggestion for the tool. One thing I noticed was when I create a simple Level 1 list, the tool assigns the EnumerationValue ID by just adding “.Enum” to the end of the list item. I ran into an issue where I was generating multiple lists and the value “BE” came up twice. Since both list items were assigned the EnumerationValue ID of “BE.Enum”, the Authoring tool would error out and could no longer open the MP.

It would be cool to see the EnumCreator tool assign the EnumerationValue ID as it is described in your previous post (blogs.technet.com/.../understanding-lists-enumerationvalues-ci-status-example.aspx) where the EnumerationValue ID is given the name of the Parent plus the item. So my BE example from above would be “Business_Unit.BE.Enum” and “ISO_Country_Code.BE.Enum”.

Thanks!

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Travis Wright MSFT — Wed, 30 May 2012 23:48:35 GMT

@Chris - yes it should work with 2012 just fine.

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Chris — Wed, 30 May 2012 23:39:46 GMT

Will this work with the new 2012 product?

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Travis Wright MSFT — Sat, 04 Feb 2012 05:09:05 GMT

@Wyatt -

You don't *need* to use this approach to create enumeration values. This approach is useful when you need to create tens, hundreds, or maybe even up into the thousands of enums. Trying to that that in the UI would be very tedious and take a long time.

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

Wyatt Wong — Thu, 02 Feb 2012 06:15:02 GMT

Why do we need to create the list manually in XML ? I found the current UI already allows the creation of the tree like structure of "Coffee Machine" as in the above example in the Incident classification List ?

re: Create List Items (aka EnumerationValues) In Bulk Using EnumCreator.xlsx

RDurb — Tue, 10 Jan 2012 21:16:53 GMT

Awesome! Thanks for your prompt response :)