Extracting data from a Infopath Form Repeating Section

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 18 Apr 2007 20:14 GMT

I am trying to extract data from a Infopath Form Repeating Section that has
been submited to a Form Library. We can extract data from the Sharepoint SQL
database for all fields except fields in a repeating section.

How can one query fields in a repeating section of an Infopath Form that is
in a Form Library?

The Data Structure is similar as shown below
Form 1
Date
Requester Name
Repeating Section
Material Name (1) (Repeating Section)
Material ID (1) (Repeating Section)
Material Name (2) (Repeating Section)
Material ID (2) (Repeating Section)
Form 2
Date
Requester Name
Repeating Section
Material Name (1) (Repeating Section)
Material ID (1) (Repeating Section)
Material Name (2) (Repeating Section)
Material ID (2) (Repeating Section)
Material Name (3) (Repeating Section)
Material ID (3) (Repeating Section)

Reply to this Message

Shiva[autonomysystems.com] - 19 Apr 2007 06:52 GMT

Hi David,

You can get the repeating section node through using code as below:

IXMLDOMDocument2 secondaryDOM = thisXDocument.GetDOM("Secondary DOM
Connection Name");
secondaryDOM.setProperty("SelectionNameSpaces", "Namespace of the secondary
dom");
IXMLDOMNodeList repeatingNodes = secondaryDOM.selectNodes("XPath of your
repeating section node");

Signature

Visit: http://www.autonomysystems.com
Shiva

> I am trying to extract data from a Infopath Form Repeating Section that has
> been submited to a Form Library. We can extract data from the Sharepoint SQL
[quoted text clipped - 22 lines]
> Material Name (3) (Repeating Section)
> Material ID (3) (Repeating Section)

Reply to this Message

David - 01 May 2007 13:24 GMT

Where do you place that code?

> Hi David,
>
[quoted text clipped - 33 lines]
> > Material Name (3) (Repeating Section)
> > Material ID (3) (Repeating Section)

Reply to this Message