7 people following this project (follow)

Project Description
Query multiple InfoPath XML documents within a SharePoint Form Library.

The InfoPath published column feature has limitations. High numbers of fields and repeating sections are all now clearly visible with this Web Service. Easily aggregate XML files for robust reporting.

Have you ever wanted to report directly against InfoPath Form Library data? Have you been frustrated by the limitations of published columns? Have you had trouble when trying to report on repeating table (one-to-many) data? Do you like working with clean XML web services? Then download and check out this SOAP web service.

This code will aggregate many source XML documents into a single XML for easy reporting. Because InfoPath documents share a common XSD schema from within the template XSN, they may be consolidated using Dot Net objects like DataSet, DataTable, and XmlDocument.

Features
  • Reads SharePoint Form Library XSN template
  • Extracts XSD schema file
  • Reads all XML document files
  • Outputs a single aggregate XML data set
  • Compatible any XML reporting tool (Excel, SQL Reporting Services, Performance Point Services, PowerPivot, InfoPath, etc.)

Screenshots







Usage
There are four parameters:
  • SiteURL - the SPWeb URL for the site hosting the Form Library
  • FormLibraryTitle - the display name of the Form Library
  • OptionalContentType - when working with Administrator approved Central Admin XSN templates, you may need to specify a content type. with basic forms, this should be "Form".
  • OptionalRefreshSeconds - number of seconds to maintain a local cache of the aggregated XML. helps with performance in heavy usage scenarios. default is 10 seconds. set to zero "0" for no caching (will increase CPU load and slow rendering).

Cabinet file extract method from "Iterate and Extract Cabinet File" CodeProject By aplaxas. All other trademarks and copyrights are property of their respective owners.

Please drop me a line via email jeffmjones@gmail.com or Twitter @spjeff with ideas. I'm always open to suggestions and improvements.

Best,
Jeff

http://www.spjeff.com

Last edited Sep 18 2011 at 5:44 PM by spjeff, version 11