Quick Hit: Reading InfoPath XML Directly From an SPListItem in SharePoint

I’m been working on a project where I need to extract attachments from an InfoPath form.  There are some good resources for parsing InfoPath forms (which are just XML files, so it’s actually quite easy). 

While I was building up the project, I started by downloading an InfoPath form and saving it to my local hard drive.  My c# code was reading directly from that instance.  However, the InfoPath forms are really living inside a SharePoint forms library.  I did a little half hearted searching to find out how to read it directly from the library and almost gave up, in which case I would have saved the form to a local temp directory and read it from there.  However, there’s no need to go through those hoops as you can read it directly from the library.  This little snippet shows how:

/// Class definition stuff here, including:
private SPFile mySharePointFile; /* Part of an SPList */
// More code goes here and inside a method of the class we have:
XmlTextReader textReader;
textReader = new XmlTextReader(mySharePointFile.OpenBinaryStream());

textReader.WhitespaceHandling = WhitespaceHandling.None;

textReader.Read();

// If the node has value

while (textReader.Read())
{

  … and so on and so forth …

 

They key bit above is that we can read the InfoPath directly via the OpenBinaryStream() method call on the SPFile as a parameter to the constructor on XmlTextReader.  It works great.

</end>

Subscribe to my blog.

Follow me on Twitter at http://www.twitter.com/pagalvin

Technorati Tags:

One thought on “Quick Hit: Reading InfoPath XML Directly From an SPListItem in SharePoint

  1. nesreen

    hi,
    I need help in this , I have sharepoint 2007 site and infopath with a repeating table , what I need to do is once the form is saved to the sharepoint forms library I need to loop and save the data to a list using SP form library event handler.

    Any help is really appreciated.

    Thanks

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *