Re: Programmatically export Infopath form to csv file

eddyblanco — Fri, 01 Jan 2010 23:59:58 GMT

Hello Lawson. In order to export the content of an infopath form you would need to:

1) Open the XML

2) Read all nodes or the specific node you would like to export to excel in your case.

For reading you coud do something similar to the following sample.

file = yourfile.xml;

                        string xmlFileContent = System.Text.Encoding.Default.GetString(file.OpenBinary());
                        int index = xmlFileContent.IndexOf("<?xml");
                        if (index != 0)
                            xmlFileContent = xmlFileContent.Remove(0, index);

                        XmlDocument doc = new XmlDocument();
                        doc.LoadXml(xmlFileContent);
                        XmlNamespaceManager mgr = new XmlNamespaceManager(doc.NameTable);
                        mgr.AddNamespace("my", @"http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-06-10T00:13:44");

                        //the sample node to read
                        XmlNode nodeStatus = doc.DocumentElement.SelectSingleNode("/my:Eddys_Form/my:PlanHistory_Status", mgr);

string insertsomewhere = nodeStatus.InnerText.tostring();

For the insert into the csv there are plenty of samples in the internet. just pass the string above.

I hope this heps.

Programmatically export Infopath form to csv file

Lawson — Wed, 30 Dec 2009 19:16:34 GMT

I created an InfoPath 2003 form. I am trying to programmatically export some of the data into many different csv files. However, I have been unable to find a way to programmatically export the data. Does anybody have any suggestions? Thank you,

-Lawson

Code

Re: Programmatically export Infopath form to csv file

Programmatically export Infopath form to csv file