Split XML File based on element count

Question

2.09/5 (3 votes)

See more:

Hello,

i have a big XML file,which i want to split in several files based on Element count
Ex. if the file is like below

XML

<bookstore>
    <book category="...">
        <title >...</title>
        <author>...</author>
        <year>...</year>
        <price>...</price>
    </book>
    <book category="...">
        <title >...</title>
        <author>...</author>
        <year>...</year>
        <price>...</price>
    </book>
    <book category="...">
        <title >...</title>
        <author>...</author>
        <year>...</year>
        <price>...</price>
    </book>
    <book category="...">
        <title >...</title>
        <author>...</author>
        <year>...</year>
        <price>...</price>
    </book>
</bookstore>

each file should contain 2 books only Therefore it should generate two files like below

XML

<bookstore>
    <book category="...">
        <title >...</title>
        <author>...</author>
        <year>...</year>
        <price>...</price>
    </book>
    <book category="...">
        <title >...</title>
        <author>...</author>
        <year>...</year>
        <price>...</price>
    </book>
</bookstore>

Any ideas?

Posted 3-May-13 1:24am

Amol_B

Updated 11-Oct-18 19:00pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

T Pat · Accepted Answer · 2013-05-03T02:39:00

Solution 1

Try logic on following links it might work :)

http://stackoverflow.com/questions/12016946/how-to-split-an-xml-file-into-multiple-xml-files[^]

http://stackoverflow.com/questions/14455639/how-to-split-an-xml-file-into-multiple-xml-files-based-on-nodes[^]

Posted 3-May-13 2:39am

T Pat

Updated 3-May-13 2:41am

v2

Amol_B · Accepted Answer · 2013-07-07T20:51:00

i did it this way

C#

//New xml document object
                XmlDocument newXmlDoc = new XmlDocument();
                //XML writer to be used
                XmlTextWriter Xwr ;
//Read Root Element from XML
                XmlElement root = Doc.DocumentElement;

                //node nae to load nodes list
                if (Doc.DocumentElement.ChildNodes.Count > 0)
                    RootNodeName = "//" + root.Name + "/" + Doc.DocumentElement.ChildNodes[0].Name;
                else
                    RootNodeName = "//" + root.Name;

                //load all client noded in Node List
                XmlNodeList NodeList = Doc.SelectNodes(RootNodeName);
              

                //crete new doc and write empty root node
                XmlNode CurrentNode = null;
                XmlNode RootNode = newXmlDoc.CreateElement(root.Name);
                newXmlDoc.AppendChild(RootNode);


                for (int i = 0; i < NodeList.Count; i++)
                {
                    CurrentNode = NodeList[i];

                    //to skip empty nodes
                    if (CurrentNode.InnerXml == null || CurrentNode.InnerXml.Trim() == "")
                        continue;

                    //append nodes till batch size is reached
                    if (RecCount < iBatchSize)
                    {
                        XmlNode targetNode = newXmlDoc.ImportNode(CurrentNode, true);
                        RootNode.AppendChild(targetNode);
                        RecCount = RecCount + 1;
                    }
                    else
                    {
                        //once batch size is reached, save file and re-initialise xml document
                        FileCount = FileCount + 1;
                        Xwr = new XmlTextWriter(FilePath + @"\" + FileName + "_" + FileCount.ToString() + ".xml", Encoding.UTF8);
                        Xwr.Formatting = Formatting.None;
                        newXmlDoc.Save(Xwr);
                        Xwr.Close();
                        Xwr = null;
                        newXmlDoc = null;

                        newXmlDoc = new XmlDocument();
                        RootNode = newXmlDoc.CreateElement(root.Name);
                        newXmlDoc.AppendChild(RootNode);
                        XmlNode targetNode = newXmlDoc.ImportNode(CurrentNode, true);
                        RootNode.AppendChild(targetNode);
                        RecCount = 1;
                    }
                    if (i == NodeList.Count - 1)
                    {
                        if (RecCount > 0)
                        {
                            //if remaining items are less than Batchsize, save file at last
                            FileCount = FileCount + 1;
                            Xwr = new XmlTextWriter(FilePath + @"\" + FileName + "_" + FileCount.ToString() + ".xml", Encoding.UTF8);
                            Xwr.Formatting = Formatting.None;
                            newXmlDoc.Save(Xwr);
                            Xwr.Close();
                            Xwr = null;
                            Console.WriteLine();
                            newXmlDoc = null;
                        }
                    }

                }