https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/99377.aspxWed, 01 Oct 2014 18:39:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:99377uds20140https://www.infopathdev.com:443/forums/thread/99377.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=99377<p>I am new to Infopath and does not have&nbsp;much programming&nbsp;background. I have bunch of XML data source files which I can open using Infopath 2010&nbsp;and see the field&nbsp;labels and field values. For example,&nbsp;label&nbsp;is &quot;State:&quot; and the value is &quot;CA&quot;. XML&nbsp;data source&nbsp;has dates, complex tables,&nbsp;groups, radio buttons, check&nbsp;boxes, free form text and so on. I also have associated XSN file which XML data source file is referring to. From online forums, I got to know that I can change the extension of xsn file&nbsp;to a cab&nbsp;extension and unzip the cab file. After unzipping&nbsp;the cab file, I could see that&nbsp;it&nbsp;had buch of other files such as xsl, xml, xsd, etc. When I open XML data source file in text mode, I find field83 has value &quot;CA&quot;.&nbsp; When I try to find what is field83 in the files extracted from XSN, I found that one of the XSL file has field83 and it has a &lt;div&gt; element which has text &quot;State:&quot;.</p> <p>All I need is a flat report (may be a CSV or Excel&nbsp;file will do) which gives&nbsp;me field label (for example &quot;State:&quot;) and the data value (&quot;CA&quot;) only where the data values are present. I don&#39;t require fields which are empty. Or if it is too complex, then I can filter on non-empty fields. Optionally if I can get XPATH of the mapping field name that is even better (For example, /my:myFields/my:field83) Optional fieldname is just for tracking purpose. And this should work on all data types such as groups, tables, radio buttons, etc. For radio button / check boxes, I don&#39;t want selection values such as 1 or 2, but more meaningful as what&nbsp;was checked by user.</p> <p>Having described kinda weird requirement, I need a quick help in order to generate these reports for bunch of xml data source files and associated xsn files. Any simple&nbsp;and automated way will be really helpful. If Infopath has some mechnism to export label and data values into Excel, that&nbsp;would be&nbsp;awesome.&nbsp;Looking forward to get some quick and easy ways from all you experts !</p> <p>Thanks in advance !</p> <p>&nbsp;</p>