Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - comparing two XML's using XMLDOM, VBscript

Reply
 
Old 08-18-2008   #1 (permalink)
bnreddy99


 
 

comparing two XML's using XMLDOM, VBscript

Hi,

I wanted to compare two XML's using XMLDOM, VBScript like, taking one
value from one xml and comparing for the existance in 2nd xml.

Anyone please provide me the code for this. I am looking for the code
with XMLDOM objects, VBScript.

Thanks in advance.

- thanks

My System SpecsSystem Spec
Old 08-18-2008   #2 (permalink)
Anthony Jones


 
 

Re: comparing two XML's using XMLDOM, VBscript

<bnreddy99@xxxxxx> wrote in message
news:28360412-a4c0-4be0-b94c-673e79dc30c2@xxxxxx
Quote:

> Hi,
>
> I wanted to compare two XML's using XMLDOM, VBScript like, taking one
> value from one xml and comparing for the existance in 2nd xml.
>
> Anyone please provide me the code for this. I am looking for the code
> with XMLDOM objects, VBScript.
>
It might help if you posted some sample XML that you want to compare.





--
Anthony Jones - MVP ASP/ASP.NET


My System SpecsSystem Spec
Old 08-18-2008   #3 (permalink)
Rama


 
 

Re: comparing two XML's using XMLDOM, VBscript

On Aug 19, 2:29*am, "Anthony Jones" <A...@xxxxxx> wrote:
Quote:

> <bnredd...@xxxxxx> wrote in message
>
> news:28360412-a4c0-4be0-b94c-673e79dc30c2@xxxxxx
>
Quote:

> > Hi,
>
Quote:

> > I wanted to compare two XML's using XMLDOM, VBScript like, taking one
> > value from one xml and comparing for the existance in 2nd xml.
>
Quote:

> > Anyone please provide me the code for this. I am looking for the code
> > with XMLDOM objects, VBScript.
>
> It might help if you posted some sample XML that you want to compare.
>
> --
> Anthony Jones - MVP ASP/ASP.NET
Hi,

Any 2 XML's will work. but the script should be in a generic way that
should be able to compare.

I am new to this. Please provide me the solution for this.

one xml can be taken as below:
<?xml version="1.0" encoding="ISO-8859-1"?>
<bookstore>
<book category="cooking">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="children">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="web">
<title lang="en">XQuery Kick Start</title>
<author>James McGovern</author>
<author>Per Bothner</author>
<author>Kurt Cagle</author>
<author>James Linn</author>
<author>Vaidyanathan Nagarajan</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="web" cover="paperback">
<title lang="en">Learning XML</title>
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>


and another XML is as below:

<?xml version="1.0" encoding="ISO-8859-1"?>
<bookstore>
<book category="cooking">
<year>2005</year>
<author>Giada De Laurentiis</author>
<title lang="en">Everyday Italian</title>
<price>30.00</price>
</book>
<book category="children">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="web">
<title lang="en">XQuery Kick Start</title>
<author>James McGovern</author>
<author>Per Bothner</author>
<author>Kurt Cagle</author>
<author>James Linn</author>
<author>Vaidyanathan Nagarajan</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="web" cover="paperback">
<price>39.95</price>
<author>Erik T. Ray</author>
<year>2003</year>
<title lang="en">Learning XML</title>
</book>
</bookstore>

- Thanks
My System SpecsSystem Spec
Old 08-19-2008   #4 (permalink)
Joe Fawcett


 
 

Re: comparing two XML's using XMLDOM, VBscript

That's a tall order, a generic difference app. There are XML difference
utilities around, XmlDiff for example, but I doubt they are something one
could develop quickly as a favour.
You maybe lucky however

--

Joe Fawcett (MVP - XML)

http://joe.fawcett.name


"Rama" <gopi9999@xxxxxx> wrote in message
news:9262d852-911b-42dd-b227-52c525439a70@xxxxxx
On Aug 19, 2:29 am, "Anthony Jones" <A...@xxxxxx> wrote:
Quote:

> <bnredd...@xxxxxx> wrote in message
>
> news:28360412-a4c0-4be0-b94c-673e79dc30c2@xxxxxx
>
Quote:

> > Hi,
>
Quote:

> > I wanted to compare two XML's using XMLDOM, VBScript like, taking one
> > value from one xml and comparing for the existance in 2nd xml.
>
Quote:

> > Anyone please provide me the code for this. I am looking for the code
> > with XMLDOM objects, VBScript.
>
> It might help if you posted some sample XML that you want to compare.
>
> --
> Anthony Jones - MVP ASP/ASP.NET
Hi,

Any 2 XML's will work. but the script should be in a generic way that
should be able to compare.

I am new to this. Please provide me the solution for this.

one xml can be taken as below:
<?xml version="1.0" encoding="ISO-8859-1"?>
<bookstore>
<book category="cooking">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="children">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="web">
<title lang="en">XQuery Kick Start</title>
<author>James McGovern</author>
<author>Per Bothner</author>
<author>Kurt Cagle</author>
<author>James Linn</author>
<author>Vaidyanathan Nagarajan</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="web" cover="paperback">
<title lang="en">Learning XML</title>
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>


and another XML is as below:

<?xml version="1.0" encoding="ISO-8859-1"?>
<bookstore>
<book category="cooking">
<year>2005</year>
<author>Giada De Laurentiis</author>
<title lang="en">Everyday Italian</title>
<price>30.00</price>
</book>
<book category="children">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="web">
<title lang="en">XQuery Kick Start</title>
<author>James McGovern</author>
<author>Per Bothner</author>
<author>Kurt Cagle</author>
<author>James Linn</author>
<author>Vaidyanathan Nagarajan</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="web" cover="paperback">
<price>39.95</price>
<author>Erik T. Ray</author>
<year>2003</year>
<title lang="en">Learning XML</title>
</book>
</bookstore>

- Thanks


My System SpecsSystem Spec
Old 08-19-2008   #5 (permalink)
Anthony Jones


 
 

Re: comparing two XML's using XMLDOM, VBscript

"Joe Fawcett" <joefawcett@xxxxxx> wrote in message
news:e5B4V8cAJHA.4476@xxxxxx
Quote:

> That's a tall order, a generic difference app. There are XML difference
> utilities around, XmlDiff for example, but I doubt they are something one
> could develop quickly as a favour.
> You maybe lucky however
>

On top being a tall order, in real world use a generic xml difference tool
just doesn't have an application. I can't think why anyone would want one.

OTH, building some kind of 'diff gram' from two chunks of XML that follow
the same schema and have known semantic rules that can be used to determine
new, updated and deleted content might be more useful and achievable.


--
Anthony Jones - MVP ASP/ASP.NET


My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Comparing arrays PowerShell
How to do No hang up VBScript (nohup for VBScript) VB Script
Re: Hyper-V comparing Virtual Server
WebRequest POST XMLDOM Not XMLDOM.xml .NET General
Comparing strings - is it a bug? PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46