dBASE Windows API - using msxml

Author

using msxml

Tom Gormley

2005-12-13, 11:24 am

I am trying to use msxml to parse xml files.
Can anyone tell me what i am doing wrong.
The parser dosent return the data

The Xmp File is attached

This is the test Code

OpenXml("c:\","ocs-b2b-dispatch-response")

function openXML(sUrl,aDocNam
e)
* Use MsXml [DOM]
xmlDoc = new OleAutoClient("Msxml2.DOMDocument.3.0")
xmlDoc.async = False
xmlDoc.resolveExternals = False
xmlDoc.Load(sUrl - "\" - aDocname - ".xml")

* try get element
objElementList = xmlDoc. getElementsByTagName
("dispatchLine")
objElementList.ITEM(0) // RETURNS FALSE
* Try select nodes
objDispatchLines = xmldoc. selectnodes(Dispatch
Response + DispatchLine)

if objDispatchLines.context.hasChildNodes()
msgbox(\"has child nodes\")
else
msgbox(\"has no child nodes\")
endif
return

Tom Gormley

2005-12-13, 1:23 pm

First problem is that there a DTD referenced in the XML that is not available and has caused a parser error so the XML failed to load.

Added two lines to skip validation against DTD

xmlDoc.resolveExternals = false
xmlDoc.validateOnParse = false

before loading XML

Tom Gormley Wrote:

> I am trying to use msxml to parse xml files.
> Can anyone tell me what i am doing wrong.
> The parser dosent return the data
>
> The Xmp File is attached
>
> This is the test Code
>
> OpenXml("c:\","ocs-b2b-dispatch-response")
>
> function openXML(sUrl,aDocNam
e)
> * Use MsXml [DOM]
> xmlDoc = new OleAutoClient("Msxml2.DOMDocument.3.0")
> xmlDoc.async = False
> xmlDoc.resolveExternals = False
> xmlDoc.Load(sUrl - "\" - aDocname - ".xml")
>
>
> * try get element
> objElementList = xmlDoc. getElementsByTagName
("dispatchLine")
> objElementList.ITEM(0) // RETURNS FALSE
> * Try select nodes
> objDispatchLines = xmldoc. selectnodes(Dispatch
Response + DispatchLine)
>
> if objDispatchLines.context.hasChildNodes()
> msgbox(\"has child nodes\")
> else
> msgbox(\"has no child nodes\")
> endif
> return
>
> <?xml version="1.0" encoding="UTF-8"?><!DOCTYPE ocs-b2b-document-response SYSTEM "http://ocsnisa.enabler/ocs-b2b-document-response.dtd"><ocs-b2b-document-response><header><document-info><document-uid>ST00001-0000000123-2002-12-03 11:12:15.234</document-
uid>
> <document-date>2003-07-18 12:34:41.234</document-date>
> </document-info>
> </header>
> <body><document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948420202</dispatchNumber>
> <deliveryDate>2003-06-03</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>1238</ocsOrderNumber>
> <orderDate>2003-06-03</orderDate>
> <itemCodeDelivered>9341</itemCodeDelivered>
> < itemDescriptionDeliv
ered>WAFFLE CHIPS</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>750g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>750</ itemUnitWeightDelive
red>
> <quantityDelivered>50</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>13.57</nsp>
> <rsp>0</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948422202</dispatchNumber>
> <deliveryDate>2003-06-03</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>1238</ocsOrderNumber>
> <orderDate>2003-06-03</orderDate>
> <itemCodeDelivered>13403</itemCodeDelivered>
> < itemDescriptionDeliv
ered>4 GRADE A DUCKLING</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>3kg</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>1</ itemUnitWeightDelive
red>
> <quantityDelivered>27</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>22.92</nsp>
> <rsp>0</rsp>
> <unitsPerPack>1</unitsPerPack>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948419202</dispatchNumber>
> <deliveryDate>2003-05-19</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>607</ocsOrderNumber>
> < memberStoreOrderNumb
er>Test</ memberStoreOrderNumb
er>
> <orderDate>2003-05-14</orderDate>
> <itemCodeDelivered>15027</itemCodeDelivered>
> < itemDescriptionDeliv
ered>VEG CURRY & RICE</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>400g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>400</ itemUnitWeightDelive
red>
> <quantityDelivered>2</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>10.45</nsp>
> <rsp>.99</rsp>
> <unitsPerPack>100</unitsPerPack>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948421202</dispatchNumber>
> <deliveryDate>2003-06-03</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>1238</ocsOrderNumber>
> <orderDate>2003-06-03</orderDate>
> <itemCodeDelivered>14072</itemCodeDelivered>
> < itemDescriptionDeliv
ered>MINI KIEV 20F15</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>450g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>450</ itemUnitWeightDelive
red>
> <quantityDelivered>91</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>35.59</nsp>
> <rsp>0</rsp>
> <unitsPerPack>4</unitsPerPack>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948426202</dispatchNumber>
> <deliveryDate>2003-06-10</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>1567</ocsOrderNumber>
> <orderDate>2003-06-10</orderDate>
> <itemCodeDelivered>6035</itemCodeDelivered>
> < itemDescriptionDeliv
ered>CAULIFLOWER/PEAS/CAR</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>500g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>500</ itemUnitWeightDelive
red>
> <quantityDelivered>7</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>4.8</nsp>
> <rsp>.69</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948430202</dispatchNumber>
> <deliveryDate>2003-04-26</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>339</ocsOrderNumber>
> <orderDate>2003-05-08</orderDate>
> <itemCodeDelivered>14023</itemCodeDelivered>
> < itemDescriptionDeliv
ered>TURKEY DINOSAURS 10F</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>500g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>500</ itemUnitWeightDelive
red>
> <quantityDelivered>20</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>5.19</nsp>
> <rsp>0</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber></dispatchNumber>
> <deliveryDate>2003-04-24</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>1</dispatchLineId>
> <ocsOrderNumber>302</ocsOrderNumber>
> <orderDate>2003-05-08</orderDate>
> <itemCodeDelivered>1000525</itemCodeDelivered>
> < itemDescriptionDeliv
ered>WALLS CARTE D'OR COCONUT</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>1ltr</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>1</ itemUnitWeightDelive
red>
> <quantityDelivered>0</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>EA</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>1.7683</nsp>
> <rsp>0</rsp>
> <unitsPerPack>25</unitsPerPack>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber></dispatchNumber>
> <deliveryDate>2003-04-24</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>1</dispatchLineId>
> <ocsOrderNumber>302</ocsOrderNumber>
> <orderDate>2003-05-08</orderDate>
> <itemCodeDelivered>1000527</itemCodeDelivered>
> < itemDescriptionDeliv
ered>MACKIES HONEYCOMB HARVEST</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>1ltr</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>1</ itemUnitWeightDelive
red>
> <quantityDelivered>10</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>EA</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>1.5383</nsp>
> <rsp>0</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber></dispatchNumber>
> <deliveryDate>2003-04-24</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>1</dispatchLineId>
> <ocsOrderNumber>303</ocsOrderNumber>
> <orderDate>2003-05-08</orderDate>
> <itemCodeDelivered>1000525</itemCodeDelivered>
> < itemDescriptionDeliv
ered>WALLS CARTE D'OR COCONUT</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>1ltr</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>1</ itemUnitWeightDelive
red>
> <quantityDelivered>0</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>EA</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>1.7683</nsp>
> <rsp>0</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber></dispatchNumber>
> <deliveryDate>2003-06-23</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>1</dispatchLineId>
> <ocsOrderNumber>2084</ocsOrderNumber>
> < memberStoreOrderNumb
er>Test</ memberStoreOrderNumb
er>
> <orderDate>2003-06-19</orderDate>
> <itemCodeDelivered>10015</itemCodeDelivered>
> < itemDescriptionDeliv
ered>B/EYE 4 ORIG BEEFBURGERS PMP</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>227g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>227</ itemUnitWeightDelive
red>
> <quantityDelivered>1</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>EA</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>10.68</nsp>
> <rsp>.99</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948432202</dispatchNumber>
> <deliveryDate>2003-06-20</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>2054</ocsOrderNumber>
> < memberStoreOrderNumb
er>Test</ memberStoreOrderNumb
er>
> <orderDate>2003-06-19</orderDate>
> <itemCodeDelivered>10140</itemCodeDelivered>
> < itemDescriptionDeliv
ered>4 GAMMON GRILLS</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>340g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>340</ itemUnitWeightDelive
red>
> <quantityDelivered>9</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>1.59</nsp>
> <rsp>1.59</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber>948434202</dispatchNumber>
> <deliveryDate>2003-06-10</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>0</dispatchLineId>
> <ocsOrderNumber>1561</ocsOrderNumber>
> <orderDate>2003-06-10</orderDate>
> <itemCodeDelivered>14040</itemCodeDelivered>
> < itemDescriptionDeliv
ered>CC TURKEY BURGERS</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>283g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>283</ itemUnitWeightDelive
red>
> <quantityDelivered>44</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>KG</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>24.6</nsp>
> <rsp>1.35</rsp>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
> <document-response><docResponse><dispatchResponse><dispatchHeader><storeId>A03300</storeId>
> <dispatchNumber></dispatchNumber>
> <deliveryDate>2003-06-25</deliveryDate>
> <currencyId>GBP</currencyId>
> </dispatchHeader>
> <dispatchLine><dispatchLineId>1</dispatchLineId>
> <ocsOrderNumber>2124</ocsOrderNumber>
> <orderDate>2003-06-20</orderDate>
> <itemCodeDelivered>10136</itemCodeDelivered>
> < itemDescriptionDeliv
ered>B/EYE 4 PORK QUARTER POUNDERS</ itemDescriptionDeliv
ered>
> < itemPackDescDelivere
d>454g</ itemPackDescDelivere
d>
> < itemUnitWeightDelive
red>454</ itemUnitWeightDelive
red>
> <quantityDelivered>10</quantityDelivered>
> <innerEAN></innerEAN>
> <outerEAN></outerEAN>
> <weightedUnitMeasure>EA</weightedUnitMeasure>
> <weight>0</weight>
> <nsp>1.99</nsp>
> <rsp>1.99</rsp>
> <unitsPerPack>125</unitsPerPack>
> </dispatchLine>
>
> </dispatchResponse>
> </docResponse>
> </document-response>
>
> </body>
> </ocs-b2b-document-response>
>
>

Sponsored Links