Read XML file

[phabio]

Hi all,
I'm working with a XML file, but I've a problem..


I've a XML file with strange structure..

I' open the file:
lsFile = "C:\Users\Fabio\Documents\Lavoro\CEGEKA\Linak\Fatt ureInput\201812\LAVERDA XML.xml"
XQUERY_OPEN(lsFile)

I read all the nodes
oNodes = xquery_node("ConditionalArea")
? xml_decode(oNodes)

but I don't see all the nodes.. the nodes with the same name are skipped...

How can I read all the nodes?

thanks
Fabio

[barrymavin]

Why is this question in the Lianja App Center forum?

I will move it TO Visual FoxPro scripting in Lianja.

[barrymavin]

Please submit a ticket and attach the XML file.

[phabio]

Ok, thanks
Fabio

[barrymavin]

Please read the xquery doc again.

https://www.lianja.com/doc/index.php/XQUERY_OPEN()
https://www.lianja.com/doc/index.php/XQUERY_DECODE()
https://www.lianja.com/doc/index.php...Y_ATTRIBUTES()
https://www.lianja.com/doc/index.php/XQUERY_SELECT()

Example code to read your XML file using xquery notation.

xquery_open("c:\barry\LAVERDA XML.xml")
local cnt = xquery_count("/report/ConditionalArea/BodySalesTable")
for i=1 to cnt
    ? xquery_node("/report/ConditionalArea/BodySalesTable[&i]/LineHeader")
endfor
?
xquery_close()

And the output...

[phabio]

Hi Barry, thanks.
This is like my first test code.. but I've some subnode not present every time:
eg:
node1
subnode1-1
subnode2-1
node2
subnode1-2
subnode2-2
node3
node4
subnode1-4
node5
...
..


with this kind of file, I think the only solution is to be read the file witha a low level XML funcions...

loXML = CREATEOBJECT('MSXML2.DomDocument')

thanks
Fabio

[barrymavin]

Hi Barry, thanks.
This is like my first test code.. but I've some subnode not present every time:
eg:
node1
subnode1-1
subnode2-1
node2
subnode1-2
subnode2-2
node3
node4
subnode1-4
node5
...
..


with this kind of file, I think the only solution is to be read the file witha a low level XML funcions...

loXML = CREATEOBJECT('MSXML2.DomDocument')

thanks
Fabio

It’s all working for me and I gave you sample code. Your solution is windows only not cross platform. Rather than tell me it doesn’t work show me what doesn’t work. I already give you the doc links so you can better understand how the xquery functions work.

[phabio]

Ok,
but it's the ML file wryte in a wrong format..

thanks
Fabio

[phabio]

But now I try again..

thank

[phabio]

Just to know, Barry fixed a bug in record time and the creation of custom XML with the activex loXML = createobject ('MSXML2.DOMDocument') works perfectly.

Thanks Barry!