Extract differences between two XML files ?

Question

i'm implementing a client-server program that synchronize files between computers. At some point when the client connects to the server an XML file that contains the directory structure of the location that must be synchronized with the server is sent to the server. If it is not the first time when the client connects on the server exists such a XML files so there must be found the differences between those 2 files and request from client only the ones that files that have been changed or new. My problem is... how can I find those differences between the XML's. I have 2 XML samples(one XML can have and 1Gb). First XML (source.xml) : Second XML (changed.xml) : I found an example that uses LinQ to XML http://www.codeproject.com/Articles/45233/Diff-in-XML-files-with-LINQ  but the XML structure used there is different and it does not help me very much. Given the fact that i can have the tag Folder and File nested inside other nodes..i really don't know how to find the differences ... Can someone give me an idea? Thank you! Best Regards Oana

Parveen Siwach · Answer

You can try to use Microsoft XML Diff and Patch Tool API: http://msdn.microsoft.com/en-us/library/aa302294.aspx public void GenerateDiffGram(string originalFile string finalFile XmlWriter diffGramWriter) { XmlDiff xmldiff = new XmlDiff(XmlDiffOptions.IgnoreChildOrder | XmlDiffOptions.IgnoreNamespaces | XmlDiffOptions.IgnorePrefixes); bool bIdentical = xmldiff.Compare(originalFile newFile false diffgramWriter); diffgramWriter.Close(); } public void PatchUp(string originalFile String diffGramFile String OutputFile) { XmlDocument sourceDoc = new XmlDocument(new NameTable()); sourceDoc.Load(originalFile); XmlTextReader diffgramReader = new XmlTextReader(diffGramFile); xmlpatch.Patch(sourceDocdiffgramReader); XmlTextWriter output = new XmlTextWriter(OutputFileEncoding.Unicode); sourceDoc.Save(output); output.Close(); }

Bikesh Srivastava · Answer

Okay... I finally opted with a pure C# solution to compare the two XML files without using the XML Diff/Patch .dll and without even needing to use XSL transforms. I will be needing XSL transforms in the next step though to convert the Xml into HTML for viewing purposes but I have figured an algorithm using nothing but System.Xml and System.Xml.XPath. Here is my algorithm: private void CompareXml( string file1 string file2) { //Loadthedocuments XmlDocumentdocXml1= new XmlDocument(); docXml1.Load(file1); XmlDocumentdocXml2= new XmlDocument(); docXml2.Load(file2); //Getalistofallplayernodes XmlNodeListnodes1=docXml1.SelectNodes( /Stats/Player ); XmlNodeListnodes2=docXml2.SelectNodes( /Stats/Player ); //Defineasinglenode XmlNodenode1; XmlNodenode2; //GettherootXmlelement XmlElementroot1=docXml1.DocumentElement; XmlElementroot2=docXml2.DocumentElement; //Getalistofallplayernames XmlNodeListnameList1=root1.GetElementsByTagName( Name ); XmlNodeListnameList2=root2.GetElementsByTagName( Name ); //Getalistofallteams XmlNodeListteamList1=root1.GetElementsByTagName( Team ); XmlNodeListteamList2=root2.GetElementsByTagName( Team ); //CreateanXmlWriterSettingsobjectwiththecorrectoptions. XmlWriterwriter= null ; XmlWriterSettingssettings= new XmlWriterSettings(); settings.Indent= true ; settings.IndentChars=(  ); settings.OmitXmlDeclaration= false ; //CreatetheXmlWriterobjectandwritesomecontent. writer=XmlWriter.Create(StatsFile.XmlDiffFilenamesettings); writer.WriteStartElement( StatsDiff ); //Thecomparealgorithm bool match= false ; int j=0; try { //thelisthas500players for ( int i=0;i { while (j false ) { //Thereisamatchiftheplayernameandteamarethesameinbothlists if (nameList1.Item(i).InnerText==nameList2.Item(j).InnerText) { if (teamList1.Item(i).InnerText==teamList2.Item(j).InnerText) { match= true ; node1=nodes1.Item(i); node2=nodes2.Item(j); //CalltothecalculatorandXmlwriter this .CalculateDifferential(node1node2writer); j=0; } } else { j++; } } match= false ; } //endXmldocument writer.WriteEndElement(); writer.Flush(); } finally { if (writer!= null ) writer.Close(); } } Try may be it will help you.

Vivek Deshmukh · Answer

Hi Did you get a solution to exact only different nodes from diffram? If yes can you pls share? Thank you!

chelariu oanadaniela · Answer

Hello! This code generate the diffram.I did that  but I asked if you could give me an idea about how to parse the diffram so that i could extract the nodes that are different(for ex.. enumerate the nodes that are added that are deleted or changed). Thank you.

Parveen Siwach · Answer

You can use the following code to compare two XML files and write the difference in new XML file: public void CompareXml(string file1 string file2 string diffFileNameWithPath) { XmlReader reader1 = XmlReader.Create(new StringReader(file1)); XmlReader reader2 = XmlReader.Create(new StringReader(file2)); StringBuilder differenceStringBuilder = new StringBuilder(); using (FileStream fs = new FileStream(diffFileNameWithPath FileMode.Create)) { XmlWriter diffGramWriter = XmlWriter.Create(fs); XmlDiff xmldiff = new XmlDiff(XmlDiffOptions.IgnoreChildOrder | XmlDiffOptions.IgnoreNamespaces | XmlDiffOptions.IgnorePrefixes); bool bIdentical = xmldiff.Compare(file1 file2 false diffGramWriter); diffGramWriter.Close(); } } Calling Code: CompareXml(@C:\XML\Source.xml @C:\XML\changed.xml @C:\Diff.xml); Hope this will help you.

chelariu oanadaniela · Answer

Hello! First thx for your replay. I tried this tool but since i need the nodes that are different i would have to parse the diffgram and i really don't know how to do that.. Could you give me an idea about how to do that? Thank you Oana.