XML file

Hello to all.
I need to read/find tags/data in this xml file.
Can you help me with it.
I need to read more lines (sequence) :
<skf:Line>
<oa:Id>PCMF 151717 E</oa:Id>
<oa:EANUCC13>07316571890647</oa:EANUCC13>

and

<oa:OrderQuantity uom="PCE">100.000</oa:OrderQuantity>
<oa:ExtendedPrice currency="EUR">40.000</oa:ExtendedPrice>
<oa:BackOrderedQuantity uom="PCE">100.000</oa:BackOrderedQuantity>

Here is complette XML file. Thank you !
<?xml version="1.0" encoding="utf-8"?>
<skf:AcknowledgeSalesOrder xmlnsa="[www.openapplications.org]; xmlns:xsi="[www.w3.org]; xmlns:skf="[www.skf.com]; revision="3.1" environment="Production" lang="en-US">
<skf:ApplicationArea>
<skf:CreationDateTime>2020-06-04T00:36:09+02:00</skf:CreationDateTime>
</skf:ApplicationArea>
<skfataArea>
<oa:Acknowledge>
<oa:Code>Accepted</oa:Code>
</oa:Acknowledge>
<skfalesOrder>
<skf:Header>
<oaocumentIds>
<oaocumentId>
<oa:Id>20D0025283</oa:Id>
<oa:Revision>01</oa:Revision>
</oaocumentId>
</oaocumentIds>
<oaescription>1</oaescription>
<oaocumentReferences>
<skfalesOrderDocumentReference>
<oaocumentIds>
<skfellerDocumentId>
<oa:Id>20D0025283</oa:Id>
</skfellerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03T11:34:38</skfocumentDateTZ>
</skfalesOrderDocumentReference>
<skfurchaseOrderDocumentReference>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FCL 01-0306</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03</skfocumentDateTZ>
</skfurchaseOrderDocumentReference>
<skf:ReferenceInformation>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FABRIKA CEMENTA LUKAVAC</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
</skf:ReferenceInformation>
</oaocumentReferences>
<oa:ReasonCode>1</oa:ReasonCode>
<oa:TransportationTerm>
<oa:TermCode issuingAgency="undefined">75</oa:TermCode>
<oa:FreightTerms>CIP - 2020 KLOKOTNICA</oa:FreightTerms>
</oa:TransportationTerm>
<oaaymentTerms>
<oaescription>60 DAYS FROM DATE OF INVOICE</oaescription>
</oaaymentTerms>
<oaarties>
<skfellerParty active="false" oneTime="false">
<oaartyId>
<oa:Id>9469</oa:Id>
</oaartyId>
<oa:AlternatePartyIds>
<oa:CustomerPartyId>
<oa:Id>4</oa:Id>
</oa:CustomerPartyId>
</oa:AlternatePartyIds>
<oa:Name>SKF Eurotrade AB</oa:Name>
<oa:TaxId>SE556206761001</oa:TaxId>
<oa:Addresses>
<skfrimaryAddress>
<oa:City>Goteborg, Sweden</oa:City>
<oaostalCode>415 50</oaostalCode>
<skf:ISOCountryCode>SWE</skf:ISOCountryCode>
</skfrimaryAddress>
</oa:Addresses>
<oa:Contacts>
<skfalesPerson>
<oaerson>
<oaersonCode>MBE</oaersonCode>
<oaersonName>
<oa:FormattedName>Josipa Gavran</oa:FormattedName>
</oaersonName>
</oaerson>
<oaescription>Mithat Becirspahic</oaescription>
</skfalesPerson>
</oa:Contacts>
</skfellerParty>
<skf:CustomerParty active="false" oneTime="false">
<oaartyId>
<oa:Id>BOS2006</oa:Id>
</oaartyId>
<oa:AlternatePartyIds>
<oa:CustomerPartyId>
<oa:Id>9144</oa:Id>
</oa:CustomerPartyId>
</oa:AlternatePartyIds>
<oa:Name>CLK-INTERPROMET</oa:Name>
<oa:Currency>EUR</oa:Currency>
<oa:TaxId>.</oa:TaxId>
<oa:Addresses>
<skfrimaryAddress>
<oa:AddressLine>Klokotnica, Doboj-Istok</oa:AddressLine>
<oa:City>DOBOJ</oa:City>
<oaostalCode>74207</oaostalCode>
<skf:ISOCountryCode>BIH</skf:ISOCountryCode>
</skfrimaryAddress>
</oa:Addresses>
</skf:CustomerParty>
<skfhipToParty active="false" oneTime="false">
<oaartyId>
<oa:Id>01636</oa:Id>
</oaartyId>
<oa:Name>CLK-INTERPROMET</oa:Name>
<oa:Addresses>
<skfrimaryAddress>
<oa:AddressLine>KLOKOTNICA, DOBOJ-ISTOK</oa:AddressLine>
<oa:City>DOBOJ</oa:City>
<oaostalCode>74207</oaostalCode>
<skf:ISOCountryCode>BIH</skf:ISOCountryCode>
</skfrimaryAddress>
<skfhippingAddress>
<skfhipViaDescription>DTS - SCHWEINF.HUB - LOGWIN-BOS</skfhipViaDescription>
<skfhipViaCode>BS</skfhipViaCode>
</skfhippingAddress>
</oa:Addresses>
</skfhipToParty>
</oaarties>
<skf:EDI>
<skf:EDITradingPartner>BOS2006</skf:EDITradingPartner>
<skf:EDIMessageType>ORDRSP</skf:EDIMessageType>
<skf:EDIRemoteId>CLIB2BA</skf:EDIRemoteId>
</skf:EDI>
<skfocumentDateTimeTZ>2020-06-04T00:36:09+02:00</skfocumentDateTimeTZ>
<skf:TimeDifferenceFromGMT>+02:00</skf:TimeDifferenceFromGMT>
</skf:Header>
<skf:Line>
<oa:LineNumber>000001</oa:LineNumber>
<oa:OrderItem>
<oa:ItemIds>
<oaupplierItemId>
<oa:Id>PCMF 151717 E</oa:Id>
<oa:EANUCC13>07316571890647</oa:EANUCC13>
</oaupplierItemId>
<skf:CustomerItemId>
<oa:Id>PCMF 151717 E</oa:Id>
</skf:CustomerItemId>
</oa:ItemIds>
</oa:OrderItem>
<oa:OrderQuantity uom="PCE">100.000</oa:OrderQuantity>
<oa:ExtendedPrice currency="EUR">40.000</oa:ExtendedPrice>
<oa:BackOrderedQuantity uom="PCE">100.000</oa:BackOrderedQuantity>
<oaocumentReferences>
<skfalesOrderDocumentReference>
<oaocumentIds>
<skfellerDocumentId>
<oa:Id>20D0025283</oa:Id>
</skfellerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03T11:34:38</skfocumentDateTZ>
<skf:LineNumber>0001</skf:LineNumber>
<skf:LineNumberSpecial>A</skf:LineNumberSpecial>
</skfalesOrderDocumentReference>
<skfurchaseOrderDocumentReference>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FCL 01-0306</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03</skfocumentDateTZ>
<skf:LineNumber>1</skf:LineNumber>
</skfurchaseOrderDocumentReference>
</oaocumentReferences>
<skfackageCode>22</skfackageCode>
<skf:NetUnitPrice>
<oa:Amount currency="EUR">0.4000</oa:Amount>
<oaerQuantity uom="P">1.0000</oaerQuantity>
</skf:NetUnitPrice>
<skf:OrderLineExtension>
<skfispatchPointCode>E</skfispatchPointCode>
<skfispatchPointCodeDescription>SKF EUROPEAN DISTR. CENTR</skfispatchPointCodeDescription>
<skf:CountryOfManufacture>SVK</skf:CountryOfManufacture>
</skf:OrderLineExtension>
<skf:OrderLineStatus>
<skf:Code>RPI</skf:Code>
</skf:OrderLineStatus>
<skfcheduleCommon>
<skf:NeedDeliveryDateTZ>2020-06-03</skf:NeedDeliveryDateTZ>
<skfromisedDeliveryDateTZ>2020-06-15</skfromisedDeliveryDateTZ>
</skfcheduleCommon>
<skfackQuantity>25</skfackQuantity>
<skf:OriginalOrderQuantity uom="undefined">0</skf:OriginalOrderQuantity>
<skf:AcceptedQuantity uom="PCE">100.000</skf:AcceptedQuantity>
</skf:Line>
<skf:Line>
<oa:LineNumber>000002</oa:LineNumber>
<oa:OrderItem>
<oa:ItemIds>
<oaupplierItemId>
<oa:Id>PCM 151720 E</oa:Id>
<oa:EANUCC13>07316572196472</oa:EANUCC13>
</oaupplierItemId>
<skf:CustomerItemId>
<oa:Id>PCM 151720 E</oa:Id>
</skf:CustomerItemId>
</oa:ItemIds>
</oa:OrderItem>
<oa:OrderQuantity uom="PCE">100.000</oa:OrderQuantity>
<oa:ExtendedPrice currency="EUR">48.000</oa:ExtendedPrice>
<oa:BackOrderedQuantity uom="PCE">100.000</oa:BackOrderedQuantity>
<oaocumentReferences>
<skfalesOrderDocumentReference>
<oaocumentIds>
<skfellerDocumentId>
<oa:Id>20D0025283</oa:Id>
</skfellerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03T11:34:38</skfocumentDateTZ>
<skf:LineNumber>0002</skf:LineNumber>
<skf:LineNumberSpecial>A</skf:LineNumberSpecial>
</skfalesOrderDocumentReference>
<skfurchaseOrderDocumentReference>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FCL 01-0306</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03</skfocumentDateTZ>
<skf:LineNumber>2</skf:LineNumber>
</skfurchaseOrderDocumentReference>
</oaocumentReferences>
<skfackageCode>22</skfackageCode>
<skf:NetUnitPrice>
<oa:Amount currency="EUR">0.4800</oa:Amount>
<oaerQuantity uom="P">1.0000</oaerQuantity>
</skf:NetUnitPrice>
<skf:OrderLineExtension>
<skfispatchPointCode>E</skfispatchPointCode>
<skfispatchPointCodeDescription>SKF EUROPEAN DISTR. CENTR</skfispatchPointCodeDescription>
<skf:CountryOfManufacture>SVK</skf:CountryOfManufacture>
</skf:OrderLineExtension>
<skf:OrderLineStatus>
<skf:Code>RPI</skf:Code>
</skf:OrderLineStatus>
<skfcheduleCommon>
<skf:NeedDeliveryDateTZ>2020-06-03</skf:NeedDeliveryDateTZ>
<skfromisedDeliveryDateTZ>2020-06-15</skfromisedDeliveryDateTZ>
</skfcheduleCommon>
<skfackQuantity>25</skfackQuantity>
<skf:OriginalOrderQuantity uom="undefined">0</skf:OriginalOrderQuantity>
<skf:AcceptedQuantity uom="PCE">100.000</skf:AcceptedQuantity>
</skf:Line>
<skf:Line>
<oa:LineNumber>000003</oa:LineNumber>
<oa:OrderItem>
<oa:ItemIds>
<oaupplierItemId>
<oa:Id>23138 CCK/W33</oa:Id>
<oa:EANUCC13>07316577612137</oa:EANUCC13>
</oaupplierItemId>
<skf:CustomerItemId>
<oa:Id>23138 CCK/W33</oa:Id>
</skf:CustomerItemId>
</oa:ItemIds>
<oaescription>RCRB - MULTI ROW</oaescription>
<oaescription>RCRB - MULTI ROW</oaescription>
</oa:OrderItem>
<oa:OrderQuantity uom="PCE">2.000</oa:OrderQuantity>
<oa:ExtendedPrice currency="EUR">1148.980</oa:ExtendedPrice>
<oa:BackOrderedQuantity uom="PCE">2.000</oa:BackOrderedQuantity>
<oaocumentReferences>
<skfalesOrderDocumentReference>
<oaocumentIds>
<skfellerDocumentId>
<oa:Id>20D0025283</oa:Id>
</skfellerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03T11:34:38</skfocumentDateTZ>
<skf:LineNumber>0003</skf:LineNumber>
<skf:LineNumberSpecial>A</skf:LineNumberSpecial>
</skfalesOrderDocumentReference>
<skfurchaseOrderDocumentReference>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FCL 01-0306</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03</skfocumentDateTZ>
<skf:LineNumber>3</skf:LineNumber>
</skfurchaseOrderDocumentReference>
</oaocumentReferences>
<skfackageCode>12</skfackageCode>
<skf:NetUnitPrice>
<oa:Amount currency="EUR">574.4900</oa:Amount>
<oaerQuantity uom="P">1.0000</oaerQuantity>
</skf:NetUnitPrice>
<skf:OrderLineExtension>
<skfispatchPointCode>E</skfispatchPointCode>
<skfispatchPointCodeDescription>SKF EUROPEAN DISTR. CENTR</skfispatchPointCodeDescription>
<skf:CountryOfManufacture>SWE</skf:CountryOfManufacture>
</skf:OrderLineExtension>
<skf:OrderLineStatus>
<skf:Code>RPI</skf:Code>
</skf:OrderLineStatus>
<skfcheduleCommon>
<skf:NeedDeliveryDateTZ>2020-06-03</skf:NeedDeliveryDateTZ>
<skfromisedDeliveryDateTZ>2020-06-15</skfromisedDeliveryDateTZ>
</skfcheduleCommon>
<skfackQuantity>1</skfackQuantity>
<skf:OriginalOrderQuantity uom="undefined">0</skf:OriginalOrderQuantity>
<skf:AcceptedQuantity uom="PCE">2.000</skf:AcceptedQuantity>
</skf:Line>
<skf:Line>
<oa:LineNumber>000004</oa:LineNumber>
<oa:OrderItem>
<oa:ItemIds>
<oaupplierItemId>
<oa:Id>TS 38</oa:Id>
<oa:EANUCC13>07316577016867</oa:EANUCC13>
</oaupplierItemId>
<skf:CustomerItemId>
<oa:Id>TS 38</oa:Id>
</skf:CustomerItemId>
</oa:ItemIds>
</oa:OrderItem>
<oa:OrderQuantity uom="PCE">2.000</oa:OrderQuantity>
<oa:ExtendedPrice currency="EUR">107.640</oa:ExtendedPrice>
<oa:BackOrderedQuantity uom="PCE">2.000</oa:BackOrderedQuantity>
<oaocumentReferences>
<skfalesOrderDocumentReference>
<oaocumentIds>
<skfellerDocumentId>
<oa:Id>20D0025283</oa:Id>
</skfellerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03T11:34:38</skfocumentDateTZ>
<skf:LineNumber>0004</skf:LineNumber>
<skf:LineNumberSpecial>A</skf:LineNumberSpecial>
</skfalesOrderDocumentReference>
<skfurchaseOrderDocumentReference>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FCL 01-0306</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03</skfocumentDateTZ>
<skf:LineNumber>4</skf:LineNumber>
</skfurchaseOrderDocumentReference>
</oaocumentReferences>
<skfackageCode>12</skfackageCode>
<skf:NetUnitPrice>
<oa:Amount currency="EUR">53.8200</oa:Amount>
<oaerQuantity uom="P">1.0000</oaerQuantity>
</skf:NetUnitPrice>
<skf:OrderLineExtension>
<skfispatchPointCode>E</skfispatchPointCode>
<skfispatchPointCodeDescription>SKF EUROPEAN DISTR. CENTR</skfispatchPointCodeDescription>
<skf:CountryOfManufacture>SWE</skf:CountryOfManufacture>
</skf:OrderLineExtension>
<skf:OrderLineStatus>
<skf:Code>RPI</skf:Code>
</skf:OrderLineStatus>
<skfcheduleCommon>
<skf:NeedDeliveryDateTZ>2020-06-03</skf:NeedDeliveryDateTZ>
<skfromisedDeliveryDateTZ>2020-06-15</skfromisedDeliveryDateTZ>
</skfcheduleCommon>
<skfackQuantity>1</skfackQuantity>
<skf:OriginalOrderQuantity uom="undefined">0</skf:OriginalOrderQuantity>
<skf:AcceptedQuantity uom="PCE">2.000</skf:AcceptedQuantity>
</skf:Line>
<skf:Line>
<oa:LineNumber>000005</oa:LineNumber>
<oa:OrderItem>
<oa:ItemIds>
<oaupplierItemId>
<oa:Id>H 3138</oa:Id>
<oa:EANUCC13>07316577009067</oa:EANUCC13>
</oaupplierItemId>
<skf:CustomerItemId>
<oa:Id>H 3138</oa:Id>
</skf:CustomerItemId>
</oa:ItemIds>
<oaescription>ADAPTER SLEEVES</oaescription>
<oaescription>ADAPTER SLEEVES</oaescription>
</oa:OrderItem>
<oa:OrderQuantity uom="PCE">1.000</oa:OrderQuantity>
<oa:ExtendedPrice currency="EUR">138.450</oa:ExtendedPrice>
<oa:BackOrderedQuantity uom="PCE">1.000</oa:BackOrderedQuantity>
<oaocumentReferences>
<skfalesOrderDocumentReference>
<oaocumentIds>
<skfellerDocumentId>
<oa:Id>20D0025283</oa:Id>
</skfellerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03T11:34:38</skfocumentDateTZ>
<skf:LineNumber>0005</skf:LineNumber>
<skf:LineNumberSpecial>A</skf:LineNumberSpecial>
</skfalesOrderDocumentReference>
<skfurchaseOrderDocumentReference>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FCL 01-0306</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03</skfocumentDateTZ>
<skf:LineNumber>5</skf:LineNumber>
</skfurchaseOrderDocumentReference>
</oaocumentReferences>
<skfackageCode>12</skfackageCode>
<skf:NetUnitPrice>
<oa:Amount currency="EUR">138.4500</oa:Amount>
<oaerQuantity uom="P">1.0000</oaerQuantity>
</skf:NetUnitPrice>
<skf:OrderLineExtension>
<skfispatchPointCode>E</skfispatchPointCode>
<skfispatchPointCodeDescription>SKF EUROPEAN DISTR. CENTR</skfispatchPointCodeDescription>
</skf:OrderLineExtension>
<skf:OrderLineStatus>
<skf:Code>BOK</skf:Code>
</skf:OrderLineStatus>
<skfcheduleCommon>
<skf:NeedDeliveryDateTZ>2020-06-03</skf:NeedDeliveryDateTZ>
<skfromisedDeliveryDateTZ>2020-06-23</skfromisedDeliveryDateTZ>
</skfcheduleCommon>
<skfackQuantity>1</skfackQuantity>
<skf:OriginalOrderQuantity uom="undefined">0</skf:OriginalOrderQuantity>
<skf:AcceptedQuantity uom="PCE">1.000</skf:AcceptedQuantity>
</skf:Line>
<skf:Line>
<oa:LineNumber>000006</oa:LineNumber>
<oa:OrderItem>
<oa:ItemIds>
<oaupplierItemId>
<oa:Id>TS 38/6.15/16</oa:Id>
<oa:EANUCC13>07316572162507</oa:EANUCC13>
</oaupplierItemId>
<skf:CustomerItemId>
<oa:Id>TSA38</oa:Id>
</skf:CustomerItemId>
</oa:ItemIds>
</oa:OrderItem>
<oa:OrderQuantity uom="PCE">2.000</oa:OrderQuantity>
<oa:ExtendedPrice currency="EUR">221.060</oa:ExtendedPrice>
<oa:BackOrderedQuantity uom="PCE">2.000</oa:BackOrderedQuantity>
<oa:Note>Cancellation or Postponement will</oa:Note>
<oa:Note>not be accepted for this orderline.</oa:Note>
<oaocumentReferences>
<skfalesOrderDocumentReference>
<oaocumentIds>
<skfellerDocumentId>
<oa:Id>20D0025283</oa:Id>
</skfellerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03T11:34:38</skfocumentDateTZ>
<skf:LineNumber>0006</skf:LineNumber>
<skf:LineNumberSpecial>A</skf:LineNumberSpecial>
</skfalesOrderDocumentReference>
<skfurchaseOrderDocumentReference>
<oaocumentIds>
<skf:CustomerDocumentId>
<oa:Id>FCL 01-0306</oa:Id>
</skf:CustomerDocumentId>
</oaocumentIds>
<skfocumentDateTZ>2020-06-03</skfocumentDateTZ>
<skf:LineNumber>6</skf:LineNumber>
</skfurchaseOrderDocumentReference>
</oaocumentReferences>
<skfackageCode>12</skfackageCode>
<skf:NetUnitPrice>
<oa:Amount currency="EUR">110.5300</oa:Amount>
<oaerQuantity uom="P">1.0000</oaerQuantity>
</skf:NetUnitPrice>
<skf:OrderLineStatus>
<skf:Code>BOK</skf:Code>
</skf:OrderLineStatus>
<skfcheduleCommon>
<skf:NeedDeliveryDateTZ>2020-06-03</skf:NeedDeliveryDateTZ>
<skfromisedDeliveryDateTZ>2020-06-16</skfromisedDeliveryDateTZ>
</skfcheduleCommon>
<skfackQuantity>1</skfackQuantity>
<skf:OriginalOrderQuantity uom="undefined">0</skf:OriginalOrderQuantity>
<skf:AcceptedQuantity uom="PCE">2.000</skf:AcceptedQuantity>
</skf:Line>
</skfalesOrder>
</skfataArea>
</skf:AcknowledgeSalesOrder>

You can see how to do it in the examples of windev, check the Reading and writing in XML format and XML parser

Regards

Paulo Oliveira



Edited 1 time(s). Last edit at 06/05/2020 03:36PM by pao.

Hi IsmirB,

A base XML sample of a few lines should have been sufficient...

The solution:
Drop your XML file in the external descriptions in the Project Explorer.
Next drag and drop it from there into the code editor.

This will create a statement like this:

XMLDoc is XMLDocument <descriptiion="yourxmlfile"> = OpenXML(your real file)

Now you have all the intellisense stuff and you can access any element and node straight out of code.

You can even declare this for specific nodes.
XMLPart is XMLNode <description="yourXMlfile.node.subnode">

You can next easily do:

for each XMLPart of XMLDoc
   //Tag element
   somexmlvalue is string = xmltostring(XMLPart.ElementTag..value)
   //Attribute
   somexmlattribute is string = XMLPart.ElementTag:AttributeName..value
end

I hope this helps you out...
If not, RTFM I'ld say ;-)

Cheers,

Peter Holemans