3 Quick Steps to import a Data Taxonomy into the Managed Metadata Service in SharePoint 2010

1. Open the Term Store Management Tool (Site Actions > Site Settings > Term Store Management) an download the sample import file. (Remember, Service Applications are configured on a per Web Application basis, so use any site collection inside a WebApp configured with your MMS.)

2. Insert your data. In the photo below, I demonstrate creating a term called USA. Under that, I create the term Alabama. Under that, 4 cities. Then under USA, a term called Alaska. The point is that the we have a hierarchy. Using the import file, we can go 7 layers deep.

3. Save the file, head back into the Term Store Management Tool, select/create a group, and Import the file.

 

 

Taxonomy Update Scheduler Timer Job

How SharePoint Updates listitems when the Managed Metadata changes.

First, be sure to have configured a Managed Metadata Service and have a termset to use.
Second, go to a site collection and configure a Managed Metedata field to use that termset. 

Create a list item and assign it a value for the Managed Metedata field. Take note of the value.

Now locate the Timer Jobs in Central Admin > Monitoring. Scroll down or page over to the Taxonomy Update Scheduler jobs.  I disabled all of the Taxonomy jobs for this demo.

Here are a list of my Web Applications. You can see how each Web App (image below) has a Taxonomy Update Scheduler job (image above) assigned to it.

Now go into your Term Store Management Tool (via /_layouts/termstoremanager.aspx”>http://<siteurl>/_layouts/termstoremanager.aspx ) and update the value.

The original value was Houston.

The updated value is Houston, Tejas.

Back on the site, it still shows the old value, Houston.

If we go into Central Administration and open up the Taxonomy Update Scheduler job, we can Enable it. Then we can Run Now.

After a few seconds, the Taxonomy Update Scheduler Timer Job will have completed. And after F5’ing our list view, we’ll see the updated value.

 

So that’s how changes to the MMS are pushed down to content.

How Managed Metadata is stored in SharePoint Lists

I hope this post will help explain how Managed Metadata is actually stored in a list. 

Background:
I’ve created a Team Site (can be any template of course) on my demo portal.
I’ve created a Managed Metadata Service in Central Admin.
I’ve wired up my demo portal Web App and my MMS Service App.
I’ve imported a Country-State-City taxonomy termset.
I’ve created a custom list (CustomListA) in my demo portal.
I’ve added a Managed Metadata field to my list and configured it to use my Country-State-City taxonomy termset.
I’ve added two items to my CustomListA. And I’ve chosen USA:Alabama:Huntsville as my item locatoin for each item.

I’ve used PowerShell to dump out my CustomListA xml.

Let’s take a look at how the data is stored. First, you can easily see the ows_Location field pointing to “12;Hunstville”. The 12 comes from the fact that Huntsville is the 12th Managed Metadata term to be used in my Site Collection.  If I had only used 3 others, then Huntsville would be #4. I think you get the idea here. Note: I’m not sure why it needs to keep the 12 when another attribute contains the GUID — notice the 63371559-… after the Huntsville in ows_LocationTaxHTField0 field [Line 7]. But it is what it is.

CustomListA XML

1. <CustomListAFields>
2.   <ListItem>
3.     <z:row xmlns:z='#RowsetSchema'
4.            ows_ContentTypeId='0x01001B1AE705BDC0FB4F9E1DE03E7C4F2992'
5.            ows_Title='Site 1'
6.            ows_Location='12;#Huntsville'
7.            ows_LocationTaxHTField0='Huntsville|63371559-6ee4-448d-98d0-87aa7c4ae33d'
8.            ows_TaxCatchAll='12;#WQlE/jb3u0Gdew5ZdadXKg==|sg6uKdhnQU6vAn+KMeAQxw==|WRU3Y+RujUSY0IeqfErjPQ==|XYdm4SHNWES3uru6HR32fQ==|xuZlxQcStEyuCl+tHnhudQ=='
9.            ows_ID='1'
10.            ows_ContentType='Item'
11.            ows_Modified='2010-05-25 22:14:31'
12.            ows_Created='2010-05-25 22:14:31'
13.            ows_Author='1;#David Frette'
14.            ows_Editor='1;#David Frette'
15.            ows_owshiddenversion='1'
16.            ows_WorkflowVersion='1'
17.            ows__UIVersion='512'
18.            ows__UIVersionString='1.0'
19.            ows_Attachments='0'
20.            ows__ModerationStatus='0'
21.            ows_LinkTitleNoMenu='Site 1'
22.            ows_LinkTitle='Site 1'
23.            ows_LinkTitle2='Site 1'
24.            ows_SelectTitle='1'
25.            ows_Order='100.000000000000'
26.            ows_GUID='{992B4314-F428-4623-9368-0D43F52A625C}'
27.            ows_FileRef='1;#sites/mms/Lists/CustomListA/1_.000'
28.            ows_FileDirRef='1;#sites/mms/Lists/CustomListA'
29.            ows_Last_x0020_Modified='1;#2010-05-25 22:14:31'
30.            ows_Created_x0020_Date='1;#2010-05-25 22:14:31'
31.            ows_FSObjType='1;#0'
32.            ows_SortBehavior='1;#0'
33.            ows_PermMask='0x7fffffffffffffff'
34.            ows_FileLeafRef='1;#1_.000'
35.            ows_UniqueId='1;#{4C383449-5A37-4A51-BA63-4F47CAD3C6FB}'
36.            ows_ProgId='1;#'
37.            ows_ScopeId='1;#{F61E9569-BFBD-401B-AD98-AAADBB87AA9C}'
38.            ows__EditMenuTableStart='1_.000'
39.            ows__EditMenuTableStart2='1'
40.            ows__EditMenuTableEnd='1'
41.            ows_LinkFilenameNoMenu='1_.000'
42.            ows_LinkFilename='1_.000'
43.            ows_LinkFilename2='1_.000'
44.            ows_ServerUrl='/sites/mms/Lists/CustomListA/1_.000'
45.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/CustomListA/1_.000'
46.            ows_BaseName='1_'
47.            ows_MetaInfo='1;#'
48.            ows__Level='1'
49.            ows__IsCurrentVersion='1'
50.            ows_ItemChildCount='1;#0'
51.            ows_FolderChildCount='1;#0'
52.            ows_ServerRedirected='0' />
53.  
54.   </ListItem>
55.   <ListItem>
56.     <z:row xmlns:z='#RowsetSchema'
57.            ows_ContentTypeId='0x01001B1AE705BDC0FB4F9E1DE03E7C4F2992'
58.            ows_Title='another one'
59.            ows_Location='12;#Huntsville'
60.            ows_LocationTaxHTField0='Huntsville|63371559-6ee4-448d-98d0-87aa7c4ae33d'
61.            ows_TaxCatchAll='12;#WQlE/jb3u0Gdew5ZdadXKg==|sg6uKdhnQU6vAn+KMeAQxw==|WRU3Y+RujUSY0IeqfErjPQ==|XYdm4SHNWES3uru6HR32fQ==|xuZlxQcStEyuCl+tHnhudQ=='
62.            ows_ID='2'
63.            ows_ContentType='Item'
64.            ows_Modified='2010-05-26 00:06:32'
65.            ows_Created='2010-05-26 00:06:32'
66.            ows_Author='1;#David Frette'
67.            ows_Editor='1;#David Frette'
68.            ows_owshiddenversion='1'
69.            ows_WorkflowVersion='1'
70.            ows__UIVersion='512'
71.            ows__UIVersionString='1.0'
72.            ows_Attachments='0'
73.            ows__ModerationStatus='0'
74.            ows_LinkTitleNoMenu='another one'
75.            ows_LinkTitle='another one'
76.            ows_LinkTitle2='another one'
77.            ows_SelectTitle='2'
78.            ows_Order='200.000000000000'
79.            ows_GUID='{69B111F7-EA95-4FF2-990D-DC7290F95FC1}'
80.            ows_FileRef='2;#sites/mms/Lists/CustomListA/2_.000'
81.            ows_FileDirRef='2;#sites/mms/Lists/CustomListA'
82.            ows_Last_x0020_Modified='2;#2010-05-26 00:06:32'
83.            ows_Created_x0020_Date='2;#2010-05-26 00:06:32'
84.            ows_FSObjType='2;#0'
85.            ows_SortBehavior='2;#0'
86.            ows_PermMask='0x7fffffffffffffff'
87.            ows_FileLeafRef='2;#2_.000'
88.            ows_UniqueId='2;#{8D5A46F4-A795-4BEB-81FE-942313BE746F}'
89.            ows_ProgId='2;#'
90.            ows_ScopeId='2;#{F61E9569-BFBD-401B-AD98-AAADBB87AA9C}'
91.            ows__EditMenuTableStart='2_.000'
92.            ows__EditMenuTableStart2='2'
93.            ows__EditMenuTableEnd='2'
94.            ows_LinkFilenameNoMenu='2_.000'
95.            ows_LinkFilename='2_.000'
96.            ows_LinkFilename2='2_.000'
97.            ows_ServerUrl='/sites/mms/Lists/CustomListA/2_.000'
98.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/CustomListA/2_.000'
99.            ows_BaseName='2_'
100.            ows_MetaInfo='2;#'
101.            ows__Level='1'
102.            ows__IsCurrentVersion='1'
103.            ows_ItemChildCount='2;#0'
104.            ows_FolderChildCount='2;#0'
105.            ows_ServerRedirected='0' />
106.  
107.   </ListItem>
108. </CustomListAFields>

 

After looking over the CustomListA XML file, I then used PowerShell to render my TaxonomyHiddenList. This list is what ties all other lists in it’s site collection to the Managed Metadata Service or TermStore. If you scroll down to line 656, you’ll see ows_IdForTerm=63371559… This is the same value in Line 7 of the CustomListA xml file. This GUID is our link.

TaxonomyHiddenList XML

1. <TaxonomyHiddenListFields>
2.   <ListItem>
3.     <z:row xmlns:z='#RowsetSchema'
4.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
5.            ows_Title='Term2'
6.            ows_IdForTermStore='d7156946-9c3b-4754-bc23-36bc20fc5035'
7.            ows_IdForTerm='f3f00912-c071-4144-b2f9-314d44446a35'
8.            ows_IdForTermSet='a6f56b31-e330-43a7-b1d3-2cf7acab3fb4'
9.            ows_Term='Term2'
10.            ows_Path='Term2'
11.            ows_CatchAllData='RmkV1zucVEe8Iza8IPxQNQ==|MWv1pjDjp0Ox0yz3rKs/tA==|Egnw83HAREGy+TFNRERqNQ=='
12.            ows_CatchAllDataLabel='Term2#Љ|'
13.            ows_Term1033='Term2'
14.            ows_Path1033='Term2'
15.            ows_ID='1'
16.            ows_ContentType='Item'
17.            ows_Modified='2010-05-01 17:50:11'
18.            ows_Created='2010-05-01 17:50:11'
19.            ows_Author='1073741823;#System Account'
20.            ows_Editor='1073741823;#System Account'
21.            ows_owshiddenversion='1'
22.            ows_WorkflowVersion='1'
23.            ows__UIVersion='512'
24.            ows__UIVersionString='1.0'
25.            ows_Attachments='0'
26.            ows__ModerationStatus='0'
27.            ows_LinkTitleNoMenu='Term2'
28.            ows_LinkTitle='Term2'
29.            ows_LinkTitle2='Term2'
30.            ows_SelectTitle='1'
31.            ows_Order='100.000000000000'
32.            ows_GUID='{79765B2E-E586-41CA-B72F-440B870CA25B}'
33.            ows_FileRef='1;#sites/mms/Lists/TaxonomyHiddenList/1_.000'
34.            ows_FileDirRef='1;#sites/mms/Lists/TaxonomyHiddenList'
35.            ows_Last_x0020_Modified='1;#2010-05-01 17:50:11'
36.            ows_Created_x0020_Date='1;#2010-05-01 17:50:11'
37.            ows_FSObjType='1;#0'
38.            ows_SortBehavior='1;#0'
39.            ows_PermMask='0x7fffffffffffffff'
40.            ows_FileLeafRef='1;#1_.000'
41.            ows_UniqueId='1;#{D6B76DAB-6E84-4182-9608-6973C51C97C4}'
42.            ows_ProgId='1;#'
43.            ows_ScopeId='1;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
44.            ows__EditMenuTableStart='1_.000'
45.            ows__EditMenuTableStart2='1'
46.            ows__EditMenuTableEnd='1'
47.            ows_LinkFilenameNoMenu='1_.000'
48.            ows_LinkFilename='1_.000'
49.            ows_LinkFilename2='1_.000'
50.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/1_.000'
51.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/1_.000'
52.            ows_BaseName='1_'
53.            ows_MetaInfo='1;#'
54.            ows__Level='1'
55.            ows__IsCurrentVersion='1'
56.            ows_ItemChildCount='1;#0'
57.            ows_FolderChildCount='1;#0'
58.            ows_ServerRedirected='0' />
59.  
60.   </ListItem>
61.   <ListItem>
62.     <z:row xmlns:z='#RowsetSchema'
63.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
64.            ows_Title='Fabian'
65.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
66.            ows_IdForTerm='91e3fdb8-a5a3-49f8-bdb7-da2e482a7f14'
67.            ows_IdForTermSet='66a8fb34-06c5-4c65-9e69-2af20b7a3d75'
68.            ows_Term='Fabian'
69.            ows_Path='Fabian'
70.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|NPuoZsUGZUyeaSryC3o9dQ==|uP3jkaOl+Em9t9ouSCp/FA=='
71.            ows_CatchAllDataLabel='Fabian#Љ|'
72.            ows_Term1033='Fabian'
73.            ows_Path1033='Fabian'
74.            ows_ID='2'
75.            ows_ContentType='Item'
76.            ows_Modified='2010-05-15 07:58:39'
77.            ows_Created='2010-05-15 07:58:39'
78.            ows_Author='1073741823;#System Account'
79.            ows_Editor='1073741823;#System Account'
80.            ows_owshiddenversion='1'
81.            ows_WorkflowVersion='1'
82.            ows__UIVersion='512'
83.            ows__UIVersionString='1.0'
84.            ows_Attachments='0'
85.            ows__ModerationStatus='0'
86.            ows_LinkTitleNoMenu='Fabian'
87.            ows_LinkTitle='Fabian'
88.            ows_LinkTitle2='Fabian'
89.            ows_SelectTitle='2'
90.            ows_Order='200.000000000000'
91.            ows_GUID='{86697A9E-9E62-4CCE-95DE-D38F1CD69D86}'
92.            ows_FileRef='2;#sites/mms/Lists/TaxonomyHiddenList/2_.000'
93.            ows_FileDirRef='2;#sites/mms/Lists/TaxonomyHiddenList'
94.            ows_Last_x0020_Modified='2;#2010-05-15 07:58:39'
95.            ows_Created_x0020_Date='2;#2010-05-15 07:58:39'
96.            ows_FSObjType='2;#0'
97.            ows_SortBehavior='2;#0'
98.            ows_PermMask='0x7fffffffffffffff'
99.            ows_FileLeafRef='2;#2_.000'
100.            ows_UniqueId='2;#{5E01C738-90CE-4C4A-85F6-52BE4770CB7C}'
101.            ows_ProgId='2;#'
102.            ows_ScopeId='2;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
103.            ows__EditMenuTableStart='2_.000'
104.            ows__EditMenuTableStart2='2'
105.            ows__EditMenuTableEnd='2'
106.            ows_LinkFilenameNoMenu='2_.000'
107.            ows_LinkFilename='2_.000'
108.            ows_LinkFilename2='2_.000'
109.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/2_.000'
110.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/2_.000'
111.            ows_BaseName='2_'
112.            ows_MetaInfo='2;#'
113.            ows__Level='1'
114.            ows__IsCurrentVersion='1'
115.            ows_ItemChildCount='2;#0'
116.            ows_FolderChildCount='2;#0'
117.            ows_ServerRedirected='0' />
118.  
119.   </ListItem>
120.   <ListItem>
121.     <z:row xmlns:z='#RowsetSchema'
122.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
123.            ows_Title='Dave'
124.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
125.            ows_IdForTerm='1a16f24f-0b46-4a7b-90d4-7f7f7e5aa25a'
126.            ows_IdForTermSet='66a8fb34-06c5-4c65-9e69-2af20b7a3d75'
127.            ows_Term='Dave'
128.            ows_Path='Dave'
129.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|NPuoZsUGZUyeaSryC3o9dQ==|T/IWGkYLe0qQ1H9/flqiWg=='
130.            ows_CatchAllDataLabel='Dave#Љ|'
131.            ows_Term1033='Dave'
132.            ows_Path1033='Dave'
133.            ows_ID='3'
134.            ows_ContentType='Item'
135.            ows_Modified='2010-05-25 12:58:54'
136.            ows_Created='2010-05-25 12:58:54'
137.            ows_Author='1073741823;#System Account'
138.            ows_Editor='1073741823;#System Account'
139.            ows_owshiddenversion='1'
140.            ows_WorkflowVersion='1'
141.            ows__UIVersion='512'
142.            ows__UIVersionString='1.0'
143.            ows_Attachments='0'
144.            ows__ModerationStatus='0'
145.            ows_LinkTitleNoMenu='Dave'
146.            ows_LinkTitle='Dave'
147.            ows_LinkTitle2='Dave'
148.            ows_SelectTitle='3'
149.            ows_Order='300.000000000000'
150.            ows_GUID='{B7A3DAAA-E457-4274-9391-1EDBF9CD7FEE}'
151.            ows_FileRef='3;#sites/mms/Lists/TaxonomyHiddenList/3_.000'
152.            ows_FileDirRef='3;#sites/mms/Lists/TaxonomyHiddenList'
153.            ows_Last_x0020_Modified='3;#2010-05-25 12:58:54'
154.            ows_Created_x0020_Date='3;#2010-05-25 12:58:54'
155.            ows_FSObjType='3;#0'
156.            ows_SortBehavior='3;#0'
157.            ows_PermMask='0x7fffffffffffffff'
158.            ows_FileLeafRef='3;#3_.000'
159.            ows_UniqueId='3;#{98B9AEC6-AAC9-46A0-9D72-4AC06A19FA0C}'
160.            ows_ProgId='3;#'
161.            ows_ScopeId='3;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
162.            ows__EditMenuTableStart='3_.000'
163.            ows__EditMenuTableStart2='3'
164.            ows__EditMenuTableEnd='3'
165.            ows_LinkFilenameNoMenu='3_.000'
166.            ows_LinkFilename='3_.000'
167.            ows_LinkFilename2='3_.000'
168.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/3_.000'
169.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/3_.000'
170.            ows_BaseName='3_'
171.            ows_MetaInfo='3;#'
172.            ows__Level='1'
173.            ows__IsCurrentVersion='1'
174.            ows_ItemChildCount='3;#0'
175.            ows_FolderChildCount='3;#0'
176.            ows_ServerRedirected='0' />
177.  
178.   </ListItem>
179.   <ListItem>
180.     <z:row xmlns:z='#RowsetSchema'
181.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
182.            ows_Title='Texas'
183.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
184.            ows_IdForTerm='5032c2ac-fb46-4062-beba-1305d7900f39'
185.            ows_IdForTermSet='ad00c221-2c15-4574-ad59-b179514b2605'
186.            ows_Term='Texas'
187.            ows_Path='USA:Texas'
188.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|IcIArRUsdEWtWbF5UUsmBQ==|rMIyUEb7YkC+uhMF15APOQ==|adQwYw3D7Uyz94D4wfhaOg=='
189.            ows_CatchAllDataLabel='Texas#Љ|'
190.            ows_Term1033='Texas'
191.            ows_Path1033='USA:Texas'
192.            ows_ID='4'
193.            ows_ContentType='Item'
194.            ows_Modified='2010-05-25 14:45:53'
195.            ows_Created='2010-05-25 14:45:53'
196.            ows_Author='1073741823;#System Account'
197.            ows_Editor='1073741823;#System Account'
198.            ows_owshiddenversion='1'
199.            ows_WorkflowVersion='1'
200.            ows__UIVersion='512'
201.            ows__UIVersionString='1.0'
202.            ows_Attachments='0'
203.            ows__ModerationStatus='0'
204.            ows_LinkTitleNoMenu='Texas'
205.            ows_LinkTitle='Texas'
206.            ows_LinkTitle2='Texas'
207.            ows_SelectTitle='4'
208.            ows_Order='400.000000000000'
209.            ows_GUID='{FFAE7EDC-BC71-4D1A-80A0-5E5AC019FAF9}'
210.            ows_FileRef='4;#sites/mms/Lists/TaxonomyHiddenList/4_.000'
211.            ows_FileDirRef='4;#sites/mms/Lists/TaxonomyHiddenList'
212.            ows_Last_x0020_Modified='4;#2010-05-25 14:45:53'
213.            ows_Created_x0020_Date='4;#2010-05-25 14:45:53'
214.            ows_FSObjType='4;#0'
215.            ows_SortBehavior='4;#0'
216.            ows_PermMask='0x7fffffffffffffff'
217.            ows_FileLeafRef='4;#4_.000'
218.            ows_UniqueId='4;#{5956CC93-FDA8-420B-B285-BE1A6B3D80C7}'
219.            ows_ProgId='4;#'
220.            ows_ScopeId='4;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
221.            ows__EditMenuTableStart='4_.000'
222.            ows__EditMenuTableStart2='4'
223.            ows__EditMenuTableEnd='4'
224.            ows_LinkFilenameNoMenu='4_.000'
225.            ows_LinkFilename='4_.000'
226.            ows_LinkFilename2='4_.000'
227.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/4_.000'
228.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/4_.000'
229.            ows_BaseName='4_'
230.            ows_MetaInfo='4;#'
231.            ows__Level='1'
232.            ows__IsCurrentVersion='1'
233.            ows_ItemChildCount='4;#0'
234.            ows_FolderChildCount='4;#0'
235.            ows_ServerRedirected='0' />
236.  
237.   </ListItem>
238.   <ListItem>
239.     <z:row xmlns:z='#RowsetSchema'
240.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
241.            ows_Title='Houston'
242.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
243.            ows_IdForTerm='0ad854d5-dd7d-4819-8aae-4dab0a7e313f'
244.            ows_IdForTermSet='ad00c221-2c15-4574-ad59-b179514b2605'
245.            ows_Term='Houston'
246.            ows_Path='USA:Texas:Houston'
247.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|IcIArRUsdEWtWbF5UUsmBQ==|1VTYCn3dGUiKrk2rCn4xPw==|rMIyUEb7YkC+uhMF15APOQ==|adQwYw3D7Uyz94D4wfhaOg=='
248.            ows_CatchAllDataLabel='Houston#Љ|'
249.            ows_Term1033='Houston'
250.            ows_Path1033='USA:Texas:Houston'
251.            ows_ID='5'
252.            ows_ContentType='Item'
253.            ows_Modified='2010-05-25 14:50:00'
254.            ows_Created='2010-05-25 14:50:00'
255.            ows_Author='1073741823;#System Account'
256.            ows_Editor='1073741823;#System Account'
257.            ows_owshiddenversion='1'
258.            ows_WorkflowVersion='1'
259.            ows__UIVersion='512'
260.            ows__UIVersionString='1.0'
261.            ows_Attachments='0'
262.            ows__ModerationStatus='0'
263.            ows_LinkTitleNoMenu='Houston'
264.            ows_LinkTitle='Houston'
265.            ows_LinkTitle2='Houston'
266.            ows_SelectTitle='5'
267.            ows_Order='500.000000000000'
268.            ows_GUID='{3C1F6E39-94C8-44AF-9D33-6C292671CEC1}'
269.            ows_FileRef='5;#sites/mms/Lists/TaxonomyHiddenList/5_.000'
270.            ows_FileDirRef='5;#sites/mms/Lists/TaxonomyHiddenList'
271.            ows_Last_x0020_Modified='5;#2010-05-25 14:50:00'
272.            ows_Created_x0020_Date='5;#2010-05-25 14:50:00'
273.            ows_FSObjType='5;#0'
274.            ows_SortBehavior='5;#0'
275.            ows_PermMask='0x7fffffffffffffff'
276.            ows_FileLeafRef='5;#5_.000'
277.            ows_UniqueId='5;#{4A4106AA-B005-42BA-A44F-DC2035BD1E64}'
278.            ows_ProgId='5;#'
279.            ows_ScopeId='5;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
280.            ows__EditMenuTableStart='5_.000'
281.            ows__EditMenuTableStart2='5'
282.            ows__EditMenuTableEnd='5'
283.            ows_LinkFilenameNoMenu='5_.000'
284.            ows_LinkFilename='5_.000'
285.            ows_LinkFilename2='5_.000'
286.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/5_.000'
287.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/5_.000'
288.            ows_BaseName='5_'
289.            ows_MetaInfo='5;#'
290.            ows__Level='1'
291.            ows__IsCurrentVersion='1'
292.            ows_ItemChildCount='5;#0'
293.            ows_FolderChildCount='5;#0'
294.            ows_ServerRedirected='0' />
295.  
296.   </ListItem>
297.   <ListItem>
298.     <z:row xmlns:z='#RowsetSchema'
299.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
300.            ows_Title='Tejas'
301.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
302.            ows_IdForTerm='a99fec52-dc77-4fb8-b547-e47740c3ffa5'
303.            ows_IdForTermSet='eff72cc2-64c0-4d71-87ac-af6aab9d0c1c'
304.            ows_Term='Tejas'
305.            ows_Path='Tejas'
306.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|wiz378BkcU2HrK9qq50MHA==|UuyfqXfcuE+1R+R3QMP/pQ=='
307.            ows_CatchAllDataLabel='Tejas#Љ|'
308.            ows_Term1033='Tejas'
309.            ows_Path1033='Tejas'
310.            ows_ID='6'
311.            ows_ContentType='Item'
312.            ows_Modified='2010-05-25 19:40:24'
313.            ows_Created='2010-05-25 18:58:43'
314.            ows_Author='1073741823;#System Account'
315.            ows_Editor='1073741823;#System Account'
316.            ows_owshiddenversion='2'
317.            ows_WorkflowVersion='1'
318.            ows__UIVersion='512'
319.            ows__UIVersionString='1.0'
320.            ows_Attachments='0'
321.            ows__ModerationStatus='0'
322.            ows_LinkTitleNoMenu='Tejas'
323.            ows_LinkTitle='Tejas'
324.            ows_LinkTitle2='Tejas'
325.            ows_SelectTitle='6'
326.            ows_Order='600.000000000000'
327.            ows_GUID='{928B6610-678A-4B25-9FAC-F17907C0725C}'
328.            ows_FileRef='6;#sites/mms/Lists/TaxonomyHiddenList/6_.000'
329.            ows_FileDirRef='6;#sites/mms/Lists/TaxonomyHiddenList'
330.            ows_Last_x0020_Modified='6;#2010-05-25 18:58:43'
331.            ows_Created_x0020_Date='6;#2010-05-25 18:58:43'
332.            ows_FSObjType='6;#0'
333.            ows_SortBehavior='6;#0'
334.            ows_PermMask='0x7fffffffffffffff'
335.            ows_FileLeafRef='6;#6_.000'
336.            ows_UniqueId='6;#{EBBC3F76-51C1-4FE5-BA23-C3BEED156D06}'
337.            ows_ProgId='6;#'
338.            ows_ScopeId='6;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
339.            ows__EditMenuTableStart='6_.000'
340.            ows__EditMenuTableStart2='6'
341.            ows__EditMenuTableEnd='6'
342.            ows_LinkFilenameNoMenu='6_.000'
343.            ows_LinkFilename='6_.000'
344.            ows_LinkFilename2='6_.000'
345.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/6_.000'
346.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/6_.000'
347.            ows_BaseName='6_'
348.            ows_MetaInfo='6;#'
349.            ows__Level='1'
350.            ows__IsCurrentVersion='1'
351.            ows_ItemChildCount='6;#0'
352.            ows_FolderChildCount='6;#0'
353.            ows_ServerRedirected='0' />
354.  
355.   </ListItem>
356.   <ListItem>
357.     <z:row xmlns:z='#RowsetSchema'
358.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
359.            ows_Title='Broncos'
360.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
361.            ows_IdForTerm='a11bba1e-cc52-4c84-926f-f3c74079d035'
362.            ows_IdForTermSet='eff72cc2-64c0-4d71-87ac-af6aab9d0c1c'
363.            ows_Term='Broncos'
364.            ows_Path='Broncos'
365.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|wiz378BkcU2HrK9qq50MHA==|HroboVLMhEySb/PHQHnQNQ=='
366.            ows_CatchAllDataLabel='Broncos#Љ|'
367.            ows_Term1033='Broncos'
368.            ows_Path1033='Broncos'
369.            ows_ID='7'
370.            ows_ContentType='Item'
371.            ows_Modified='2010-05-25 21:34:06'
372.            ows_Created='2010-05-25 19:00:41'
373.            ows_Author='1073741823;#System Account'
374.            ows_Editor='1073741823;#System Account'
375.            ows_owshiddenversion='3'
376.            ows_WorkflowVersion='1'
377.            ows__UIVersion='512'
378.            ows__UIVersionString='1.0'
379.            ows_Attachments='0'
380.            ows__ModerationStatus='0'
381.            ows_LinkTitleNoMenu='Broncos'
382.            ows_LinkTitle='Broncos'
383.            ows_LinkTitle2='Broncos'
384.            ows_SelectTitle='7'
385.            ows_Order='700.000000000000'
386.            ows_GUID='{0C8E5B78-BE8D-4C19-B993-E5A9B04B9564}'
387.            ows_FileRef='7;#sites/mms/Lists/TaxonomyHiddenList/7_.000'
388.            ows_FileDirRef='7;#sites/mms/Lists/TaxonomyHiddenList'
389.            ows_Last_x0020_Modified='7;#2010-05-25 19:00:41'
390.            ows_Created_x0020_Date='7;#2010-05-25 19:00:41'
391.            ows_FSObjType='7;#0'
392.            ows_SortBehavior='7;#0'
393.            ows_PermMask='0x7fffffffffffffff'
394.            ows_FileLeafRef='7;#7_.000'
395.            ows_UniqueId='7;#{393BB7DF-8DD3-4940-B89B-68EAA0DE6013}'
396.            ows_ProgId='7;#'
397.            ows_ScopeId='7;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
398.            ows__EditMenuTableStart='7_.000'
399.            ows__EditMenuTableStart2='7'
400.            ows__EditMenuTableEnd='7'
401.            ows_LinkFilenameNoMenu='7_.000'
402.            ows_LinkFilename='7_.000'
403.            ows_LinkFilename2='7_.000'
404.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/7_.000'
405.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/7_.000'
406.            ows_BaseName='7_'
407.            ows_MetaInfo='7;#'
408.            ows__Level='1'
409.            ows__IsCurrentVersion='1'
410.            ows_ItemChildCount='7;#0'
411.            ows_FolderChildCount='7;#0'
412.            ows_ServerRedirected='0' />
413.  
414.   </ListItem>
415.   <ListItem>
416.     <z:row xmlns:z='#RowsetSchema'
417.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
418.            ows_Title='SPTech'
419.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
420.            ows_IdForTerm='864e2d8d-122b-4691-a27d-cbf51222461a'
421.            ows_IdForTermSet='00000000-0000-0000-0000-000000000000'
422.            ows_Term='SPTech'
423.            ows_Path='SPTech'
424.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|OVQGH8TmCUqqdFGCP54oNA=='
425.            ows_CatchAllDataLabel='SPTech#Љ|'
426.            ows_Term1033='SPTech'
427.            ows_Path1033='SPTech'
428.            ows_ID='8'
429.            ows_ContentType='Item'
430.            ows_Modified='2010-05-25 21:34:06'
431.            ows_Created='2010-05-25 19:53:37'
432.            ows_Author='1073741823;#System Account'
433.            ows_Editor='1073741823;#System Account'
434.            ows_owshiddenversion='2'
435.            ows_WorkflowVersion='1'
436.            ows__UIVersion='512'
437.            ows__UIVersionString='1.0'
438.            ows_Attachments='0'
439.            ows__ModerationStatus='0'
440.            ows_LinkTitleNoMenu='SPTech'
441.            ows_LinkTitle='SPTech'
442.            ows_LinkTitle2='SPTech'
443.            ows_SelectTitle='8'
444.            ows_Order='800.000000000000'
445.            ows_GUID='{41CBCA5F-EA88-47D5-AE25-D302B628861E}'
446.            ows_FileRef='8;#sites/mms/Lists/TaxonomyHiddenList/8_.000'
447.            ows_FileDirRef='8;#sites/mms/Lists/TaxonomyHiddenList'
448.            ows_Last_x0020_Modified='8;#2010-05-25 19:53:37'
449.            ows_Created_x0020_Date='8;#2010-05-25 19:53:37'
450.            ows_FSObjType='8;#0'
451.            ows_SortBehavior='8;#0'
452.            ows_PermMask='0x7fffffffffffffff'
453.            ows_FileLeafRef='8;#8_.000'
454.            ows_UniqueId='8;#{F956209C-95A2-4021-96F8-140E5EAB6BC0}'
455.            ows_ProgId='8;#'
456.            ows_ScopeId='8;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
457.            ows__EditMenuTableStart='8_.000'
458.            ows__EditMenuTableStart2='8'
459.            ows__EditMenuTableEnd='8'
460.            ows_LinkFilenameNoMenu='8_.000'
461.            ows_LinkFilename='8_.000'
462.            ows_LinkFilename2='8_.000'
463.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/8_.000'
464.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/8_.000'
465.            ows_BaseName='8_'
466.            ows_MetaInfo='8;#'
467.            ows__Level='1'
468.            ows__IsCurrentVersion='1'
469.            ows_ItemChildCount='8;#0'
470.            ows_FolderChildCount='8;#0'
471.            ows_ServerRedirected='0' />
472.  
473.   </ListItem>
474.   <ListItem>
475.     <z:row xmlns:z='#RowsetSchema'
476.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
477.            ows_Title='Birmingham'
478.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
479.            ows_IdForTerm='392b000a-57bf-4cbb-8416-31c4df84fb22'
480.            ows_IdForTermSet='29ae0eb2-67d8-4e41-af02-7f8a31e010c7'
481.            ows_Term='Birmingham'
482.            ows_Path='USA:Alabama:Birmingham'
483.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|sg6uKdhnQU6vAn+KMeAQxw==|CgArOb9Xu0yEFjHE34T7Ig==|XYdm4SHNWES3uru6HR32fQ==|xuZlxQcStEyuCl+tHnhudQ=='
484.            ows_CatchAllDataLabel='Birmingham#Љ|'
485.            ows_Term1033='Birmingham'
486.            ows_Path1033='USA:Alabama:Birmingham'
487.            ows_ID='9'
488.            ows_ContentType='Item'
489.            ows_Modified='2010-05-25 19:58:17'
490.            ows_Created='2010-05-25 19:58:17'
491.            ows_Author='1073741823;#System Account'
492.            ows_Editor='1073741823;#System Account'
493.            ows_owshiddenversion='1'
494.            ows_WorkflowVersion='1'
495.            ows__UIVersion='512'
496.            ows__UIVersionString='1.0'
497.            ows_Attachments='0'
498.            ows__ModerationStatus='0'
499.            ows_LinkTitleNoMenu='Birmingham'
500.            ows_LinkTitle='Birmingham'
501.            ows_LinkTitle2='Birmingham'
502.            ows_SelectTitle='9'
503.            ows_Order='900.000000000000'
504.            ows_GUID='{C6015CD1-7CB8-45C5-93AC-37295A44C5FB}'
505.            ows_FileRef='9;#sites/mms/Lists/TaxonomyHiddenList/9_.000'
506.            ows_FileDirRef='9;#sites/mms/Lists/TaxonomyHiddenList'
507.            ows_Last_x0020_Modified='9;#2010-05-25 19:58:17'
508.            ows_Created_x0020_Date='9;#2010-05-25 19:58:17'
509.            ows_FSObjType='9;#0'
510.            ows_SortBehavior='9;#0'
511.            ows_PermMask='0x7fffffffffffffff'
512.            ows_FileLeafRef='9;#9_.000'
513.            ows_UniqueId='9;#{76C8A984-8D03-4828-BB99-7A8E94FCADEF}'
514.            ows_ProgId='9;#'
515.            ows_ScopeId='9;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
516.            ows__EditMenuTableStart='9_.000'
517.            ows__EditMenuTableStart2='9'
518.            ows__EditMenuTableEnd='9'
519.            ows_LinkFilenameNoMenu='9_.000'
520.            ows_LinkFilename='9_.000'
521.            ows_LinkFilename2='9_.000'
522.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/9_.000'
523.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/9_.000'
524.            ows_BaseName='9_'
525.            ows_MetaInfo='9;#'
526.            ows__Level='1'
527.            ows__IsCurrentVersion='1'
528.            ows_ItemChildCount='9;#0'
529.            ows_FolderChildCount='9;#0'
530.            ows_ServerRedirected='0' />
531.  
532.   </ListItem>
533.   <ListItem>
534.     <z:row xmlns:z='#RowsetSchema'
535.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
536.            ows_Title='Houston'
537.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
538.            ows_IdForTerm='670bda51-0c2c-4a35-8c17-6485552b30d8'
539.            ows_IdForTermSet='29ae0eb2-67d8-4e41-af02-7f8a31e010c7'
540.            ows_Term='Houston'
541.            ows_Path='USA:Texas:Houston'
542.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|sg6uKdhnQU6vAn+KMeAQxw==|UdoLZywMNUqMF2SFVSsw2A==|Zdu7eKfLmUmcxM4mUWPJrg==|xuZlxQcStEyuCl+tHnhudQ=='
543.            ows_CatchAllDataLabel='Houston#Љ|'
544.            ows_Term1033='Houston'
545.            ows_Path1033='USA:Texas:Houston'
546.            ows_ID='10'
547.            ows_ContentType='Item'
548.            ows_Modified='2010-05-25 20:00:16'
549.            ows_Created='2010-05-25 20:00:16'
550.            ows_Author='1073741823;#System Account'
551.            ows_Editor='1073741823;#System Account'
552.            ows_owshiddenversion='1'
553.            ows_WorkflowVersion='1'
554.            ows__UIVersion='512'
555.            ows__UIVersionString='1.0'
556.            ows_Attachments='0'
557.            ows__ModerationStatus='0'
558.            ows_LinkTitleNoMenu='Houston'
559.            ows_LinkTitle='Houston'
560.            ows_LinkTitle2='Houston'
561.            ows_SelectTitle='10'
562.            ows_Order='1000.00000000000'
563.            ows_GUID='{DE7E8AC7-870F-4FBF-8B97-5DA9A3818BE8}'
564.            ows_FileRef='10;#sites/mms/Lists/TaxonomyHiddenList/10_.000'
565.            ows_FileDirRef='10;#sites/mms/Lists/TaxonomyHiddenList'
566.            ows_Last_x0020_Modified='10;#2010-05-25 20:00:16'
567.            ows_Created_x0020_Date='10;#2010-05-25 20:00:16'
568.            ows_FSObjType='10;#0'
569.            ows_SortBehavior='10;#0'
570.            ows_PermMask='0x7fffffffffffffff'
571.            ows_FileLeafRef='10;#10_.000'
572.            ows_UniqueId='10;#{A51F21E5-2C5A-4EB1-A083-DB26AD94AE1F}'
573.            ows_ProgId='10;#'
574.            ows_ScopeId='10;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
575.            ows__EditMenuTableStart='10_.000'
576.            ows__EditMenuTableStart2='10'
577.            ows__EditMenuTableEnd='10'
578.            ows_LinkFilenameNoMenu='10_.000'
579.            ows_LinkFilename='10_.000'
580.            ows_LinkFilename2='10_.000'
581.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/10_.000'
582.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/10_.000'
583.            ows_BaseName='10_'
584.            ows_MetaInfo='10;#'
585.            ows__Level='1'
586.            ows__IsCurrentVersion='1'
587.            ows_ItemChildCount='10;#0'
588.            ows_FolderChildCount='10;#0'
589.            ows_ServerRedirected='0' />
590.  
591.   </ListItem>
592.   <ListItem>
593.     <z:row xmlns:z='#RowsetSchema'
594.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
595.            ows_Title='Denver'
596.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
597.            ows_IdForTerm='0f22bb0b-7d3a-4818-bc3e-3e5d0906bae2'
598.            ows_IdForTermSet='29ae0eb2-67d8-4e41-af02-7f8a31e010c7'
599.            ows_Term='Denver'
600.            ows_Path='USA:Colorado:Denver'
601.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|sg6uKdhnQU6vAn+KMeAQxw==|C7siDzp9GEi8Pj5dCQa64g==|53LB+4u85ESZSCgWSRYwhw==|xuZlxQcStEyuCl+tHnhudQ=='
602.            ows_CatchAllDataLabel='Denver#Љ|'
603.            ows_Term1033='Denver'
604.            ows_Path1033='USA:Colorado:Denver'
605.            ows_ID='11'
606.            ows_ContentType='Item'
607.            ows_Modified='2010-05-25 20:00:16'
608.            ows_Created='2010-05-25 20:00:16'
609.            ows_Author='1073741823;#System Account'
610.            ows_Editor='1073741823;#System Account'
611.            ows_owshiddenversion='1'
612.            ows_WorkflowVersion='1'
613.            ows__UIVersion='512'
614.            ows__UIVersionString='1.0'
615.            ows_Attachments='0'
616.            ows__ModerationStatus='0'
617.            ows_LinkTitleNoMenu='Denver'
618.            ows_LinkTitle='Denver'
619.            ows_LinkTitle2='Denver'
620.            ows_SelectTitle='11'
621.            ows_Order='1100.00000000000'
622.            ows_GUID='{4E839B03-CB7F-47BF-9B9C-BA8F849FAEA5}'
623.            ows_FileRef='11;#sites/mms/Lists/TaxonomyHiddenList/11_.000'
624.            ows_FileDirRef='11;#sites/mms/Lists/TaxonomyHiddenList'
625.            ows_Last_x0020_Modified='11;#2010-05-25 20:00:16'
626.            ows_Created_x0020_Date='11;#2010-05-25 20:00:16'
627.            ows_FSObjType='11;#0'
628.            ows_SortBehavior='11;#0'
629.            ows_PermMask='0x7fffffffffffffff'
630.            ows_FileLeafRef='11;#11_.000'
631.            ows_UniqueId='11;#{F2564930-20CA-40B0-A352-83E0EC831AE5}'
632.            ows_ProgId='11;#'
633.            ows_ScopeId='11;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
634.            ows__EditMenuTableStart='11_.000'
635.            ows__EditMenuTableStart2='11'
636.            ows__EditMenuTableEnd='11'
637.            ows_LinkFilenameNoMenu='11_.000'
638.            ows_LinkFilename='11_.000'
639.            ows_LinkFilename2='11_.000'
640.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/11_.000'
641.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/11_.000'
642.            ows_BaseName='11_'
643.            ows_MetaInfo='11;#'
644.            ows__Level='1'
645.            ows__IsCurrentVersion='1'
646.            ows_ItemChildCount='11;#0'
647.            ows_FolderChildCount='11;#0'
648.            ows_ServerRedirected='0' />
649.  
650.   </ListItem>
651.   <ListItem>
652.     <z:row xmlns:z='#RowsetSchema'
653.            ows_ContentTypeId='0x01008CAA52CB93C0CF4AB43CD7E9261CC770'
654.            ows_Title='Huntsville'
655.            ows_IdForTermStore='fe440959-f736-41bb-9d7b-0e5975a7572a'
656.            ows_IdForTerm='63371559-6ee4-448d-98d0-87aa7c4ae33d'
657.            ows_IdForTermSet='29ae0eb2-67d8-4e41-af02-7f8a31e010c7'
658.            ows_Term='Huntsville'
659.            ows_Path='USA:Alabama:Huntsville'
660.            ows_CatchAllData='WQlE/jb3u0Gdew5ZdadXKg==|sg6uKdhnQU6vAn+KMeAQxw==|WRU3Y+RujUSY0IeqfErjPQ==|XYdm4SHNWES3uru6HR32fQ==|xuZlxQcStEyuCl+tHnhudQ=='
661.            ows_CatchAllDataLabel='Huntsville#Љ|'
662.            ows_Term1033='Huntsville'
663.            ows_Path1033='USA:Alabama:Huntsville'
664.            ows_ID='12'
665.            ows_ContentType='Item'
666.            ows_Modified='2010-05-25 23:40:02'
667.            ows_Created='2010-05-25 21:43:52'
668.            ows_Author='1073741823;#System Account'
669.            ows_Editor='1073741823;#System Account'
670.            ows_owshiddenversion='3'
671.            ows_WorkflowVersion='1'
672.            ows__UIVersion='512'
673.            ows__UIVersionString='1.0'
674.            ows_Attachments='0'
675.            ows__ModerationStatus='0'
676.            ows_LinkTitleNoMenu='Huntsville'
677.            ows_LinkTitle='Huntsville'
678.            ows_LinkTitle2='Huntsville'
679.            ows_SelectTitle='12'
680.            ows_Order='1200.00000000000'
681.            ows_GUID='{95BC4B4A-F5D3-484E-83CD-E58687457B57}'
682.            ows_FileRef='12;#sites/mms/Lists/TaxonomyHiddenList/12_.000'
683.            ows_FileDirRef='12;#sites/mms/Lists/TaxonomyHiddenList'
684.            ows_Last_x0020_Modified='12;#2010-05-25 21:43:52'
685.            ows_Created_x0020_Date='12;#2010-05-25 21:43:52'
686.            ows_FSObjType='12;#0'
687.            ows_SortBehavior='12;#0'
688.            ows_PermMask='0x7fffffffffffffff'
689.            ows_FileLeafRef='12;#12_.000'
690.            ows_UniqueId='12;#{6F42987A-F9D7-435B-989E-2B23F1B78C23}'
691.            ows_ProgId='12;#'
692.            ows_ScopeId='12;#{52B20B9C-7A04-47B9-B869-89363F5AC46E}'
693.            ows__EditMenuTableStart='12_.000'
694.            ows__EditMenuTableStart2='12'
695.            ows__EditMenuTableEnd='12'
696.            ows_LinkFilenameNoMenu='12_.000'
697.            ows_LinkFilename='12_.000'
698.            ows_LinkFilename2='12_.000'
699.            ows_ServerUrl='/sites/mms/Lists/TaxonomyHiddenList/12_.000'
700.            ows_EncodedAbsUrl='http://demos.mds.com/sites/mms/Lists/TaxonomyHiddenList/12_.000'
701.            ows_BaseName='12_'
702.            ows_MetaInfo='12;#'
703.            ows__Level='1'
704.            ows__IsCurrentVersion='1'
705.            ows_ItemChildCount='12;#0'
706.            ows_FolderChildCount='12;#0'
707.            ows_ServerRedirected='0' />
708.  
709.   </ListItem>
710. </TaxonomyHiddenListFields>

 

For what it’s worth, here are the powershell scripts used to create these XML files. First, the script to create out custom list xml file.

PS- CustomListA

1. # clear the screen
2. clear-host
3.  
4. #Add-PSSnapin Microsoft.SharePoint.Powershell
5. $filename = "C:\CustomListA.xml"
6.  
7. $url="http://demos.mds.com/sites/mms"
8. $ListName = "CustomListA"
9.  
10. $web = Get-SPWeb  $url
11. $list = $web.Lists[$ListName]
12.  
13.  
14. "<CustomListAFields>" > $filename
15. foreach ($item in $list.items ) {
16. "<ListItem>" >> $filename;
17.     $item.xml >> $filename;
18. "</ListItem>" >> $filename;  
19. }
20. "</CustomListAFields>" >> $filename
21.  
22. $web.Dispose()
23.  
24. # Use this to display just one field schema
25. #$list.items[0].Fields["Location"].SchemaXml
26. # Use this to display all the fields of an item. Very helpful.
27. #$list.items[0].Fields | foreach { $_.SchemaXml + "`n `n" }

 

Second, the script to create our TaxonomyHiddenList xml file.

PS-TaxonomyHiddenList

1. # clear the screen
2. clear-host
3.  
4. #Add-PSSnapin Microsoft.SharePoint.Powershell
5.  
6. $url="http://demos.mds.com/sites/mms"
7. $ListName = "TaxonomyHiddenList"
8. $filename = "C:\TaxonomyHiddenList.xml"
9.  
10. $web = Get-SPWeb  $url
11. $list = $web.Lists[$ListName]
12.  
13. #$list.items | foreach { $_.xml }
14.  
15.  
16.  
17. # Use this to display all the fields of an item. Very helpful.
18. "<TaxonomyHiddenListFields>" > $filename
19. #$list.items[0].Fields | foreach { $_.SchemaXml + "`n `n"  >> $filename  }
20.  
21. foreach ($item in $list.items ) {
22. "<ListItem>" >> $filename;
23.     $item.xml >> $filename;
24. "</ListItem>" >> $filename;  
25. }
26.  
27. "</TaxonomyHiddenListFields>" >> $filename
28.  
29. #$list.items[0].Fields | foreach { $_.Title }
30. $web.Dispose()