By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,467 Members | 1,605 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,467 IT Pros & Developers. It's quick & easy.

Comparing XML Files

P: n/a
I'm asking for ideas how to compare XML files. The files are schema-based
"Test Logs". They will be generated by several different machines, and the
longer files could be 1000 lines.

Some differences are ok:
<computer>SPITFIRE</computer>
vs
<computer>ODIN</computer>
However most differences are NOT ok:
<results>Passed</results>
vs
<results>Failed</results>
Additionally, some children may not always be in the same order, but this is
ok.
I'm wondering if the test logs could be imported into Excel or Access and
(more easily) analyized. I hope is isn't a from-scratch C# or VB .NET
application.

Thoughts?

Thanks.

-- Mark
Nov 16 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Mark Jerde wrote:
I'm asking for ideas how to compare XML files. The files are schema-based
"Test Logs". They will be generated by several different machines, and the
longer files could be 1000 lines.

Some differences are ok:
<computer>SPITFIRE</computer>
vs
<computer>ODIN</computer>
However most differences are NOT ok:
<results>Passed</results>
vs
<results>Failed</results>
Additionally, some children may not always be in the same order, but this is
ok.
I'm wondering if the test logs could be imported into Excel or Access and
(more easily) analyized. I hope is isn't a from-scratch C# or VB .NET
application.

Thoughts?

Thanks.

-- Mark

Mark,

Sometimes, it's easier to write a little application to do the
comparison. .Net offers a rich library to parse the Xml files. You
surely could import it into Excel or Access , but even in that way, I
would suggest to write some scripts. Imagine if you have to do it a
thousand times, wouldn't it be nicer to write a simple application, and
double click it instead of going to File ->import -> ....

My two cents.

Jianwei
Nov 16 '05 #2

P: n/a
Mark,

Go to gotdotnet.com and look under tools at XML diff. It can easily be used
to get a set of difference information between 2 XML files.

HTH,

Matt
"Mark Jerde" <ma********@verizon.no.spam.net> wrote in message
news:u4**************@TK2MSFTNGP09.phx.gbl...
I'm asking for ideas how to compare XML files. The files are schema-based
"Test Logs". They will be generated by several different machines, and the longer files could be 1000 lines.

Some differences are ok:
<computer>SPITFIRE</computer>
vs
<computer>ODIN</computer>
However most differences are NOT ok:
<results>Passed</results>
vs
<results>Failed</results>
Additionally, some children may not always be in the same order, but this is ok.
I'm wondering if the test logs could be imported into Excel or Access and
(more easily) analyized. I hope is isn't a from-scratch C# or VB .NET
application.

Thoughts?

Thanks.

-- Mark

Nov 16 '05 #3

P: n/a
Thanks for the input, John & Matt.

I just ran the first complete test. The XML file is 4078 lines long. When
more tests are added that should grow to 6000 lines. I need to figure out
automation. ;-)

-- Mark

John Sun wrote:
Mark Jerde wrote:
I'm asking for ideas how to compare XML files. The files are
schema-based "Test Logs". They will be generated by several
different machines, and the longer files could be 1000 lines.

Some differences are ok:
<computer>SPITFIRE</computer>
vs
<computer>ODIN</computer>
However most differences are NOT ok:
<results>Passed</results>
vs
<results>Failed</results>
Additionally, some children may not always be in the same order, but
this is ok.
I'm wondering if the test logs could be imported into Excel or
Access and (more easily) analyized. I hope is isn't a from-scratch
C# or VB .NET application.

Thoughts?

Thanks.

-- Mark

Mark,

Sometimes, it's easier to write a little application to do the
comparison. .Net offers a rich library to parse the Xml files. You
surely could import it into Excel or Access , but even in that way, I
would suggest to write some scripts. Imagine if you have to do it a
thousand times, wouldn't it be nicer to write a simple application,
and double click it instead of going to File ->import -> ....

My two cents.

Jianwei

Nov 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.