Mining InfoPath XML files

[Humphrey]

I have a series of InfoPath files living in a SharePoint form library. The
forms have a basic header and a single repeating table layout structure. One
of the fields in the repeating table is a binary "More information Required".
How can I gather up all the data that has this box checked from the hundreds
of submitted forms to produce a report for our project managers to chase?
Ideally I'd like it to be something they don't need to manually gather that
could be drawn down into Excel or Access.
Is this even possible?

H

 

[Paresh]

I have a series of InfoPath files living in a SharePoint form library.  The
forms have a basic header and a single repeating table layout structure.  One
of the fields in the repeating table is a binary "More information Required".
How can I gather up all the data that has this box checked from the hundreds
of submitted forms to produce a report for our project managers to chase? 
Ideally I'd like it to be something they don't need to manually gather that
could be drawn down into Excel or Access.
Is this even possible?

H

Hi,

One way of doing this would be programmatically reading infopath forms
inm sharepoint library.
Take a look at the following link:
http://www.bizsupportonline.net/infopath2007/retrieve-value-infopath-form-field-code.htm
Hope this helps.

Thanks,
Paresh
http://www.openzeas.com/blogs/Paresh/

 

[Humphrey]

Paresh,

I can see how that would work if I was reading through file by file,
but I need to be able to open ALL the forms and determine if the flag is set
in the repeating table and then return the data to Excel or Access. I'll
investigate your suggestion further but will probably need further assistance
to solve this one.

H

 

[Paresh]

Paresh,

     I can see how that would work if I was reading through file byfile,
but I need to be able to open ALL the forms and determine if the flag is set
in the repeating table and then return the data to Excel or Access.  I'll
investigate your suggestion further but will probably need further assistance
to solve this one.

H

Also, for reading all the files in a form library, you will need to
take advantage of SharePoint object model.

Thanks,
Paresh

 

[Humphrey]

Thanks Paresh. My brain doesn't travel as far as the object model. I might
have to leave that one rest for a while.

Has anyone noticed how the help files giv you just enough information for
you to realise that not all the detail is in the examples given?