Why you should NOT use InfoPath 2010 if a repeating table is required.
-
2012年3月21日 下午 01:21
Does anyone have any feedback on this?
Why you should NOT use InfoPath 2010 if a repeating table is required
Jeffrey T McFarland
所有回覆
-
2012年4月9日 下午 05:10
Not so, you just need the right companion tool set. For example, you can submit the forms to the form lib, and a copy of the xml to a SQL2005(and beyond) table using the xml data type. From there you can perform xquery to 'shred' the forms and report as needed.
We use IP extensively, and this approach has served us well.There are 3rd party tools to assist with this IP form shredding (QDabra), or you can roll yer own as we did.
/bac
-
2012年4月9日 下午 06:52I've very interested in trying this technique for myself. Bob and you please give me some details on how this works and what steps you used to implement it?
Jeffrey T McFarland
-
2012年4月15日 下午 12:36The post outlines issues when attempting to store a form containing a repeating table within a List. But the point is that InfoPath stores data in XML , so it makes more sense to store the form output as a file in a document library - you can still get at this information by accessing the information directly i.e. either with or without InfoPath.
-
2012年4月16日 下午 01:59
Ted,
I understand your point. Can you give me an example of accessing the repeating table data without InfoPath? Also, would you use InfoPath 2010 when a repeating table was required and you knew that later on down the road you might need to access the repeating table data outside of InfoPath?
Jeffrey T McFarland
-
2012年4月16日 下午 03:18
I'm working on a white paper on this process, but the general overview is:
- Save form to SharePoint (so you can benefit from SP workflows, alerts,...)
- Save a mirror copy of the form xml to a SQL table xml data type, with appropriate xml indexing.
- Perform reporting from the SQL xml table using xQuery.
HTH
/bac
-
2012年4月19日 下午 09:42
Jeffrey,
You will need to do in code. Having saved to a Document Library, you will be able to access the XML - for instance, if you view the content for the library and download a copy of the XML stored, and edit with Notepad, you will see the XML data structure for the form. You can use c# XML to access and also modify the XML if required. In answer to your second question, yes - but obviously InfoPath is not always the best tool to use for a form.
-
2012年4月20日 上午 02:26Bob I'd like to see your white paper on this as soon as you complete it. I don't know how to do what you described in the 2nd and 3rd bullet points. Thanks for the feedback.
Jeffrey T McFarland
-
2012年4月20日 上午 02:27Ted, I don't follow you. Can you please describe your technique in more detail?
Jeffrey T McFarland
.png)
