Reading xml attributes in java

[Eduardo Ponce de Leon]

I am tryin to read this xml file...

<?xml version="1.0" encoding="UTF-8"?>
<Comprobante xmlns:cfdi="http://www.sat.gob.mx/cfd/3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="3.0"
serie="UNICA" folio="779" fecha="2011-12-05T18:24:42"
sello="..."
formaDePago="PAGO EN UNA SOLA EXHIBICION" noCertificado="00001000000102160027" condicionesDePago="EFECTOS FISCALES AL PAGO"
subTotal="5123.23" total="5942.95" Moneda="USD" tipoDeComprobante="ingreso"
xsi:schemaLocation="http://www.sat.gob.mx/cfd/3 http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv3.xsd">
<Emisor rfc="TIA050408342" nombre="TECNOLOGIAS DE INFORMACION AMERICA S.A. DE C.V.">
<DomicilioFiscal calle="Montecito" noExterior="38" noInterior="P 32-5" colonia="Napoles" localidad="Distrito Federal"
municipio="Distrito Federal" estado="México" pais="Mex." codigoPostal="03810" />
</Emisor>
<Addenda>
<ElementosClientesNormales xmlns:ext="http://www.buzone.com.mx/XSD/Sender19877/A"
xsi:schemaLocation="http://www.buzone.com.mx/XSD/Sender19877/A http://www.buzone.com.mx/XSD/Sender19877/A/Addenda.xsd">
<Conector>TEX9302097F3</Conector>
<CadenaOriginal>...about 1000 characters...</CadenaOriginal>
<IdDoc>8A2CFD3A-298B-4A6F-BB3C-8CB23604B1EB</IdDoc>
<Sender>29142</Sender>
<datosHeader ePagWeb="www.ti-america.com" eTelefono="(222) 273 21 00" />
<datosPartida cantidad="1" unidadMedida="Servicio"
descripcion="Servicios Administrados, equipamiento central para enlaces VPN..."
precioUnitario="1522.36" tipoMoneda="USD" importe="1522.36" />
<datosPartida cantidad="13" unidadMedida="Servicio"
descripcion="... several hundred characters ..." precioUnitario="276.99" tipoMoneda="USD" importe="3600.87" />
<datosFooter subtotalAddenda="5123.23" totalAddenda="5942.95" total_ImpuestosTrasladadosAddenda="819.72" tasaAddenda="16"
cantidadLetra="( CINCO MIL NOVECIENTOS CUARENTA Y DOS DOLARES 95/100 )" tipoMoneda="USD" />
<datosFemsa noProveedor="Cuentas en Bancomer a nombre de: Tecnologías de Información América, S.A. de C.V."
noPedido="Cuenta M.N.: 0149333274 CLABE: 012650001493332748" noRea="Cuenta USD: 0150843156 CLABE: 012650001508431563"
noRemision="Proyecto: MTL303-0502" noSocio="SERVICIOS ADMINISTRADOS, PERIODO DEL 1 AL 31 DE DICIEMBRE DEL 2011" />
</ElementosClientesNormales>
</Addenda>
</Comprobante>

I basically want to know how to get this value folio="779" from the xml file in java...
This is what I have in my code...pretty basic, i am using an example online. I will be extracting about 5 values from that file, If you can help me on how to get one, I am sure I can work my logic to get the other values.

 try {
File file = new File("c:\\TI AMERICA.xml");
DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
DocumentBuilder db = dbf.newDocumentBuilder();
Document doc = db.parse(file);
doc.getDocumentElement().normalize();
// System.out.println("Root element " + doc.getDocumentElement().getNodeName());
NodeList nodeLst = doc.getElementsByTagName("Comprobante");
for (int s = 0; s < nodeLst.getLength(); s++) {
Node fstNode = nodeLst.item(s);
if (fstNode.getNodeType() == Node.ELEMENT_NODE) {
Element fstElmnt = (Element) fstNode;
NodeList fstNmElmntLst = fstElmnt.getElementsByTagName("certificado");
Element fstNmElmnt = (Element) fstNmElmntLst.item(0);
NodeList fstNm = fstNmElmnt.getChildNodes();
System.out.println("Folio : " + ((Node) fstNm.item(0)).getNodeValue());
}
}
} catch (Exception e) {
e.printStackTrace();
}

[Paul Clapham]

Step 1... find elements named "Comprobante". You did that.

Step 2... cast them from Node to Element. You did that.

Step 3... get the "folio" attribute from that Element. But you have code which is looking for descendant elements named "certificado"? You don't need that. You already have an Element, just get whichever attribute you need. Hint: look at the API documentation for Element and see how to get attributes from an Element.

[Eduardo Ponce de Leon]

Paul,
Thanks for the reply... I was able to get an attribute "folio" g, that is under <comprobante> tag. Now my question is do I need to repeat the same steps for attributes in different tags...
so I did this for TAG # 1, do I need to repeat the whole thing for TAG # 2, if the other value I want is under <conceptos>??

 NodeList nodeLst = doc.getElementsByTagName("Comprobante");
for (int s = 0; s < nodeLst.getLength(); s++) {
Node fstNode = nodeLst.item(s);
if (fstNode.getNodeType() == Node.ELEMENT_NODE) {
Element fstElmnt = (Element) fstNode;
// NodeList fstNmElmntLst = fstElmnt.getElementsByTagName("folio");
// Element fstNmElmnt = (Element) fstNmElmntLst.item(0);
System.out.println("Folio : " + fstElmnt.getAttribute("folio"));
}

[Paul Clapham]

You have to navigate to the data you want to extract, yes. (But what a question! How could the answer possibly be "No"?)

[Eduardo Ponce de Leon]

Paul,
I have tried this and I am not being able to get the value I want... I am using the same .xml file!

for (int i = 0; i < pathOfFolder.length; i++) {
name = pathOfFolder[i].toString();
File fXmlFile = new File(pathOfFolder[i].toString());
name = pathOfFolder[i].getName();
name = name.replace(".xml", "");
PrintStream newFile = new PrintStream(new FileOutputStream(FACTURAS_FOLDER + name
+ ".csv"));
System.out.println("Procesando...");
// FACTURA TI AMERICA
if (pathOfFolder[i].getName().contains("TI AMERICA")) {
DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
DocumentBuilder db = dbf.newDocumentBuilder();
Document doc = db.parse(fXmlFile);
doc.getDocumentElement().normalize();
// System.out.println("Root element " +
// doc.getDocumentElement().getNodeName());
NodeList nodeLst = doc.getElementsByTagName("Comprobante");
for (int s = 0; s < nodeLst.getLength(); s++) {
Node fstNode = nodeLst.item(s);
if (fstNode.getNodeType() == Node.ELEMENT_NODE) {
Element fstElmnt = (Element) fstNode;
newFile.println("Folio,Fecha");
newFile.println(fstElmnt.getAttribute("folio") + ","
+ fstElmnt.getAttribute("fecha"));
}
}
nodeLst = doc.getElementsByTagName("Conceptos");
for (int s = 0; s < nodeLst.getLength(); s++) {
Node fstNode = nodeLst.item(s);
if (fstNode.getNodeType() == Node.ELEMENT_NODE) {
Element fstElmnt = (Element) fstNode;
newFile.println("Cantidad,Unidad");
newFile.println(fstElmnt.getAttribute("cantidad") + ","
+ fstElmnt.getAttribute("unidad"));
}
}
}
}

[Paul Clapham]

You are looking for an element named "Conceptos". The XML document you posted doesn't contain any elements named "Conceptos". It doesn't even contain that word anywhere. So I have no idea what you are trying to do. Perhaps you could explain why you thought that would be a good idea? I'm completely confused.

[Roberto Perillo]

Eduardo, I know this is not the answer you are looking for, but you would ease your life a lot if you used Jaxb.

[William Brogden]

My feeling is that JAXB is vastly overrated and not applicable here.

To extract a single value from an XML document, the standard API is all you need. Use XPath if you want to minimize the number of statements at the cost of extra execution time.

Bill

[Roberto Perillo]

 

William Brogden wrote:My feeling is that JAXB is vastly overrated and not applicable here.

I'd say this is a matter of taste then. I'd certainly go for Jaxb.

[Eduardo Ponce de Leon]

Paul,
You are certainly right... the xml file I posted is a different version than the one I am now trying... here it is to prove that I cant get that element from the file..

<?xml version="1.0" encoding="UTF-8"?>
<Comprobante certificado="(junk)" xmlns:cfdi="http://www.sat.gob.mx/cfd/3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="3.0"
serie="UNICA" folio="779" fecha="2011-12-05T18:24:42" sello="(junk)" formaDePago="PAGO EN UNA SOLA EXHIBICION"
noCertificado="00001000000102160027" condicionesDePago="EFECTOS FISCALES AL PAGO" subTotal="5123.23" total="5942.95" Moneda="USD"
tipoDeComprobante="ingreso" xsi:schemaLocation="http://www.sat.gob.mx/cfd/3 http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv3.xsd">
<Emisor rfc="TIA050408342" nombre="TECNOLOGIAS DE INFORMACION AMERICA S.A. DE C.V.">
<DomicilioFiscal calle="Montecito" noExterior="38" noInterior="P 32-5" colonia="Napoles" localidad="Distrito Federal"
municipio="Distrito Federal" estado="México" pais="Mex." codigoPostal="03810" />
</Emisor>
<Receptor rfc="TEX9302097F3" nombre="TIENDAS EXTRA S.A. DE C.V.">
<Domicilio calle="JAVIER BARROS SIERRA" noExterior="555" noInterior="PISO 2" colonia="ZEDEC ED. PLAZA SANTA FE" municipio="MEXICO"
estado="DISTRITO FEDERAL" pais="MEXICO" codigoPostal="01210" />
</Receptor>
<Conceptos>
<Concepto cantidad="1" unidad="Servicio" descripcion="(junk)" valorUnitario="1522.36" importe="1522.36" />
<Concepto cantidad="13" unidad="Servicio" descripcion="(junk)" valorUnitario="276.99" importe="3600.87" />
</Conceptos>
<Impuestos totalImpuestosTrasladados="819.72">
<Traslados>
<Traslado impuesto="IVA" tasa="16.00" importe="819.72" />
</Traslados>
</Impuestos>
<Complemento>
<tfd:TimbreFiscalDigital version="1.0" UUID="8A2CFD3A-298B-4A6F-BB3C-8CB23604B1EB" FechaTimbrado="2011-12-05T18:24:44" selloCFD="(junk)"
noCertificadoSAT="00001000000102629688" selloSAT="(junk)"
xsi:schemaLocation="http://www.sat.gob.mx/TimbreFiscalDigital http://www.sat.gob.mx/TimbreFiscalDigital/TimbreFiscalDigital.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tfd="http://www.sat.gob.mx/TimbreFiscalDigital" />
</Complemento>
<Addenda>
<ext:ElementosClientesNormales xmlns:ext="http://www.buzone.com.mx/XSD/Sender19877/A"
xsi:schemaLocation="http://www.buzone.com.mx/XSD/Sender19877/A http://www.buzone.com.mx/XSD/Sender19877/A/Addenda.xsd">
<ext:Conector>TEX9302097F3</ext:Conector>
<ext:CadenaOriginal>(junk)</ext:CadenaOriginal>
<ext:IdDoc>8A2CFD3A-298B-4A6F-BB3C-8CB23604B1EB</ext:IdDoc>
<ext:Sender>29142</ext:Sender>
<ext:datosHeader ePagWeb="www.ti-america.com" eTelefono="(222) 273 21 00" />
<ext:datosPartida cantidad="1" unidadMedida="Servicio" descripcion="(junk)" precioUnitario="1522.36" tipoMoneda="USD" importe="1522.36" />
<ext:datosPartida cantidad="13" unidadMedida="Servicio" descripcion="(junk)" precioUnitario="276.99" tipoMoneda="USD" importe="3600.87" />
<ext:datosFooter subtotalAddenda="5123.23" totalAddenda="5942.95" total_ImpuestosTrasladadosAddenda="819.72" tasaAddenda="16"
cantidadLetra="( CINCO MIL NOVECIENTOS CUARENTA Y DOS DOLARES 95/100 )" tipoMoneda="USD" />
<ext:datosFemsa noProveedor="Cuentas en Bancomer a nombre de: Tecnologías de Información América, S.A. de C.V."
noPedido="Cuenta M.N.: 0149333274 CLABE: 012650001493332748" noRea="Cuenta USD: 0150843156 CLABE: 012650001508431563"
noRemision="Proyecto: MTL303-0502" noSocio="SERVICIOS ADMINISTRADOS, PERIODO DEL 1 AL 31 DE DICIEMBRE DEL 2011" />
</ext:ElementosClientesNormales>
</Addenda>
</Comprobante>

@Roberto
Thank you for the link, I will look at it and bother you if a have questions.

[Eduardo Ponce de Leon]

Any help here....still stuck trying to read differente tags from the same file...

[Joanne Neal]

JAXB was suggested earlier. Have you tried that ?

[Eduardo Ponce de Leon]

 

Joanne Neal wrote:JAXB was suggested earlier. Have you tried that ?

I am struggling with it.. moving slowly!

[Eduardo Ponce de Leon]

I dont think it will work because the .xml files that I am intendind to read are invoices that change month to month...So waht I am tryin gto do is get the information that I need from the invoices so that I can process it and add it to my DB. with JAXB I think i need to creat xml scheme definitions files for every file, seems a lot of work for what I am trying to achieve.

[Joanne Neal]

So are you saying that the tag names and attribute names can change from month to month ?

[Eduardo Ponce de Leon]

Joanne,
I think it can change only on the number of attribues....ie.

 <Conceptos>
<Concepto cantidad="1" unidad="Servicio" descripcion="..." valorUnitario="1522.36" importe="1522.36" />
<Concepto cantidad="13" unidad="Servicio" descripcion="..." valorUnitario="276.99" importe="3600.87" />
</Conceptos> 

Maybe from month to month...instead of having 2 services being billed, there may be 3...but I dont think that would matter much, am I right...

That is why I am trying to stick to what I have, its just that I cant figure out how to get more than one tag name and attributes.

[Roberto Perillo]

Right Eduardo, but are they optional (and the set of attributes is well known) or they are pretty new? For instance, this month we had <Concepto cantidad="13"> and next month we can have <Concepto totallyUnexpectedAttribute="13">?

[Eduardo Ponce de Leon]

Roberto,
The attributes are well known. I dont think the names would change, so far, they havent! I am comparing files...

[Paul Clapham]

 

Eduardo Ponce de Leon wrote:Paul,
You are certainly right... the xml file I posted is a different version than the one I am now trying... here it is to prove that I cant get that element from the file.

You haven't proved that at all. Your code will certainly find those <Conceptos> elements. However it won't find the "cantidad" and "calidad" attributes because those elements don't have any such attributes. The <Concepto> elements do have those attributes, but your code doesn't look for them.

By the way I have edited the XML you posted so that it isn't seven screens wide. Unfortunately the code tags don't let the data wrap onto new lines like text does -- that's not your fault. Hopefully now it's possible to read what people have typed without having to scroll horizontally.

[Eduardo Ponce de Leon]

Paul,
I get what you are saying...but I cant seem to figure out how to get attributes from difererent tagnames...
for example everything in <Conceptos> and <Impuestos>

<Conceptos>
<Concepto cantidad="1" unidad="Servicio" descripcion="..." valorUnitario="1522.36" importe="1522.36" />
</Conceptos>
<Impuestos totalImpuestosTrasladados="819.72">
<Traslados>
<Traslado impuesto="IVA" tasa="16.00" importe="819.72" />
</Traslados>
</Impuestos> 

that is my main issue...

[Paul Clapham]

You just navigate to the element which contains the attribute, and then get the attributes from that element. Navigating to a parent element is useless.

[Eduardo Ponce de Leon]

ok guys... with this code...

try {
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
DocumentBuilder builder = factory.newDocumentBuilder();
Document document = builder.parse("D:\\Facturas\\TI AMERICA.xml");
Node root = document.getDocumentElement();
System.out.print("Root Node:" + root.getNodeName());
NodeList childNodes = root.getChildNodes();
System.out.println("Child: " + childNodes);
Node currentNode;
for (int i = 0; i < childNodes.getLength(); i++) {
currentNode = childNodes.item(i);
if (currentNode.getNodeName() != "#text") {
System.out.println(currentNode.getNodeName());
}
if (currentNode.getAttributes() != null) {
for (int x = 0; x < currentNode.getAttributes().getLength(); x++) {
System.out.println(currentNode.getAttributes().item(x).getNodeName() + ": "
+ currentNode.getAttributes().item(x).getNodeValue());
}
}
}

I am able to get this info...

<Emisor rfc="TIA050408342" nombre="TECNOLOGIAS DE INFORMACION AMERICA S.A. DE C.V."></Emisor>

but then... how go on and get this from inside <Emisor/>

<DomicilioFiscal calle="Montecito" noExterior="38" noInterior="P 32-5" colonia="Napoles" localidad="Distrito Federal"
municipio="Distrito Federal" estado="México" pais="Mex." codigoPostal="03810" />

any hints...

[Paul Clapham]

I don't see why you need hints. You have posted code which does that.

So you have an Element object which represents your <Emisor> element, correct? And the <DomicilioFiscal> element is a child of that element, correct? You have already used the getElementsByTagName method earlier; why not use it again?

[Eduardo Ponce de Leon]

ok...so I cant get the childs...I am stuck trying to get "cantidad,unidad".
I am able to get the name of <Concepto> but that is it...

 <Conceptos>
<Concepto cantidad="1" unidad="Servicio" descripcion="..." />
<Concepto cantidad="13" unidad="Servicio" descripcion="..." />
</Conceptos>

this is my code...

 for (int w = 0; w < files.length; w++) { // filesfor
Document document = builder.parse(files[w]);
Node root = document.getDocumentElement();
Node currentNode = null;
NodeList nodeList = root.getChildNodes();
// ROOT
System.out.println("Root Node:" + root.getNodeName());
if (root.getNodeName().equals("Comprobante")) {
for (int i = 0; i < nodeList.getLength(); i++) {
nodeList = document.getElementsByTagName("Comprobante");
NamedNodeMap child = document.getAttributes();
if (child != null) {
System.out.println(child.item(0));
}
for (int s = 0; s < nodeList.getLength(); s++) {
Node fstNode = nodeList.item(s);
if (fstNode.getNodeType() == Node.ELEMENT_NODE) {
Element fstElmnt = (Element) fstNode;
// System.out.println("Folio,Fecha");
System.out.println(fstElmnt.getAttribute("folio") + "-"
+ fstElmnt.getAttribute("fecha"));
}
}
}
nodeList = root.getChildNodes();
for (int i = 0; i < nodeList.getLength(); i++) {
currentNode = nodeList.item(i);
// System.out.println(currentNode.getAttributes().item(i).getNodeName());
if (currentNode.getNodeName() == "Conceptos") {
if (currentNode.getAttributes() != null) {
HERE IS WHERE I AM SUPPOSED TO GET THE VALUES I WANT
}
}
}
}
}

PLEASE HELP!!!

[Paul Clapham]

if (currentNode.getNodeName() == "Conceptos")

Don't use the == operator to compare the contents of two String objects. That just tells you whether the two Strings are the same object, whereas it's possible for many different String objects to contain the same data. Use the equals() method:

if (currentNode.getNodeName().equals("Conceptos"))

[Eduardo Ponce de Leon]

Paul,
if I do as you say I never get inside my loop.