[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] How do I properly extract data from different sections - XML file


Subject: [xsl] How do I properly extract data from different sections - XML file
From: "Catherine Wilbur cwilbur@xxxxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 21 Oct 2014 16:03:21 -0000

Here is XML file coming out of an Alma Library system - do not need all 
these fields just highlighted fields required. 

< ?xml version="1.0"?>
< payment_data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns="http://com/exlibris/repository/acq/invoice/xmlbeans">
<invoice_list>
<invoice>
<invoice_number>PO-305</invoice_number>
<approved_by>Belanger Patricia</approved_by>
<invoice_amount>
<currency>USD</currency>
<sum>22</sum>
</invoice_amount>
<vendor_code>ABE</vendor_code>
<vendor_name>ABEBOOKS</vendor_name>
<vendor_FinancialSys_Code xsi:nil="true"/>
<vendor_liable_for_vat>false</vendor_liable_for_vat>
<vendor_payment_address_list>
<payment_address preferred="true">
<line1>ABE Overall Vendor Address</line1>
<line2 xsi:nil="true"/>
<line3 xsi:nil="true"/>
<line4 xsi:nil="true"/>
<line5 xsi:nil="true"/>
<city>Toronto</city>
<country>CAN</country>
<note>adding overall address</note>
<postalCode xsi:nil="true"/>
<stateProvince>ON</stateProvince>
<types>
<type> Billing</type>
<type>Claim</type>
<type>Order</type>
<type>Payment</type>
<type>Returns</type>
<type>Shipping</type>
</types>
</payment_address>
</vendor_payment_address_list>
<unique_identifier>2014082450002181</unique_identifier>
<invoice_date>07/24/2014</invoice_date>
<payment_method>ACCOUNTINGDEPARTMENT</payment_method>
<noteList>
<note>
<content>PrePaid</content>
<owneredEntity>
<createdBy>Sandboxpbelanger</createdBy>
<creationDate>20140724</creationDate>
<customerId>2180</customerId>
<institutionId>2181</institutionId>
<modificationDate>20140724</modificationDate>
<modifiedBy>Sandboxpbelanger</modifiedBy>
</owneredEntity>
</note>
</noteList>
<vat_info>
<expended_from_fund_ind>true</expended_from_fund_ind>
<inclusive_ind>false</inclusive_ind>
<vat_amount>0.0</vat_amount>
<vat_percentage>0.0</vat_percentage>
<vat_type>EXCLUSIVE</vat_type>
<vat_in_invoice_line_level>false</vat_in_invoice_line_level>
<vat_description xsi:nil="true"/>
<vat_code xsi:nil="true"/>
</vat_info>
<additional_charges>
<discount_amount>0.0</discount_amount>
<insurance_amount>0.0</insurance_amount>
<overhead_amount>0.0</overhead_amount>
<shipment_amount>0.0</shipment_amount>
<total_charges_amount>0.0</total_charges_amount>
</additional_charges>
<invoice_line_list>
<invoice_line>
<line_number>1</line_number>
<line_type>REGULAR</line_type>
<quantity>1</quantity>
<reporting_code>PRINTBOOK</reporting_code>
<total_price>20.0</total_price>
<price>20.0</price>
<po_line_info>
<fully_Invoiced_ind>true</fully_Invoiced_ind>
<po_line_owner>Leddy Library*</po_line_owner>
<mms_record_id>99178220802181</mms_record_id>
<meta_data_values>
<acqterms_identifier>0199669937</acqterms_identifier>
<acqterms_identifierType>ISBN</acqterms_identifierType>
<acqterms_place>Oxford :</acqterms_place>
<creator>Mayer, C. P. (Colin P.)</creator>
<date>2013.</date>
<publisher>Oxford University Press</publisher>
</meta_data_values>
<vendor_note xsi:nil="true"/>
<vendor_reference_number>order number 102</vendor_reference_number>
<additional_order_reference xsi:nil="true"/>
<po_line_number>POL-411</po_line_number>
<po_line_price>20.0</po_line_price>
<po_line_title>Firm commitment : why the corporation is failing us and how 
to restore trust in it / Colin Mayer.</po_line_title>
</po_line_info>
<fund_info_list>
<fund_info>
<amount>
<currency>USD</currency>
<sum>20</sum>
</amount>
<code>BIOL-MON-1</code>
<fiscal_period>2014-2015</fiscal_period>
<external_id>18105.8820</external_id>
<type>ALLOCATED</type>
</fund_info>
</fund_info_list>
</invoice_line>
<invoice_line>
<line_number>999991</line_number>
<line_type>SHIPMENT</line_type>
<quantity>1</quantity>
<total_price>2.0</total_price>
<price>2.0</price>
<fund_info_list>
<fund_info>
<amount>
<currency>USD</currency>
<sum>2</sum>
</amount>
<code>SHIP 8430</code>
<fiscal_period>2014-2015</fiscal_period>
<external_id>18105.8430</external_id>
<type>ALLOCATED</type>
</fund_info>
</fund_info_list>
</invoice_line>
<invoice_line>
<line_number>999992</line_number>
<line_type>DISCOUNT</line_type>
<quantity>0</quantity>
<total_price>0.0</total_price>
<price>0.0</price>
</invoice_line>
<invoice_line>
<line_number>999993</line_number>
<line_type>OVERHEAD</line_type>
<quantity>0</quantity>
<total_price>0.0</total_price>
<price>0.0</price>
</invoice_line>
<invoice_line>
<line_number>999994</line_number>
<line_type>INSURANCE</line_type>
<quantity>0</quantity>
<total_price>0.0</total_price>
<price>0.0</price>
</invoice_line>
</invoice_line_list>
<invoice_exchange_rate_list>
<exchange_rate>
<currency>CAD</currency>
<explicit_ind>false</explicit_ind>
<rate>1.0742</rate>
</exchange_rate>
</invoice_exchange_rate_list>
</invoice>
</invoice_list>
< /payment_data>

_____________________________________________________________________
Catherine Wilbur  |  Senior Application Programmer  |  IT Services
 (E) cwilbur@xxxxxxxxxxx


Current Thread
Keywords
xml