How to compare numeric values between two xml files?

W

www

Hi,

I have a xml file, something like:

<?xml version="1.0" encoding="UTF-8"?>
<Series>
<header>
<type>accumulative</type>
<creationDate>2007-11-07</creationDate>
<creationTime>14:28:46</creationTime>
</header>
<event date="1985-09-01" flag="1" time="06:00:00" value="1.400"/>
<event date="1985-09-01" flag="1" time="12:00:00" value="2.500"/>
<event date="1985-09-01" flag="1" time="18:00:00" value="5.900"/>
<event date="1985-09-02" flag="1" time="00:00:00" value="3.000"/>
<Series>


Another xml file:

<?xml version="1.0" encoding="UTF-8"?>
<Series>
<header>
<type>accumulative</type>
<creationDate>2007-11-07</creationDate>
<creationTime>14:28:46</creationTime>
</header>
<event date="1985-09-01" flag="1" time="06:00:00" value="1.500"/>
<event date="1985-09-01" flag="1" time="12:00:00" value="2.600"/>
<event date="1985-09-01" flag="1" time="18:00:00" value="5.950"/>
<event date="1985-09-02" flag="1" time="00:00:00" value="3.100"/>
<Series>


I hope to compare, between the two files, date, time and value(in JUnit
test). Hopefully, when comparing the values, I can set some error
tolerance. Is there a way to do it? I don't want to extract substring
from each line, because the exact locations(the index) can be different
in next run.

Thank you very much.
 
R

Roedy Green

I hope to compare, between the two files, date, time and value(in JUnit
test). Hopefully, when comparing the values, I can set some error
tolerance. Is there a way to do it? I don't want to extract substring
from each line, because the exact locations(the index) can be different
in next run.

read the two trees using any one of a number of XML parsing
techniques.
You can then match dates by sort/compare or by putting the values into
a HashMap and looking for a duplicate from the other tree.

see http://mindprod.com/jgloss/xml.html
 
?

=?ISO-8859-1?Q?Arne_Vajh=F8j?=

www said:
I have a xml file, something like:

<?xml version="1.0" encoding="UTF-8"?>
<Series>
<header>
<type>accumulative</type>
<creationDate>2007-11-07</creationDate>
<creationTime>14:28:46</creationTime>
</header>
<event date="1985-09-01" flag="1" time="06:00:00" value="1.400"/>
<event date="1985-09-01" flag="1" time="12:00:00" value="2.500"/>
<event date="1985-09-01" flag="1" time="18:00:00" value="5.900"/>
<event date="1985-09-02" flag="1" time="00:00:00" value="3.000"/>
<Series>

Another xml file:

<?xml version="1.0" encoding="UTF-8"?>
<Series>
<header>
<type>accumulative</type>
<creationDate>2007-11-07</creationDate>
<creationTime>14:28:46</creationTime>
</header>
<event date="1985-09-01" flag="1" time="06:00:00" value="1.500"/>
<event date="1985-09-01" flag="1" time="12:00:00" value="2.600"/>
<event date="1985-09-01" flag="1" time="18:00:00" value="5.950"/>
<event date="1985-09-02" flag="1" time="00:00:00" value="3.100"/>
<Series>

I hope to compare, between the two files, date, time and value(in JUnit
test). Hopefully, when comparing the values, I can set some error
tolerance. Is there a way to do it? I don't want to extract substring
from each line, because the exact locations(the index) can be different
in next run.

I hope this will get you started.

Arne
 
?

=?ISO-8859-1?Q?Arne_Vajh=F8j?=

Arne said:
I hope this will get you started.

I forgot the code.

:)

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;

import org.apache.xpath.XPathAPI;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;

public class XmlDiff {
public static void main(String[] args) throws Exception {
DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
DocumentBuilder db = dbf.newDocumentBuilder();
Document doc1 = db.parse("C:\\ser1.xml");
Document doc2 = db.parse("C:\\ser2.xml");
NodeList events1 = doc1.getElementsByTagName("event");
for(int i = 0; i < events1.getLength(); i++) {
Element event1 = (Element) events1.item(i);
String d1 = event1.getAttribute("date");
String t1 = event1.getAttribute("time");
String v1 = event1.getAttribute("value");
Element event2 =
(Element)XPathAPI.selectSingleNode(doc2.getDocumentElement(),
"//Series/event[@date='" + d1 + "' and @time='" + t1 + "']");
if(event2 != null) {
String v2 = event2.getAttribute("value");
if(!v1.equals(v2)) {
System.out.println(d1 + " " + t1 + " changed from "
+ v1 + " to " + v2);
} else {
System.out.println(d1 + " " + t1 + " identical");
}
} else {
System.out.println(d1 + " " + t1 + " missing");
}
}
}
}

Arne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top