How do modify a large XML file to become smaller?

I get a larger XML file from an outside source. I would like to read specific elements and write them to a new XML file for my intended user. My user doesn't need the other elements.

I tried this but I don't think I'm navigating the hierarchy correctly.

Code:

---

            XElement xml = XElement.Load("test.xml");
            XElement xml2 = new XElement("applications",
                                    new XElement("application",
                                      new XElement("uid", xml.Element("uid").Value)));
 
            xml2.Save(@"C:\newfile.xml");

---

Let say the XML looks like this:

Code:

---

<?xml version="1.0" encoding="utf-8"?>
<applications>
<applicant>
<uid>321321321</uid>
<address>321321321</address>
<phone>321321321</phone>
<email>321321321</email>
</applicant>
</applications>

---

And I just want a file like this in the end:

Code:

---

<?xml version="1.0" encoding="utf-8"?>
<applications>
<applicant>
<uid>321321321</uid>
</applicant>
</applications>

---

I also know I need a loop in there somewhere.

Any help is appreciated.

Thanks.

This worked for me (I have no doubt that it can be refactored to produce smarter code).... cg.xml is the original file cg2.xml is the cut-down file:

Code:

---

using System.IO;
using System.Xml;
using System.Xml.Linq;

namespace CG
{
    class Program
    {
        static void Main(string[] args)
        {
            XDocument doc;

            using (FileStream fs = new FileStream(@"C:\cg.xml", FileMode.Open))
            {
                doc = XDocument.Load(fs);

                XElement applications = doc.Element("applications");

                foreach (XElement applicant in applications.Elements("applicant"))
                {
                    XElement badElement = applicant.Element("address");
                    badElement.Remove();

                    badElement = applicant.Element("phone");
                    badElement.Remove();

                    badElement = applicant.Element("email");
                    badElement.Remove();
                }
            }

            using (FileStream fs = new FileStream(@"C:\cg2.xml", FileMode.Create))
            {
                XmlWriter writer = XmlWriter.Create(fs);

                doc.WriteTo(writer);

                writer.Close();
            }
        }
    }
}

---

Thanks. I'll try this if nothing else comes up. I was hoping to select instead of delete elements. The original files has 500 columns to sort.

This method should provide you with what you're looking for... you will need to tweak it to fit your exactl XML layout/needs... but the basic idea is here.

Code:

---

            XmlDocument sourceDoc = new XmlDocument();
            XmlDocument targetDoc = new XmlDocument();

            sourceDoc.Load("ORIG.xml");

            XmlNode newAppsNode = targetDoc.AppendChild(targetDoc.CreateElement("applications"));

            foreach (XmlNode node in sourceDoc.DocumentElement.SelectNodes("applications/applicant"))
            {
                XmlNode newAppNode = targetDoc.CreateElement("applicant");
                newAppsNode.AppendChild(newAppNode.AppendChild(targetDoc.ImportNode(node.SelectSingleNode("uid"), true)));
            }

            targetDoc.Save("NEW.xml");

---

No worries. Pretty sure that it can be done in a LINQ query (or two).

Quote:

---

Originally Posted by fcronin

This method should provide you with what you're looking for... you will need to tweak it to fit your exactl XML layout/needs... but the basic idea is here.

---

I made one change to your code in the foreach section. It looped as expected after the edit. My problem is that I can't get it to write the node called 'applicant'.

Code:

---

                      XmlNode newAppsNode = targetDoc.AppendChild(targetDoc.CreateElement("applications"));
           

            /*foreach (XmlNode node in sourceDoc.DocumentElement.SelectNodes("applications/applicant"))*/
            foreach (XmlNode node in sourceDoc.DocumentElement.SelectNodes("applicant"))
            {
                XmlNode newAppNode = targetDoc.CreateElement("applicant");
                newAppsNode.AppendChild(
                    newAppNode.AppendChild(
                        targetDoc.ImportNode(node.SelectSingleNode("uid"), true)));
            }

            targetDoc.Save("TestSupplemental.xml");

---

All I get is this:

Code:

---

<applications>
  <uid>111111111</uid>
  <uid>222222222</uid>
  <uid>333333333</uid>
</applications>

---

Thanks for your help.

Why don't you break this down into steps?

Instead of trying to appead the application node and it's child nodes, just try to get the application node to show up.

Code:

---

XmlNode newAppsNode = targetDoc.AppendChild(targetDoc.CreateElement("applications"));
           
foreach (XmlNode node in sourceDoc.DocumentElement.SelectNodes("applicant"))
{
  XmlNode newAppNode = targetDoc.CreateElement("applicant");
  newAppsNode.AppendChild( newAppNode );
}

---

When you get this working, go back and add the uid child nodes.

Quote:

---

Originally Posted by Arjay

Why don't you break this down into steps?

---

Got it. Thanks. Everything works now. I'll be able to specify elements in the source file and create unique files for my department.

Code:

---

            XmlDocument sourceDoc = new XmlDocument();
            XmlDocument targetDoc = new XmlDocument();

            sourceDoc.Load("source.xml");

            XmlNode newAppsNode = targetDoc.AppendChild(targetDoc.CreateElement("applications"));

            foreach (XmlNode node in sourceDoc.DocumentElement.SelectNodes("applicant"))
            {
                XmlNode newAppNode = targetDoc.CreateElement("applicant");
               
                newAppsNode.AppendChild(newAppNode);
                   
                    /* Repeat below for different columns */
                    newAppNode.AppendChild(
                        targetDoc.ImportNode(node.SelectSingleNode("name"), true));
            }

            targetDoc.Save("DeptSupplemental.xml");
        }

---

It's kind of important to understand what went wrong before.

Code:

---

newAppsNode.AppendChild(
                    newAppNode.AppendChild(
                        targetDoc.ImportNode(node.SelectSingleNode("uid"), true)));

---

Before you were searching for a uid node in the target doc. I'm guessing that that node didn't exist, so you attempted to append a null node to the newAppNode. That failed causing the newAppsNode.AppendChild to also fail (or the code to throw an exception that you didn't catch).

The bottom line is while you are learning, resist the urge to peform multiple operations in one call. AppendChild within another AppendChild call may mask problems. At first, it's better to break these out on different lines so you can step through each line in a debugger.

For newbies, many questions stem from the fact that they don't step through code in a debugger. Once they learn to do this, they can usually figure out problems on their own.