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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Fw: How do I properly ext, Wendell Piez wapiez@ | Thread | Re: [xsl] How do I properly extract, Hank Ratzesberger xm |
[xsl] Fw: How do I properly extract, Catherine Wilbur cwi | Date | Re: [xsl] Sarissa Cross browser Xml, Karl Stubsjoen kstub |
Month |