I am having trouble figuring out ho

[squirrelman]

I am having trouble figuring out how to parse an xml name space file. I have an excerpt of the file below. I need to get total, fecha, folio, and serie out of the file and the normal parsing methods that I am used to programming.

You help is greatly appreciated!

<?xml version="1.0" encoding="UTF-8"?>
<cfdi:Comprobante NumCtaPago="5008" LugarExpedicion="RAMOS ARIZPE, COAHUILA" metodoDePago="NA" tipoDeComprobante="ingreso" total="4420.64" Moneda="USD" TipoCambio="1" subTotal="3810.9" certificado="MIIGWTCCBEGgN" sello="k7YXX8ni7A==" fecha="2016-12-21T08:10:04" folio="10749" serie="A" version="3.2" xsi:schemaLocation="

http://www.sat.gob.mx/cfd/3

http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv32.xsd"

xmlns:cfdi="

http://www.sat.gob.mx/cfd/3"

xmlns:xsi="

http://www.w3.org/2001/XMLSchema-instance">

 

[SkipVought]

Hi,

What have you tried?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[squirrelman]

Well...
What I have TRIED to do is something like what is written below, but I get only the initialized values in my output.

Inv_Total = 0
Inv_Date = ""
Inv_Number = ""
Series = ""

Set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.Async = "True"
xmlDoc.Load(f3.path)

Set colNodes=xmlDoc.selectNodes("//cfdi/Comprobante")

For Each objNode in colNodes
Inv_Total = objNode.Attributes.getNamedItem("total").Text
Inv_Date = objNode.Attributes.getNamedItem("fecha").Text
Inv_Number = objNode.Attributes.getNamedItem("folio").Text
Series = objNode.Attributes.getNamedItem("serie").Text
Next

a.WriteLine (Inv_Total & "," & Inv_Date & "," & Inv_Number & "," & Series)

 

[xwb]

1) end your data with />
2) Change the selectNodes parameter to "cfdi:Comprobante"

For reference on opening different versions of msxml, see

https://social.msdn.microsoft.com/F...ftxmldom-vs-msxml2domdocument30?forum=jscript

 

[squirrelman]

I do not understand your first point. I do know that all the other code runs correctly.

On your second point, when a I replace the code as you indicated I get a different error.

---------------------------
Windows Script Host
---------------------------
Script: D:\IFC\Load-Xref.vbs
Line: 95
Char: 5
Error: Object required: 'objNode.Attributes.getNamedItem(...)'
Code: 800A01A8
Source: Microsoft VBScript runtime error

---------------------------
OK
---------------------------

93 Set colNodes=xmlDoc.selectNodes("//cfdi/Comprobante")
94 For Each objNode in colNodes
95 Inv_Total = objNode.Attributes.getNamedItem("total").Text
96 Inv_Date = objNode.Attributes.getNamedItem("fecha").Text
97 Inv_Number = objNode.Attributes.getNamedItem("folio").Text
98 Series = objNode.Attributes.getNamedItem("serie").Text
99 Next

 

[squirrelman]

Sorry sent old bit of code:

93 Set colNodes=xmlDoc.selectNodes("//cfdi:Comprobante")