x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 137 subscribers
  • Views 3973 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
Rafi531

Reading the XML file using RDSEQ

Posted By

Hi there,

I am reading the XML file by using RDSEQ, but the problem here is its not reading line by line, instead its reading no. line at time.

Please advise !

  • 0
    Hi Rafi531, RDSEQ is a development function, so I don't think you meant to put that inside the SEI forum. I moved it to the general discussion forum instead. Please also have a look at the forum rules at your earliest convenience as well. Thanks for your participation in the forums.

    Bob
  • 0
    Hi Rafi531,

    What does it mean "instead its reading no. line at time"? Are you saying that you aren't able to read anything?

    Perhaps you can post a code example on a simplified XML file, along with the XML file? Also, if you can show us what is actually being read, that would be helpful too.

    Regards,

    Bob
  • 0 in reply to Delamater

    Hi Bob,

    Thanks for your reply.

    I mean to say that, I am not able to capture the Record separator for the XML file so in that case it is reading no. of lines at a time till the variable length...below is my code and also the xml file attached.

    Local Char XPRODUCT(250)

    adxirs= chr$(10)

    FILENAM=filpath("\\192.168.1.149\FOLDERS\DCCFR29\TMP\SALES_INVOICE","order",'XML')

    If !fstat Then

       Openi FILENAM

       Repeat

           Rdseq XPRODUCT

       Until fstat <> 0

    Openi

    Endif

    Fullscreen order.xml Download 
    <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
                               xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
                               xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
                              <soap:Body>
                                    <sh:StandardBusinessDocument xmlns:sh="http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader" xmlns:order="urn:ean.ucc:order:2" xmlns:eanucc="urn:ean.ucc:2" xmlns:ns0="http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><sh:StandardBusinessDocumentHeader><sh:HeaderVersion>2.4.0</sh:HeaderVersion><sh:Sender><sh:Identifier Authority="EAN.UCC">6001000000001</sh:Identifier></sh:Sender><sh:Receiver><sh:Identifier Authority="EAN.UCC">6004442000004</sh:Identifier></sh:Receiver><sh:DocumentIdentification><sh:Standard>EAN.UCC</sh:Standard><sh:TypeVersion>2.4</sh:TypeVersion><sh:InstanceIdentifier>356618849</sh:InstanceIdentifier><sh:Type>STANDARD MANUAL</sh:Type><sh:MultipleType>false</sh:MultipleType><sh:CreationDateAndTime>2016-03-31T10:22:22</sh:CreationDateAndTime></sh:DocumentIdentification></sh:StandardBusinessDocumentHeader><eanucc:message><entityIdentification><uniqueCreatorIdentification>4500009631</uniqueCreatorIdentification><contentOwner><gln>6001000000001</gln></contentOwner></entityIdentification><eanucc:transaction><entityIdentification><uniqueCreatorIdentification>4500009631</uniqueCreatorIdentification><contentOwner><gln>6001000000001</gln></contentOwner></entityIdentification><command><eanucc:documentCommand><documentCommandHeader type="ADD"><entityIdentification><uniqueCreatorIdentification>4500009631</uniqueCreatorIdentification><contentOwner><gln>6001000000001</gln></contentOwner></entityIdentification></documentCommandHeader><documentCommandOperand><order:order creationDateTime="2016-03-31T00:00:00" documentStatus="ORIGINAL"><orderIdentification><uniqueCreatorIdentification>4500009631</uniqueCreatorIdentification><contentOwner><gln>6001000000001</gln><additionalPartyIdentification><additionalPartyIdentificationValue /><additionalPartyIdentificationType>STANDARD MANUAL</additionalPartyIdentificationType></additionalPartyIdentification></contentOwner></orderIdentification><orderPartyInformation><seller><gln>6004442000004</gln><additionalPartyIdentification><additionalPartyIdentificationValue>1000000063</additionalPartyIdentificationValue><additionalPartyIdentificationType>BUYER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>Namaqua Wines SA PTY Ltd</additionalPartyIdentificationValue><additionalPartyIdentificationType>BUYER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>4020139574</additionalPartyIdentificationValue><additionalPartyIdentificationType>SELLER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType></additionalPartyIdentification></seller><buyer><gln>6001007031006</gln><additionalPartyIdentification><additionalPartyIdentificationValue>Western Cape Corporate</additionalPartyIdentificationValue><additionalPartyIdentificationType>BUYER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType></additionalPartyIdentification></buyer></orderPartyInformation><orderLogisticalInformation><shipToLogistics><shipTo><gln>6001007031046</gln><additionalPartyIdentification><additionalPartyIdentificationValue>WC04</additionalPartyIdentificationValue><additionalPartyIdentificationType>BUYER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>Kenilworth</additionalPartyIdentificationValue><additionalPartyIdentificationType>BUYER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>WC04</additionalPartyIdentificationValue><additionalPartyIdentificationType>DELIVERY_ID</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>KENILWORTH</additionalPartyIdentificationValue><additionalPartyIdentificationType>DELIVERY_NAME</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>KENILWORTH CENTRE DONCASTER STREET</additionalPartyIdentificationValue><additionalPartyIdentificationType>DELIVERY_STREET</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>KENILWORTH</additionalPartyIdentificationValue><additionalPartyIdentificationType>DELIVERY_CITY</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>7700</additionalPartyIdentificationValue><additionalPartyIdentificationType>DELIVERY_POSTALCODE</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>021 683 8055/6</additionalPartyIdentificationValue><additionalPartyIdentificationType>DELIVERY_TELEPHONE</additionalPartyIdentificationType></additionalPartyIdentification><additionalPartyIdentification><additionalPartyIdentificationValue>021 638 1277</additionalPartyIdentificationValue><additionalPartyIdentificationType>DELIVERY_FAX</additionalPartyIdentificationType></additionalPartyIdentification></shipTo></shipToLogistics><orderLogisticalDateGroup><requestedDeliveryDateAtUltimateConsignee><date>2016-04-07</date></requestedDeliveryDateAtUltimateConsignee></orderLogisticalDateGroup></orderLogisticalInformation><orderLineItem number="10"><requestedQuantity><value>2.000</value></requestedQuantity><netPrice><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>123.68</monetaryAmount></amount></netPrice><netAmount><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>282.00</monetaryAmount></amount></netAmount><tradeItemIdentification><gtin>16004442004047</gtin><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NMER</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NAMAQUA MERLOT 750ML</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>462620</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>6</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification></tradeItemIdentification></orderLineItem><orderLineItem number="20"><requestedQuantity><value>2.000</value></requestedQuantity><netPrice><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>123.68</monetaryAmount></amount></netPrice><netAmount><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>282.00</monetaryAmount></amount></netAmount><tradeItemIdentification><gtin>16004442003309</gtin><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NPIN</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NAMAQUA PINOTAGE 750ML</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>462621</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>6</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification></tradeItemIdentification></orderLineItem><orderLineItem number="30"><requestedQuantity><value>2.000</value></requestedQuantity><netPrice><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>123.68</monetaryAmount></amount></netPrice><netAmount><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>282.00</monetaryAmount></amount></netAmount><tradeItemIdentification><gtin>16004442003316</gtin><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NSHIR</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NAMAQUA SHIRAZ 750ML</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>462692</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>6</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification></tradeItemIdentification></orderLineItem><orderLineItem number="40"><requestedQuantity><value>2.000</value></requestedQuantity><netPrice><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>123.68</monetaryAmount></amount></netPrice><netAmount><amount><currencyCode><currencyISOCode>ZAR</currencyISOCode></currencyCode><monetaryAmount>282.00</monetaryAmount></amount></netAmount><tradeItemIdentification><gtin>16004442004054</gtin><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NCAB</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>NAMAQUA CABERNET SAUVIGNON 750ML</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>462693</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>BUYER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification><additionalTradeItemIdentification><additionalTradeItemIdentificationValue>6</additionalTradeItemIdentificationValue><additionalTradeItemIdentificationType>SUPPLIER_ASSIGNED</additionalTradeItemIdentificationType></additionalTradeItemIdentification></tradeItemIdentification></orderLineItem><orderHeaderIndicator><isApplicationReceiptAcknowledgementRequired>true</isApplicationReceiptAcknowledgementRequired><isOrderFreeOfExciseTaxDuty>false</isOrderFreeOfExciseTaxDuty></orderHeaderIndicator></order:order></documentCommandOperand></eanucc:documentCommand></command></eanucc:transaction></eanucc:message></sh:StandardBusinessDocument>
                              </soap:Body>
                            </soap:Envelope>

*Community Hub is the new name for Sage City