infopath writing to sharepoint metainfo and how to access it

JasonW — Tue, 07 Apr 2009 19:02:40 GMT

I have a system that writes a bunch of data to a SharePoint document library. Part of the data is an InfoPath "repeating table". This all works.

However, I need to pull to the data from the "reapeating table" section of the SharePoint SPListItem. I have tracked the data to the ows_MetaInfo column.

It seems that the "repeating table" data is stored in an undocumented schema, and part of it is saved in the SPListItems property bag.

So then my question is"How can I get the data stored in the ows_MetaInfo?".

the column e.g. ows_MetaInfo="17;#d7e27d48-0bff-45fa-a9e9-ae48470900ea:SW|High-Medium 
41cf902b-8fb1-483e-ae7d-cef77215bc07:IW|1
vti_parserversion:SR|12.0.0.4518
TemplateUrl:SW|http://moss:666/FormServerTemplates/BCS.xsn
805e0ec6-bf21-408a-a212-a26b8e75e734:SW|
2db2aae9-ec04-41a6-8dfc-704a581dd193:IW|1
961a4bca-45ce-4ceb-964a-3ffbe4d8af57:SW|
79976999-12fa-4dce-820c-cb5ed5e1b76d:SW|
612b5309-6132-4a77-8adf-b8eab9c59b5d:IW|111
f108e79c-1fb4-430d-8931-d068710f473d:SW|fff
e964cac0-ed32-4351-91fb-ac0161f9147d:IW|111333
201ff437-b4e7-4d79-a11a-e9e828794ef1:IW|111
0c931092-3c44-43ca-9bee-0ebafe4083b4:SW|
vti_author:SR|SHAREPOINT\\system
8bd0b634-56d6-4d64-949d-dab704b59ad4:IW|111
TemplateUrl LinkPITarget:SW|mso-infoPathSolution
TemplateUrl LinkPIAttribute:SW|href
xd_ProgID:SW|InfoPath.Document.2
d32e060c-211b-47ef-a88f-83f5829cd8cf:SW|
a42eb9a1-c742-4d8d-86b1-18b1de917140:SW|
7ea410f8-52ea-44fc-ab45-1ca65e52c6f8:SW|New Applications
12bbbab1-50d6-4897-b8b2-4acee8d37104:SW|System
vti_cachedcustomprops:VX|d7e27d48-0bff-45fa-a9e9-ae48470900ea 41cf902b-8fb1-483e-ae7d-cef77215bc07 TemplateUrl\\ LinkPIAttribute TemplateUrl xd_ProgID d32e060c-211b-47ef-a88f-83f5829cd8cf a42eb9a1-c742-4d8d-86b1-18b1de917140 805e0ec6-bf21-408a-a212-a26b8e75e734 7ea410f8-52ea-44fc-ab45-1ca65e52c6f8 12bbbab1-50d6-4897-b8b2-4acee8d37104 vti_title 2db2aae9-ec04-41a6-8dfc-704a581dd193 ContentTypeId ContentType 9e754429-b99d-4c77-82e4-63c308fa4ab0 961a4bca-45ce-4ceb-964a-3ffbe4d8af57 79976999-12fa-4dce-820c-cb5ed5e1b76d 612b5309-6132-4a77-8adf-b8eab9c59b5d f108e79c-1fb4-430d-8931-d068710f473d e964cac0-ed32-4351-91fb-ac0161f9147d 201ff437-b4e7-4d79-a11a-e9e828794ef1 0c931092-3c44-43ca-9bee-0ebafe4083b4 8bd0b634-56d6-4d64-949d-dab704b59ad4 TemplateUrl\\ LinkPITarget
vti_modifiedby:SR|SHAREPOINT\\system
vti_cachedtitle:SR|BCS - 2009-04-07T05_02_35.xml
vti_title:SR|BCS - 2009-04-07T05_02_35.xml
ContentTypeId:SW|0x0101010044CD2935A7253B47AE0C2FC72F7AA0B4008DEAF0509F3B7D46873613D69DCA3F03
ContentType:SW|BCS
9e754429-b99d-4c77-82e4-63c308fa4ab0:SW|
"

some of the property bag items:

7ea410f8-52ea-44fc-ab45-1ca65e52c6f8 = "New Applications"

Note the string "7ea410f8-52ea-44fc-ab45-1ca65e52c6f8" occurs multiple time in the ows_MetaInfo, seemingly replaces the value.

Newbie Questions

infopath writing to sharepoint metainfo and how to access it