merge all XML file in a folder in C#

darma teja

10y3.4kVisual Basic .NET

I want to merge all xml files in a folder. Here i am giving sample two xml files:

My first xml file is like this:

<first>
<second>
<third>123third>
<text>
<type>text1type>
<country>frcountry>
<vaue>No1value>
text>
<third>345third>
<text>
<type>text2type>
<country>frcountry>
<vaue>No2value>
text>
second>
first>

My second xml file is like this:

<first>
<second>
<third>123third>
<text>
<type>text1type>
<country>incountry>
<vaue>No5value>
text>
<third>345third>
<text>
<type>text2type>
<country>incountry>
<vaue>No3value>
text>
second>
first>

The output should be like this:

<first>
<second>
<third>123third>
<text>
<type>text1type>
<country>frcountry>
<vaue>No1value>
text>
<text>
<type>text1type>
<country>incountry>
<vaue>No5value>
text>
<third>345third>
<text>
<type>text2type>
<country>incountry>
<vaue>No3value>
text>
<text>
<type>text2type>
<country>incountry>
<vaue>No2value>
text>
second>
first>

I have tried it in C# like this, but it is not giving me the correct output:

string[] files = get all files in a directory;
var masterfile = new XDocument();
string readAllText1 = File.ReadAllText(files[0]);
StreamReader sr = new StreamReader(files[0], true);
XDocument xdoc1 = XDocument.Load(sr);
XElement newDocument = new XElement(xdoc1.Root);
masterfile.Add(newDocument);
foreach (var file in files)
{
if (file != files[0])
{
StreamReader sr1 = new StreamReader(file, true);
XDocument xdoc = XDocument.Load(sr1);
masterfile.Root.Add(xdoc.Descendants("third"));
}
}
string str = Path.GetFileNameWithoutExtension(files[0]).Remove(Path.GetFileNameWithoutExtension(files[0]).Length - 3);
masterfile.Save(textBox2.Text + "//" + str + ".xml");

Advance thanks,

Darma

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
You can try this code -
XDocument doc = XDocument.Load(Server.MapPath("xmlfolder/xml1.xml"));
var k = doc.Descendants("text").ToList();
string[] filePaths = Directory.GetFiles(Server.MapPath("xmlfolder"));
for (int i = 0; i < k.Count(); i++)
{
var f = k[i];
XDocument doc2 = new XDocument();
for (int m = 0; m < filePaths.Length; m++)
{
if (filePaths[m].IndexOf(".xml") > 0 && filePaths[m].IndexOf("xml1.xml") < 0)
{
doc2 = XDocument.Load(filePaths[m]);
var l = doc2.Descendants("text").ToList();
for (int j = 0; j < l.Count(); j++)
{
if (j == i)
{
f.AddAfterSelf(l[j]);
break;
}
}
}
}
}
doc.Save(Server.MapPath("Newxml.xml"));
0
darma teja10y ago
Thanks allot Midhun!
0
darma teja10y ago
Hi Midhun,
Wonderful. It works now.
My question here is:
You are giving specific 2 xml files as input.
But If I have more than 2 xml files in a folder how can I do it?
Many thanks,
Darma
0
Midhun Tp10y ago
Hi,
Please try below code -
XDocument doc = XDocument.Load(Server.MapPath("xml1.xml"));
XDocument doc2 = XDocument.Load(Server.MapPath("xml2.xml"));
var k = doc.Descendants("text").ToList();
for (int i = 0; i < k.Count(); i++)
{
var f = k[i];
var l = doc2.Descendants("text").ToList();
for (int j = 0; j < l.Count(); j++)
{
if (j == i)
{
f.AddAfterSelf(l[j]);
break;
}
}
}
doc.Save(Server.MapPath("Newxml.xml"));
+1
darma teja10y ago
Thanks Vinay, unfortunately those solutions are not working in this xml files.
0
Vinay Singh10y ago
Hi try the below link
https://gist.github.com/teradyne/1712060
http://stackoverflow.com/questions/12243709/process-multiple-xml-files-from-folder
http://stackoverflow.com/questions/21895257/how-can-xml-documentation-for-web-api-include-documentation-from-beyond-the-main
0