InfoPath Dev

Hello,

I need to dynamically extract the field names of my xsn form. I have the xml of the infopath form stored in a CLOB column.

My xml in the CLOB column is somthing like this:

<?xml version="1.0" encoding="UTF-8"?>
<?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:PD-WD-Form1-124:-myXSD-2010-10-20T09-36-58" href="manifest.xsf" mce_href="manifest.xsf" solutionVersion="1.0.0.1" productVersion="12.0.0" PIVersion="1.0.0.0" ?>
<?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?>
<my:myFields xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-10-20T09:36:58">
 <my:WDComment></my:WDComment>
 <my:field2></my:field2>
 <my:field3></my:field3>
</my:myFields>

so i need values like

myFields/WDComment/nestedfield2 - (if any)

myFields/field2

myFields/field3

Can you please help?

I think what you need is the schema file which is the XSD.  All of the InfoPath file format specifications are documented by Microsoft and can be found here: http://msdn.microsoft.com/en-us/library/cc313124(v=office.12).aspx

To get the specific kind of structured output you have provided the example for (parent\child\grand-child) etc you'll probably have to load the xml file into an XML DOM of some sort and 'walk your way' through it iteratively building the path to each node-field as you go. You could use the nodeName properties.

This kind of iteration I usually use two functions, one to start off the routine, and the other as a recursive processing of a node which calls itself.