Sorry to bother you but I'm feeling pretty dense about extracting the Attributes from my XML string. I've tried several different things but nothing I try yields anything but empty values in my data string. (I am able to capture data from everything in the XML file except the attributes.)
Here is my latest attempt: 1. The .ext file. <U2XML_extraction> <file_extraction start = "/BDT_TRANSACTIONS/Transaction"/> <field_extraction field = "1" path = "@Lease/text()" /> <field_extraction field = "2" path = "@Type=/text()" /> <field_extraction field = "3" path = "TRANSACTION_CODE/text()"/> <field_extraction field = "4" path = "CLIENT_NUMBER/text()"/> <field_extraction field = "5" path = "COMPANY_NUMBER/text()"/> <field_extraction field = "6" path = "CUSTOMER_ID/text()"/> <field_extraction field = "7" path = "LEASE_NUMBER/text()"/> <field_extraction field = "8" path = "REASON_CODE/text()"/> </U2XML_extraction> 2. A part of the XML string: <?xml version="1.0" encoding="UTF-8" ?> <BDT_TRANSACTIONS> <Transaction Lease="040815.01" Type="C"> <TRANSACTION_CODE>C</TRANSACTION_CODE> <CLIENT_NUMBER>2505</CLIENT_NUMBER> <COMPANY_NUMBER>01</COMPANY_NUMBER> <CUSTOMER_ID>040815</CUSTOMER_ID> <LEASE_NUMBER>040815.01</LEASE_NUMBER> <REASON_CODE>LC</REASON_CODE> <CLIENT_COVERAGE_EFFECTIVE_DATE>20080201</CLIENT_COVERAGE_EFFECTIVE_DATE> <CLIENT_COVERAGE_EXPIRATION_DATE>20090110</CLIENT_COVERAGE_EXPIRATION_DATE> <CLIENT_COVERAGE_CANCEL_DATE>20080805</CLIENT_COVERAGE_CANCEL_DATE> <INSURANCE_TERM>0</INSURANCE_TERM> <EQUIPMENT_VALUE>20818</EQUIPMENT_VALUE> <CHANGE_IN_EQUIP_VALUE>0</CHANGE_IN_EQUIP_VALUE> <LI_CLASS_CODE /> <INVOICE_METHOD /> <PROGRAM_CODE>PLLSL</PROGRAM_CODE> <REMAINING_INVOICES>10</REMAINING_INVOICES> <INVOICE_CREATE_DUE_DATE>20080310</INVOICE_CREATE_DUE_DATE> <FULL_TERM_CLIENT_INSURANCE_COST>-49.16</FULL_TERM_CLIENT_INSURANCE_COST> <FULL_TERM_FINANCE_CHARGE>-17.26</FULL_TERM_FINANCE_CHARGE> <FULL_TERM_LI_SERVICE_FEE>0.00</FULL_TERM_LI_SERVICE_FEE> <FULL_TERM_SUBCONTRACTOR_FEE>-33.28</FULL_TERM_SUBCONTRACTOR_FEE> <FULL_TERM_CUSTOMER_INSURANCE_CHARGE>-99.70</FULL_TERM_CUSTOMER_INSURANCE_CH ARGE> <CUSTOMER_INVOICE_FREQUENCY>M</CUSTOMER_INVOICE_FREQUENCY> <CUSTOMER_INSURANCE_CHARGE_PER_INVOICE>21.72</CUSTOMER_INSURANCE_CHARGE_PER_ INVOICE> <CHANGE_IN_CUSTOMER_INSURANCE_CHARGE_PER_INVOICE>-21.72</CHANGE_IN_CUSTOMER_ INSURANCE_CHARGE_PER_INVOICE> <PRIOR_AMOUNT>0.00</PRIOR_AMOUNT> <INSURANCE_COMPONENT>0.00</INSURANCE_COMPONENT> <FINANCE_COMPONENT>0.00</FINANCE_COMPONENT> <LI_SERVICE_FEE_COMPONENT>0.00</LI_SERVICE_FEE_COMPONENT> <SUBCONTRACTOR_FEE_COMPONENT>0.00</SUBCONTRACTOR_FEE_COMPONENT> <LI_CERTIFICATE_NUMBER>0029990118</LI_CERTIFICATE_NUMBER> </Transaction> <Transaction Batch="090208" Type="Z"> <TRANSACTION_CODE>Z</TRANSACTION_CODE> <FILE_NAME>POPBDT01LC20090207</FILE_NAME> <CLIENT_NUMBER>2505</CLIENT_NUMBER> <FILE_CREATION_DATE>20090207</FILE_CREATION_DATE> <COMPANY_NUMBER>01</COMPANY_NUMBER> <BATCH_NUMBER>090208</BATCH_NUMBER> <CANCEL_COUNT>52</CANCEL_COUNT> <NEW_COUNT>0</NEW_COUNT> <TOTAL_FULL_TERM_CLIENT_INSURANCE_COST>-73996.12</TOTAL_FULL_TERM_CLIENT_INS URANCE_COST> <TOTAL_FULL_TERM_FINANCE_CHARGE>-35466.50</TOTAL_FULL_TERM_FINANCE_CHARGE> <TOTAL_FULL_TERM_LI_SERVICE_FEE>0.00</TOTAL_FULL_TERM_LI_SERVICE_FEE> <TOTAL_FULL_TERM_SUBCONTRACTOR_FEE>-9412.17</TOTAL_FULL_TERM_SUBCONTRACTOR_F EE> <TOTAL_FULL_TERM_CUSTOMER_INSURANCE_CHARGE>-118874.79</TOTAL_FULL_TERM_CUSTO MER_INSURANCE_CHARGE> <TOTAL_CUSTOMER_INSURANCE_CHARGE_PER_INVOICE>3074.35</TOTAL_CUSTOMER_INSURAN CE_CHARGE_PER_INVOICE> <TOTAL_CHANGE_IN_CUSTOMER_INSURANCE_CHARGE_PER_INVOICE>-3074.35</TOTAL_CHANG E_IN_CUSTOMER_INSURANCE_CHARGE_PER_INVOICE> <TOTAL_INSURANCE_COMPONENT>0.00</TOTAL_INSURANCE_COMPONENT> <TOTAL_FINANCE_COMPONENT>0.00</TOTAL_FINANCE_COMPONENT> <TOTAL_LI_SERVICE_FEE_COMPONENT>0.00</TOTAL_LI_SERVICE_FEE_COMPONENT> <TOTAL_SUBCONTRACTOR_FEE_COMPONENT>0.00</TOTAL_SUBCONTRACTOR_FEE_COMPONENT> </Transaction> </BDT_TRANSACTIONS> 3. I'm trying to capture the attributes of each Transaction -- Lease and Type. I've tried looking at the XPATH spec and I'm still not certain as to the proper placement of the field extraction statements when I'm attempting to find the values of @Lease and @Type. Thanks for the help. Steve ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
