XML merging

[Sanjib Biswas]

Hi All,

I am looking for XML merging for the following scenarios. I want to load both the input files and show in the tree viewer and highlight the differences. Now its up to the user to select the correct node. Any non conflicting differences should be automatically merge onto the merge document. Any suggestion/caveats on how to do this in VB.Net?

Regards
Sanjib

doc1.xml |doc2.xml
======== |========
<data> |<data>
<product> | <product>
<title>MS Access</title> | <title>MS Access Suite</title>
<price>350.00 </price> | <price>350.00 </price>
</product> | </product>
<product> | <product>
<title>MS Outlook</title> | <title>MS Outlook</title>
<price>300.00 </price> | <price>250.00 </price>
</product> | </product>
<product> | <product>
<title>MS Office</title> | <title>MS Office</title>
<price>450.00 </price> | <price>450.00 </price>
</product> | </product>
</data> | <product>
| <title>MS Visual ..Net</title>
| <price>310.00 </price>
| </product>
|</data>

merge.xml
=========
<data>
<product>
<title>select the title name based on the decision</title>
<price>350.00 </price>
</product>
<product>
<title>MS Outlook</title>
<price>select the price based on the decision</price>
</product>
<product>
<title>MS Office</title>
<price>450.00 </price>
</product>
<product>
<title>MS Visual .Net</title>
<price>310.00 </price>
</product>
</data>

[sloan]

This may help:
as in, to find which items are duplicates:

http://support.microsoft.com/default...b;en-us;326145

Here are my notes about my implmentation of the KB

/*
* See KB http://support.microsoft.com/default...b;en-us;326145
* There were 2 bugs in the code as retrieved from the KB
*
* private object Add ... and this line // return (Convert.ToDeci mal(a) +
Convert.ToDecim al(b));
*
*
* private bool ColumnCompare .. and this line // bool returnValue =
(Convert.ToStri ng(a) == Convert.ToStrin g(b)); return returnValue;
*
*
* and 1 enhancement in the InsertGroupByIn to method
*
* case "last":
if (GroupBy.Length > 0)
{
//they specified a non aggr column .. but since there was no
GroupBy, it won't reflect accurate data, thus only set it when there is a
valid GroupBY
DestRow[Field.FieldAlia s]=SourceRow[Field.FieldName];
}
*
* */
"Sanjib Biswas" <sa***********@ ieee.org> wrote in message
news:Ok******** ******@TK2MSFTN GP05.phx.gbl...
Hi All,

I am looking for XML merging for the following scenarios. I want to load
both the input files and show in the tree viewer and highlight the
differences. Now its up to the user to select the correct node. Any non
conflicting differences should be automatically merge onto the merge
document. Any suggestion/caveats on how to do this in VB.Net?

Regards
Sanjib

doc1.xml |doc2.xml
======== |========
<data> |<data>
<product> | <product>
<title>MS Access</title> | <title>MS Access Suite</title>
<price>350.00 </price> | <price>350.00 </price>
</product> | </product>
<product> | <product>
<title>MS Outlook</title> | <title>MS Outlook</title>
<price>300.00 </price> | <price>250.00 </price>
</product> | </product>
<product> | <product>
<title>MS Office</title> | <title>MS Office</title>
<price>450.00 </price> | <price>450.00 </price>
</product> | </product>
</data> | <product>
| <title>MS Visual .Net</title>
| <price>310.00 </price>
| </product>
|</data>

merge.xml
=========
<data>
<product>
<title>select the title name based on the decision</title>
<price>350.00 </price>
</product>
<product>
<title>MS Outlook</title>
<price>select the price based on the decision</price>
</product>
<product>
<title>MS Office</title>
<price>450.00 </price>
</product>
<product>
<title>MS Visual .Net</title>
<price>310.00 </price>
</product>
</data>

[John Bailo]

I've built most of those structures for a database project of mine that
outputs into a color coded tree control (I used c#).

There are one or two articles on MSDN about loading an XML file into a
tree control using recursion.

There's probably a couple of ways to do it:

1. Merge the XML and then load.
2. Load doc1, then load the elements of doc2.xml

Either way, you would end up checking at the node level for a match to
product.

You can do some cool stuff with right clicks on tree nodes (another
article). I use them for opening up data driven menus.

You could do something like having the alterative price (where there are
two) be selectable with a right click on a green colored node. Then
the tree would refresh and the old price would be the alternative.

Sanjib Biswas wrote:

Hi All,

I am looking for XML merging for the following scenarios. I want to
load both the input files and show in the tree viewer and highlight the
differences. Now its up to the user to select the correct node. Any non
conflicting differences should be automatically merge onto the merge
document. Any suggestion/caveats on how to do this in VB.Net?

Regards
Sanjib

doc1.xml |doc2.xml
======== |========
<data> |<data>
<product> | <product>
<title>MS Access</title> | <title>MS Access Suite</title>
<price>350.00 </price> | <price>350.00 </price>
</product> | </product>
<product> | <product>
<title>MS Outlook</title> | <title>MS Outlook</title>
<price>300.00 </price> | <price>250.00 </price>
</product> | </product>
<product> | <product>
<title>MS Office</title> | <title>MS Office</title>
<price>450.00 </price> | <price>450.00 </price>
</product> | </product>
</data> | <product>
| <title>MS Visual .Net</title>
| <price>310.00 </price>
| </product>
|</data>

merge.xml
=========
<data>
<product>
<title>select the title name based on the decision</title>
<price>350.00 </price>
</product>
<product>
<title>MS Outlook</title>
<price>select the price based on the decision</price>
</product>
<product>
<title>MS Office</title>
<price>450.00 </price>
</product>
<product>
<title>MS Visual .Net</title>
<price>310.00 </price>
</product>
</data>

[Sanjib Biswas]

Hi John,

Thanks for the suggestions. I was trying to load the XML file in the TreeView. But I am getting an exception "Object reference no set" when parsing a node (red font) in the below XML file.

<?xml version="1.0" encoding="UTF-8"?>
<Data>
<xs:schema id="Data" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="Data" msdata:IsDataSe t="true" msdata:UseCurre ntLocale="true" msdata:Prefix=" mdb">
<xs:complexType >
<xs:choice minOccurs="0" maxOccurs="unbo unded">
<xs:element name="Employee" >
<xs:complexType >
<xs:sequence>
<xs:element name="empName" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
.......
.......

But with the same code, I am able to load the XML file into TreeView.

"John Bailo" <ja*****@texeme .com> wrote in message news:J_******** *************** *******@speakea sy.net...

I've built most of those structures for a database project of mine that
outputs into a color coded tree control (I used c#).

There are one or two articles on MSDN about loading an XML file into a
tree control using recursion.

There's probably a couple of ways to do it:

1. Merge the XML and then load.
2. Load doc1, then load the elements of doc2.xml

Either way, you would end up checking at the node level for a match to
product.

You can do some cool stuff with right clicks on tree nodes (another
article). I use them for opening up data driven menus.

You could do something like having the alterative price (where there are
two) be selectable with a right click on a green colored node. Then
the tree would refresh and the old price would be the alternative.

Sanjib Biswas wrote:

Hi All,

I am looking for XML merging for the following scenarios. I want to
load both the input files and show in the tree viewer and highlight the
differences. Now its up to the user to select the correct node. Any non
conflicting differences should be automatically merge onto the merge
document. Any suggestion/caveats on how to do this in VB.Net?

Regards
Sanjib

doc1.xml |doc2.xml
======== |========
<data> |<data>
<product> | <product>
<title>MS Access</title> | <title>MS Access Suite</title>
<price>350.00 </price> | <price>350.00 </price>
</product> | </product>
<product> | <product>
<title>MS Outlook</title> | <title>MS Outlook</title>
<price>300.00 </price> | <price>250.00 </price>
</product> | </product>
<product> | <product>
<title>MS Office</title> | <title>MS Office</title>
<price>450.00 </price> | <price>450.00 </price>
</product> | </product>
</data> | <product>
| <title>MS Visual ..Net</title>
| <price>310.00 </price>
| </product>
|</data>

merge.xml
=========
<data>
<product>
<title>select the title name based on the decision</title>
<price>350.00 </price>
</product>
<product>
<title>MS Outlook</title>
<price>select the price based on the decision</price>
</product>
<product>
<title>MS Office</title>
<price>450.00 </price>
</product>
<product>
<title>MS Visual .Net</title>
<price>310.00 </price>
</product>
</data>