Solved

Need XSL to transform source XML to destination XML

Posted on 2004-09-08
6
297 Views
Last Modified: 2013-11-19
Need XSL to transform source XML to destination XML

Source XML

<q5:Object xmlns:q5='http://ecommerce.org/schema' Class='Payment'>
<q5:Property><q5:Name>Amount</q5:Name><q5:Value>12000</q5:Value></q5:Property>
<q5:Property><q5:Name>ApplRef</q5:Name><q5:Value>XX040302000001</q5:Value></q5:Property>
<q5:Property><q5:Name>Base_Amount</q5:Name><q5:Value>12000</q5:Value></q5:Property>
<q5:Property><q5:Name>Beneficiary_Account_Number</q5:Name><q5:Value Index='1'>873156571178</q5:Value
></q5:Property>
<q5:Property><q5:Name>Beneficiary_Address1</q5:Name><q5:Value Index='2'>MALAYSIA BERHAD</q5:Value></q5:Property>
<q5:Property><q5:Name>Beneficiary_Instructing_Info</q5:Name><q5:Value Index='1'></q5:Value></q5:Property>
<q5:Property><q5:Name>Beneficiary_Name</q5:Name><q5:Value Index='1'>GLENMARK PHARMACEUTICALS LTD.</q5:Value></q5:Property>
<q5:Property><q5:Name>Beneficiary_Name</q5:Name><q5:Value Index='2'>STANDARD CHARTERED BANK</q5:Value></q5:Property>
<q5:Property><q5:Name>Beneficiary_Party_Id</q5:Name><q5:Value Index='1'>873156571178</q5:Value></q5:Property>
<q5:Property><q5:Name>Beneficiary_Party_Id_Type</q5:Name><q5:Value Index='1'>AC</q5:Value></q5:Property>
<q5:Property><q5:Name>Beneficiary_Src_Msg_Fmt</q5:Name><q5:Value Index='2'>D</q5:Value></q5:Property>
<q5:Property><q5:Name>Business_Status</q5:Name><q5:Value>Processing</q5:Value></q5:Property>
<q5:Property><q5:Name>ClassName</q5:Name><q5:Value>Payment</q5:Value></q5:Property>
<q5:Property><q5:Name>CreatedBy</q5:Name><q5:Value>Dovetail.DBTCA.DBTCA_Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Account</q5:Name><q5:Value>04200595</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Amount</q5:Name><q5:Value>12000</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Currency</q5:Name><q5:Value>USD</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Address1</q5:Name><q5:Value>ATTN: PAUL GARTLAND</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Address2</q5:Name><q5:Value>ONE MADISON AVENUE</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Address3</q5:Name><q5:Value>NEW YORK NY 10010-3603</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_BIC</q5:Name><q5:Value>SCBLUS33XXX</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Class_Code</q5:Name><q5:Value>5411</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Contact</q5:Name><q5:Value>RICHARD J CONNORS</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Contact_Phone</q5:Name><q5:Value>602-1255</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Country_Code</q5:Name><q5:Value>US</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Country_Of_Risk</q5:Name><q5:Value>US</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_ID</q5:Name><q5:Value>04200595</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_ID_Type</q5:Name><q5:Value>AC</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Mail_Code</q5:Name><q5:Value>10010</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Name</q5:Name><q5:Value>STANDARD CHARTERED BANK LTD.</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_SPR_Code</q5:Name><q5:Value Index='1'>639</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_SPR_Code</q5:Name><q5:Value Index='2'>770</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_SPR_Code</q5:Name><q5:Value Index='3'>950</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_SPR_Value</q5:Name><q5:Value Index='1'>00000000000000000000</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_SPR_Value</q5:Name><q5:Value Index='2'>00000000000000000000</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_SPR_Value</q5:Name><q5:Value Index='3'>00000000000099000763</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Party_Segment</q5:Name><q5:Value>009</q5:Value></q5:Property>
<q5:Property><q5:Name>Credit_Value_Date</q5:Name><q5:Value>2004-01-23</q5:Value></q5:Property>
<q5:Property><q5:Name>Currency</q5:Name><q5:Value>USD</q5:Value></q5:Property>
<q5:Property><q5:Name>DTTM_Received</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>DTTM_Received_External</q5:Name><q5:Value>2004-01-23 13:27:00</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Account</q5:Name><q5:Value>04041037</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Amount</q5:Name><q5:Value>12000</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Currency</q5:Name><q5:Value>USD</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Address1</q5:Name><q5:Value>OVERSEAS BRANCH MITTAL TOWERS</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Address2</q5:Name><q5:Value>3RD FLOOR, NARIMAN POINT</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Address3</q5:Name><q5:Value>MUMBAI 400021, INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Class_Code</q5:Name><q5:Value></q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Contact</q5:Name><q5:Value>SYLVIA MARTIN</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Contact_Phone</q5:Name><q5:Value>250-9689</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_Country_Code</q5:Name><q5:Value>IND</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Country_Of_Risk</q5:Name><q5:Value>IND</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_ID</q5:Name><q5:Value>04041037</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_ID_Type</q5:Name><q5:Value>AC</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Mail_Code</q5:Name><q5:Value></q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Name</q5:Name><q5:Value>BANK OF INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_SPR_Code</q5:Name><q5:Value Index='1'>101</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_SPR_Code</q5:Name><q5:Value Index='2'>770</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_SPR_Code</q5:Name><q5:Value Index='3'>790</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_SPR_Code</q5:Name><q5:Value Index='4'>791</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_SPR_Code</q5:Name><q5:Value Index='5'>950</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_SPR_Code</q5:Name><q5:Value Index='6'>DVP</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_SPR_Code</q5:Name><q5:Value Index='7'>FDA</q5:Value></q5:Property>

<q5:Property><q5:Name>Debit_Party_SPR_Value</q5:Name><q5:Value Index='1'>                    </q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_SPR_Value</q5:Name><q5:Value Index='2'>00000000000000000000</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_SPR_Value</q5:Name><q5:Value Index='3'>00000000000001000100</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_SPR_Value</q5:Name><q5:Value Index='4'>00000000000001000100</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_SPR_Value</q5:Name><q5:Value Index='5'>00000000000099000763</q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_SPR_Value</q5:Name><q5:Value Index='6'>                    </q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_SPR_Value</q5:Name><q5:Value Index='7'>                    </q5:Value></q5:Property>
<q5:Property><q5:Name>Debit_Party_Segment</q5:Name><q5:Value>006</q5:Value></q5:Property><q5:Property><q5:Name>Debit_Value_Date</q5:Name><q5:Value>2004-01-23</q5:Value></q5:Property>
<q5:Property><q5:Name>Detail_Of_Charges_Instructed</q5:Name><q5:Value>SHA</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmCreated</q5:Name><q5:Value>2004-09-03 16:16:39</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmLastUpdated</q5:Name><q5:Value>2004-09-03 16:16:45</q5:Value></q5:Property>
<q5:Property><q5:Name>Entity</q5:Name><q5:Value>DBTCA</q5:Value></q5:Property>
<q5:Property><q5:Name>ID</q5:Name><q5:Value>355854739306446849</q5:Value></q5:Property>
<q5:Property><q5:Name>Instructed_Amount</q5:Name><q5:Value>12000</q5:Value></q5:Property>
<q5:Property><q5:Name>Instructed_Currency</q5:Name><q5:Value>USD</q5:Value></q5:Property>
<q5:Property><q5:Name>LastUpdatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Name</q5:Name><q5:Value>355854739306446849</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Address1</q5:Name><q5:Value Index='1'>301/305 MAHALAXMI CHAMBERS</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Address1</q5:Name><q5:Value Index='2'>MUMBAI</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Address1</q5:Name><q5:Value Index='3'>MUMBAI</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Address2</q5:Name><q5:Value Index='1'>22 BHULABHAI DESAI ROAD, MUMBAI</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Address2</q5:Name><q5:Value Index='2'>MUMBAI, INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Address2</q5:Name><q5:Value Index='3'>MUMBAI, INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Address3</q5:Name><q5:Value Index='2'></q5:Value></q5:Property><q5:Property><q5:Name>Originator_Address3</q5:Name><q5:Value Index='3'></q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_BIC</q5:Name><q5:Value Index='2'>BKIDINBBMHL</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_BIC</q5:Name><q5:Value Index='3'>BKIDINBBMHL</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Name</q5:Name><q5:Value Index='1'>GLENMARK PHARMACEUTICALS LTD.</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Name</q5:Name><q5:Value Index='2'>BANK OF INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Name</q5:Name><q5:Value Index='3'>BANK OF INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Party_Id</q5:Name><q5:Value Index='2'>BKIDINBBMHL</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Party_Id</q5:Name><q5:Value Index='3'>BKIDINBBMHL</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Party_Id_Type</q5:Name><q5:Value Index='2'>SW</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Party_Id_Type</q5:Name><q5:Value Index='3'>SW</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Src_Msg_Fmt</q5:Name><q5:Value Index='1'>K</q5:Value></q5:Property>
<q5:Property><q5:Name>Originator_Src_Msg_Fmt</q5:Name><q5:Value Index='2'>A</q5:Value></q5:Property>

<q5:Property><q5:Name>Originator_Src_Msg_Fmt</q5:Name><q5:Value Index='3'>A</q5:Value></q5:Property>

<q5:Property><q5:Name>Owner</q5:Name><q5:Value>1</q5:Value></q5:Property>
<q5:Property><q5:Name>Priority</q5:Name><q5:Value>500</q5:Value></q5:Property>
<q5:Property><q5:Name>PriorityGroup</q5:Name><q5:Value>UNDEFINED</q5:Value></q5:Property>
<q5:Property><q5:Name>Reimburse_Party_BIC</q5:Name><q5:Value Index='1'>BKIDINBBTRY</q5:Value></q5:Property>
<q5:Property><q5:Name>Reimburse_Party_Party_Id</q5:Name><q5:Value Index='1'>BKIDINBBTRY</q5:Value></q5:Property>
<q5:Property><q5:Name>Reimburse_Party_Party_Id_Type</q5:Name><q5:Value Index='1'>SW</q5:Value></q5:Property>
<q5:Property><q5:Name>Reimburse_Party_Src_Msg_Fmt</q5:Name><q5:Value Index='1'>A</q5:Value></q5:Property>
<q5:Property><q5:Name>Remittance_Info</q5:Name><q5:Value>REIMBURSMENT OF EXPENSES OF REPRESENTATIVEOFFICE.</q5:Value></q5:Property>
<q5:Property><q5:Name>Remitter_Address1</q5:Name><q5:Value>MUMBAI</q5:Value></q5:Property>
<q5:Property><q5:Name>Remitter_Address2</q5:Name><q5:Value>MUMBAI, INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Remitter_Address3</q5:Name><q5:Value></q5:Value></q5:Property>
<q5:Property><q5:Name>Remitter_ID</q5:Name><q5:Value>BKIDINBBMHL</q5:Value></q5:Property>
<q5:Property><q5:Name>Remitter_ID_Type</q5:Name><q5:Value>SW</q5:Value></q5:Property>
<q5:Property><q5:Name>Remitter_Name</q5:Name><q5:Value>BANK OF INDIA</q5:Value></q5:Property>
<q5:Property><q5:Name>Revision</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>STP</q5:Name><q5:Value>1</q5:Value></q5:Property>
<q5:Property><q5:Name>STP_Processed</q5:Name><q5:Value>15 - Debit authority check required on the payment</q5:Value></q5:Property>
<q5:Property><q5:Name>Senders_Reference</q5:Name><q5:Value>0028/ORTT/42/522</q5:Value></q5:Property>

<q5:Property><q5:Name>Source</q5:Name><q5:Value>SWF</q5:Value></q5:Property>
<q5:Property><q5:Name>Source_Message_Type</q5:Name><q5:Value>103</q5:Value></q5:Property>
<q5:Property><q5:Name>Stage</q5:Name><q5:Value>SwiftCreditProcess</q5:Value></q5:Property>
<q5:Property><q5:Name>StageIndex</q5:Name><q5:Value>5</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='1'>New</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='2'>Fatal</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='3'>Repair</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='4'>SwiftDebitProcess</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='5'>SwiftCreditProcess</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='23'>HotScanRequestStage</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='128'>Complete</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='1'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='4'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='5'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='23'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='128'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageReverse</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='4'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='5'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='23'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>State</q5:Name><q5:Value>RepairRequired</q5:Value></q5:Property>
<q5:Property><q5:Name>Status</q5:Name><q5:Value>Ready</q5:Value></q5:Property>
<q5:Property><q5:Name>Type</q5:Name><q5:Value>N</q5:Value></q5:Property>
<q5:Property><q5:Name>Value_Date</q5:Name><q5:Value>2004-01-23</q5:Value></q5:Property>
<q5:Property><q5:Name>Version</q5:Name><q5:Value>3</q5:Value></q5:Property>
<q5:Link><q5:Name>Form</q5:Name><q5:LinkName>Payment</q5:LinkName></q5:Link>
<q5:Link><q5:Name>Origination</q5:Name><q5:LinkObject Index='1'>
<q5:Object Class='InbSwiftPayment'>
<q5:Property><q5:Name>AcctWithInst_Format</q5:Name><q5:Value>D</q5:Value></q5:Property>
<q5:Property><q5:Name>AcctWithInst_Line1</q5:Name><q5:Value>STANDARD CHARTERED BANK</q5:Value></q5:Property>
<q5:Property><q5:Name>AcctWithInst_Line2</q5:Name><q5:Value>MALAYSIA BERHAD</q5:Value></q5:Property>

<q5:Property><q5:Name>AddressIndex</q5:Name><q5:Value>1</q5:Value></q5:Property>
<q5:Property><q5:Name>Amount</q5:Name><q5:Value>12000</q5:Value></q5:Property>
<q5:Property><q5:Name>ApplRef</q5:Name><q5:Value>XX040302000001</q5:Value></q5:Property>
<q5:Property><q5:Name>Appliation_Identifier</q5:Name><q5:Value>F</q5:Value></q5:Property>
<q5:Property><q5:Name>BankOperationsCode</q5:Name><q5:Value>CRED</q5:Value></q5:Property>
<q5:Property><q5:Name>Bene_AccountNumber</q5:Name><q5:Value>873156571178</q5:Value></q5:Property>
<q5:Property><q5:Name>Bene_Line1</q5:Name><q5:Value>GLENMARK PHARMACEUTICALS LTD.</q5:Value></q5:Property>
<q5:Property><q5:Name>CPAReferenceNumber</q5:Name><q5:Value>040123G300010316</q5:Value></q5:Property
>
<q5:Property><q5:Name>ClassName</q5:Name><q5:Value>InbSwiftPayment</q5:Value></q5:Property>
<q5:Property><q5:Name>CopyIndicator</q5:Name><q5:Value>N</q5:Value></q5:Property>
<q5:Property><q5:Name>CreatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Currency</q5:Name><q5:Value>USD</q5:Value></q5:Property>
<q5:Property><q5:Name>DetailsOfCharges</q5:Name><q5:Value>SHA</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmCreated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmLastUpdated</q5:Name><q5:Value>2004-09-03 16:16:39</q5:Value></q5:Property
>
<q5:Property><q5:Name>DttmReceived</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmRipe</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>ID</q5:Name><q5:Value>378372737443299329</q5:Value></q5:Property>
<q5:Property><q5:Name>Input_Date</q5:Name><q5:Value>040123</q5:Value></q5:Property>
<q5:Property><q5:Name>Input_Sequence_Number</q5:Name><q5:Value>087965</q5:Value></q5:Property>
<q5:Property><q5:Name>Input_Session_Number</q5:Name><q5:Value>5146</q5:Value></q5:Property>
<q5:Property><q5:Name>Input_Terminal</q5:Name><q5:Value>A</q5:Value></q5:Property>
<q5:Property><q5:Name>Input_Time</q5:Name><q5:Value>1857</q5:Value></q5:Property>
<q5:Property><q5:Name>InstructedAmount</q5:Name><q5:Value>12000,</q5:Value></q5:Property>
<q5:Property><q5:Name>InstructedCurrency</q5:Name><q5:Value>USD</q5:Value></q5:Property>
<q5:Property><q5:Name>Intermediary_Format</q5:Name><q5:Value>D</q5:Value></q5:Property>
<q5:Property><q5:Name>Intermediary_Line1</q5:Name><q5:Value>STANDARD CHARTERED BANK</q5:Value></q5:Property>
<q5:Property><q5:Name>Intermediary_Line2</q5:Name><q5:Value>NEW YORK</q5:Value></q5:Property>
<q5:Property><q5:Name>LastUpdatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Message_Priority</q5:Name><q5:Value>N</q5:Value></q5:Property>
<q5:Property><q5:Name>Message_Type</q5:Name><q5:Value>103</q5:Value></q5:Property>
<q5:Property><q5:Name>Name</q5:Name><q5:Value>378372737443299329</q5:Value></q5:Property>
<q5:Property><q5:Name>OrderingCust_Format</q5:Name><q5:Value>K</q5:Value></q5:Property>
<q5:Property><q5:Name>OrderingCust_Line1</q5:Name><q5:Value>GLENMARK PHARMACEUTICALS LTD.</q5:Value>
</q5:Property>
<q5:Property><q5:Name>OrderingCust_Line2</q5:Name><q5:Value>301/305 MAHALAXMI CHAMBERS</q5:Value></q5:Property>
<q5:Property><q5:Name>OrderingCust_Line3</q5:Name><q5:Value>22 BHULABHAI DESAI ROAD, MUMBAI</q5:Value></q5:Property>
<q5:Property><q5:Name>OrderingInst_BIC</q5:Name><q5:Value>BKIDINBBMHL</q5:Value></q5:Property>
<q5:Property><q5:Name>OrderingInst_Format</q5:Name><q5:Value>A</q5:Value></q5:Property>
<q5:Property><q5:Name>OriginatorApplication</q5:Name><q5:Value>MICECES0</q5:Value></q5:Property>
<q5:Property><q5:Name>Output_Date</q5:Name><q5:Value>040123</q5:Value></q5:Property>
<q5:Property><q5:Name>Output_Sequence_Number</q5:Name><q5:Value>318770</q5:Value></q5:Property>
<q5:Property><q5:Name>Output_Session_Number</q5:Name><q5:Value>4224</q5:Value></q5:Property>
<q5:Property><q5:Name>Output_Terminal</q5:Name><q5:Value>D</q5:Value></q5:Property>
<q5:Property><q5:Name>Output_Time</q5:Name><q5:Value>0827</q5:Value></q5:Property>
<q5:Property><q5:Name>Owner</q5:Name><q5:Value>1</q5:Value></q5:Property>
<q5:Property><q5:Name>Priority</q5:Name><q5:Value>500</q5:Value></q5:Property>
<q5:Property><q5:Name>PriorityGroup</q5:Name><q5:Value>UNDEFINED</q5:Value></q5:Property>
<q5:Property><q5:Name>ProtocolReference</q5:Name><q5:Value>53crdt56D.gma1094228197893</q5:Value></q5:Property>
<q5:Property><q5:Name>ReceiveDate</q5:Name><q5:Value>040123</q5:Value></q5:Property>
<q5:Property><q5:Name>ReceiveTime</q5:Name><q5:Value>1857</q5:Value></q5:Property>
<q5:Property><q5:Name>Receiver</q5:Name><q5:Value>BKTRUS33XXX</q5:Value></q5:Property>
<q5:Property><q5:Name>RemittanceInformation1</q5:Name><q5:Value>REIMBURSMENT OF EXPENSES OF</q5:Value></q5:Property>
<q5:Property><q5:Name>RemittanceInformation2</q5:Name><q5:Value>REPRESENTATIVE OFFICE.</q5:Value></q5:Property>
<q5:Property><q5:Name>Revision</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>STP</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>SegmentationNumber</q5:Name><q5:Value>00</q5:Value></q5:Property>
<q5:Property><q5:Name>Sender</q5:Name><q5:Value>BKIDINBBMHL</q5:Value></q5:Property>
<q5:Property><q5:Name>SenderToReceiverInformation1</q5:Name><q5:Value>/BNF/</q5:Value></q5:Property>

<q5:Property><q5:Name>SendersCorr_BIC</q5:Name><q5:Value>BKIDINBBTRY</q5:Value></q5:Property>
<q5:Property><q5:Name>SendersCorr_Format</q5:Name><q5:Value>A</q5:Value></q5:Property>
<q5:Property><q5:Name>SendersReference</q5:Name><q5:Value>0028/ORTT/42/522</q5:Value></q5:Property>
<q5:Property><q5:Name>Stage</q5:Name><q5:Value>Complete</q5:Value></q5:Property>
<q5:Property><q5:Name>StageFailureNames</q5:Name><q5:Value Index='4'>Repair</q5:Value></q5:Property>

<q5:Property><q5:Name>StageFailureNames</q5:Name><q5:Value Index='5'>Repair</q5:Value></q5:Property>

<q5:Property><q5:Name>StageFailureNames</q5:Name><q5:Value Index='6'>Invalid</q5:Value></q5:Property
>
<q5:Property><q5:Name>StageFailureNames</q5:Name><q5:Value Index='8'>Repair</q5:Value></q5:Property>

<q5:Property><q5:Name>StageFailureNames</q5:Name><q5:Value Index='10'>Invalid</q5:Value></q5:Property>
<q5:Property><q5:Name>StageFailureNames</q5:Name><q5:Value Index='12'>Duplicate</q5:Value></q5:Property>
<q5:Property><q5:Name>StageFailureNames</q5:Name><q5:Value Index='14'>Repair</q5:Value></q5:Property>
<q5:Property><q5:Name>StageIndex</q5:Name><q5:Value>128</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='1'>New</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='2'>Fatal</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='3'>Repair</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='4'>Invalid</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='5'>Duplicate</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='6'>ParseSwift</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='8'>EnhanceSwift</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='10'>AssignLegalEntity</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='12'>DuplicateRFKCheck</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='14'>SWIFTIncomingSetForm</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='20'>SWIFTCreatePayment</q5:Value></q5:Property>
<q5:Property><q5:Name>StageNames</q5:Name><q5:Value Index='128'>Complete</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='1'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='6'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='8'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='10'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='12'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='14'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='20'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageRequired</q5:Name><q5:Value Index='128'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageReverse</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='6'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='8'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='10'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='12'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='14'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>StageSTP</q5:Name><q5:Value Index='20'>1</q5:Value></q5:Property>
<q5:Property><q5:Name>State</q5:Name><q5:Value>Active</q5:Value></q5:Property>
<q5:Property><q5:Name>Status</q5:Name><q5:Value>Ready</q5:Value></q5:Property>
<q5:Property><q5:Name>SwiftAmount</q5:Name><q5:Value>12000,</q5:Value></q5:Property>
<q5:Property><q5:Name>ValueDate</q5:Name><q5:Value>040123</q5:Value></q5:Property>
<q5:Property><q5:Name>Version</q5:Name><q5:Value>8</q5:Value></q5:Property>
<q5:Link><q5:Name>Form</q5:Name><q5:LinkName>SwiftPayment</q5:LinkName></q5:Link>
<q5:Link><q5:Name>Service</q5:Name><q5:LinkName>GMASwift</q5:LinkName></q5:Link>
<q5:Link><q5:Name>Text</q5:Name><q5:LinkObject Index='1'>
<q5:Object Class='Text'>aaaaaa
<q5:Property><q5:Name>ClassName</q5:Name><q5:Value>Text</q5:Value></q5:Property>
<q5:Property><q5:Name>CreatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>DataValue</q5:Name><q5:Value>{1:F01BKTRUS33DXXX4224318770}{2:O1031857040123BKI
DINBBAMHL51460879650401230827N}{4:
:20:0028/ORTT/42/522
:23B:CRED
:32A:040123USD12000,
:33B:USD12000,
:50K:GLENMARK PHARMACEUTICALS LTD.
301/305 MAHALAXMI CHAMBERS
22 BHULABHAI DESAI ROAD, MUMBAI
:52A:BKIDINBBMHL
:53A:BKIDINBBTRY
:56D:STANDARD CHARTERED BANK
NEW YORK
:57D:STANDARD CHARTERED BANK
MALAYSIA BERHAD
:59:/873156571178
GLENMARK PHARMACEUTICALS LTD.
:70:REIMBURSMENT OF EXPENSES OF
REPRESENTATIVE OFFICE.
:71A:SHA
:72:/BNF/
-}{5:{MAC:63F1A9EA}{CHK:89812974E825}}</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmCreated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmLastUpdated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property
>
<q5:Property><q5:Name>ID</q5:Name><q5:Value>36099165763141633</q5:Value></q5:Property>
<q5:Property><q5:Name>LastUpdatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Name</q5:Name><q5:Value>rcvd_SWIFT</q5:Value></q5:Property>
<q5:Property><q5:Name>Owner</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>ParentClass</q5:Name><q5:Value>Origination</q5:Value></q5:Property>
<q5:Property><q5:Name>Revision</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>State</q5:Name><q5:Value>Active</q5:Value></q5:Property>
<q5:Property><q5:Name>Status</q5:Name><q5:Value>Ready</q5:Value></q5:Property>
<q5:Property><q5:Name>Version</q5:Name><q5:Value>1</q5:Value></q5:Property>
</q5:Object>
</q5:LinkObject></q5:Link>
<q5:Link><q5:Name>Text</q5:Name><q5:LinkObject Index='2'>
<q5:Object Class='Text'>
<q5:Property><q5:Name>ClassName</q5:Name><q5:Value>Text</q5:Value></q5:Property>
<q5:Property><q5:Name>CreatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>DataValue</q5:Name><q5:Value>&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;!
DOCTYPE GMAadapter SYSTEM "GMAadapter_1_3.dtd"&gt;&lt;GMAadapter&gt;&lt;GMAadapterHeader version="1.
3"&gt;&lt;GMAGlobal&gt;&lt;CPAReferenceNumber&gt;040123G300010316&lt;/CPAReferenceNumber&gt;&lt;Send
er&gt;BKIDINBBMHL&lt;/Sender&gt;&lt;SenderSynonymType&gt;SW&lt;/SenderSynonymType&gt;&lt;Receiver&gt;
BKTRUS33XXX&lt;/Receiver&gt;&lt;ReceiverSynonymType&gt;SW&lt;/ReceiverSynonymType&gt;&lt;Segmentati
onNumber&gt;00&lt;/SegmentationNumber&gt;&lt;MsgType&gt;103&lt;/MsgType&gt;&lt;MsgFormat&gt;SW&lt;/M
sgFormat&gt;&lt;/GMAGlobal&gt;&lt;MessageOwner&gt;&lt;DebitAccountNumber/&gt;&lt;OriginatorApplicati
on&gt;MICECES0&lt;/OriginatorApplication&gt;&lt;/MessageOwner&gt;&lt;Status&gt;&lt;CopyIndicator&gt;
N&lt;/CopyIndicator&gt;&lt;ReceiveDate&gt;040123&lt;/ReceiveDate&gt;&lt;ReceiveTime&gt;1857&lt;/Rece
iveTime&gt;&lt;/Status&gt;&lt;/GMAadapterHeader&gt;&lt;GMAadapterBody&gt;{1:F01BKTRUS33DXXX422431877
0}{2:O1031857040123BKIDINBBAMHL51460879650401230827N}{4:
:20:0028/ORTT/42/522
:23B:CRED
:32A:040123USD12000,
:33B:USD12000,
:50K:GLENMARK PHARMACEUTICALS LTD.
301/305 MAHALAXMI CHAMBERS
22 BHULABHAI DESAI ROAD, MUMBAI
:52A:BKIDINBBMHL
:53A:BKIDINBBTRY
:56D:STANDARD CHARTERED BANK
NEW YORK
:57D:STANDARD CHARTERED BANK
MALAYSIA BERHAD
:59:/873156571178
GLENMARK PHARMACEUTICALS LTD.
:70:REIMBURSMENT OF EXPENSES OF
REPRESENTATIVE OFFICE.
:71A:SHA
:72:/BNF/
-}{5:{MAC:63F1A9EA}{CHK:89812974E825}}&lt;/GMAadapterBody&gt;&lt;/GMAadapter&gt;</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmCreated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmLastUpdated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property
>
<q5:Property><q5:Name>ID</q5:Name><q5:Value>36099165763141634</q5:Value></q5:Property>
<q5:Property><q5:Name>LastUpdatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Name</q5:Name><q5:Value>rcvd_GMAXML</q5:Value></q5:Property>
<q5:Property><q5:Name>Owner</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>ParentClass</q5:Name><q5:Value>Origination</q5:Value></q5:Property>
<q5:Property><q5:Name>Revision</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>State</q5:Name><q5:Value>Active</q5:Value></q5:Property>
<q5:Property><q5:Name>Status</q5:Name><q5:Value>Ready</q5:Value></q5:Property>
<q5:Property><q5:Name>Version</q5:Name><q5:Value>1</q5:Value></q5:Property>
</q5:Object>
</q5:LinkObject></q5:Link>
</q5:Object>
</q5:LinkObject></q5:Link>
</q5:Object>

_________________________________________________________________

Destination XML

<?xml version="1.0" encoding="UTF-8" ?><MTMESSAGE><INCABLE><ENVELOPE><MessageDirection value="I"/><Id value="SOGEFRPPXXX"/><IdType value="SW"/><Test value="Y"/><Amount value="0000001828200"/><CPDate value="0806"/><Currency value="USD"/><CPMessageFormat value="SW"/><UltimateDest value="FM"/><PrintArea value="03"/><ValueDate value="081004"/><MessageType value="103"/><AuthTestResult value="G"/><RepairIndicator value="0"/><BtAccountNo value="04003815"/><CPIOTime value="0548"/><CPIODate value="080604"/><Cs11CtlNo value="24605"/><SendersResearchRef value="040806AM26082686"/><AccumulatedAmount value="36C2F71D"/><SWSender value="CP"/><SWSenDate value="0608"/><SWSeqType value="S"/><SWSeqNumber value="F24605"/><SWDestination value="AT"/><SWNull value="D"/></ENVELOPE><TEXT><![CDATA[{1:F01BKTRUS33DXXX4575524605}{2:O1031128040806SOGEFRPPCXXX26084175860408060528N}{3:{108:EEX21913258}{119:STP}}{4:
:20:0387521901190000
:23B:CRED
:32A:040810USD18282,
:33B:USD18282,
:50K:SA UNIKA COMPUTER
ZI PARIS EST
BOULEVARD DE BEAUBOURG
77183  CROISSY BEAUBOURG     515
:57A:BSABESBB
:59:/ES4100810460380070080320
COMPUCASE SPAIN HEC / IMPORT
MUELLETEDE BARCELONA
EDIDICI EST 2 PLANTA
BARCELONA 08039 ESPAGNE
:70:53
040713 01
:71A:SHA
-}{5:{MAC:36C2F71D}{CHK:1242E6D5CE57}}]]></TEXT></INCABLE><PAYMENT><Txn><ControlNumber value="188770"/><ControlType value="C"/><EntryDate value="20040806"/><InCableAphFileLiteralId value="02"/><InCableAphFileSeqNo value="009446"/><MTStatus value="15"/><BankTransferInd value="N"/><BatchNumber value="0000"/><CableSource value="SWF"/><CableFormat value="SWF"/><CableMsgType value="103"/><InputSource value="SWR"/><InputSeqNo value="099999"/><BeneRef value="0387521901190000"/><SendSystemRef value="0608SF24605D"/><SenderRef value="0387521901190000"/><ValueDate value="20040810"/><Amount value="000001828200"/><RctTxnInd value="N"/><TxnVersion value="00000001"/><EntryDateTime value="20040806171912"/><BusinessDate value="20040806"/><SourceCreditIdType value="SW"/><SourceCreditId value="BSABESBB"/></Txn><Credit><Id value="BSABESBB"/><IdType value="SW"/><Name value="BANCO SABADELL"/><Address1 value="INTERNATIONAL DIVISION"/><Address2 value="P.O. BOX 1, PLAZA CATALUNA 1"/><Address3 value="SABADELL, SPAIN"/><Amount value="000001826450"/><FundsType value="VT"/></Credit><Debit><Id value="SOGEFRPP"/><IdType value="SW"/><PaymentId value="04003815"/><Name value="SOCIETE GENERALE"/><Address1 value="SBAN/OPI/CLE/ACN"/><Address2 value="8 AVENUE DES OLYMPIADES"/><Address3 value="94727 FONTENAY SOUS BOIS CEDEX FRAN"/><Amount value="000001828200"/><ChargeCode value="DP"/></Debit><Remitter><Id value="SOGEFRPP"/><IdType value="SW"/><Name value="SOCIETE GENERALE"/><Address1 value="SBAN/OPI/CLE/ACN"/><Address2 value="8 AVENUE DES OLYMPIADES"/><Address3 value="94727 FONTENAY SOUS BOIS CEDEX FRAN"/><IndividualName value="Y"/></Remitter><Originators><Originator order="0"><Name value="SA UNIKA COMPUTER"/><Address1 value="ZI PARIS EST"/><Address2 value="BOULEVARD DE BEAUBOURG"/><Address3 value="77183 CROISSY BEAUBOURG 515"/></Originator></Originators><Beneficiaries><Beneficiary order="0"><Name value="/ES4100810460380070080320"/><Address1 value="COMPUCASE SPAIN HEC / IMPORT"/><Address2 value="MUELLETEDE BARCELONA"/><Address3 value="EDIDICI EST 2 PLANTA"/></Beneficiary></Beneficiaries><Histories><Hist code="SYS" value="IEPS   0806040548" order="0"/><Hist code="IFE" value="20 TRUNCATION    59:" order="1"/><Hist code="IFE" value="60 INV PAY TYPE" order="2"/><Hist code="DPC" value="   01750" order="3"/><Hist code="LOG" value="17191215E2011091WR" order="4"/></Histories><DebitSics><Sic code="770" value="00000000000000000000" order="0"/><Sic code="790" value="00000000000017501750" order="1"/><Sic code="791" value="00000000000017501750" order="2"/><Sic code="810" value="00000000000000000000" order="3"/><Sic code="830" value="00000000000000000000" order="4"/><Sic code="950" value="00000000000099000763" order="5"/><Sic code="BNR" value="SEL" order="6"/><Sic code="DAC" value="0200 0600" order="7"/><Sic code="DFC" value="000000 0000 0100" order="8"/><Sic code="DFH" value="BAD" order="9"/><Sic code="DFN" value="" order="10"/><Sic code="FFL" value="300000 300000 30000" order="11"/><Sic code="FUT" value="00000000000000015000" order="12"/><Sic code="OUR" value="SEL" order="13"/><Sic code="RCT" value="BA 00000000000015000" order="14"/><Sic code="RVR" value="" order="15"/><Sic code="TBD" value="A   00 15 20 25 30" order="16"/><Sic code="TP2" value="A   33 33 33 33 38" order="17"/><Sic code="TPD" value="A   10 19 21 23 29" order="18"/><Sic code="TR1" value="A   50 00 50 00 00" order="19"/><Sic code="TRD" value="A   02 05 08 10 10" order="20"/><Sic code="710" value="00000000000+00100000" order="21"/><Sic code="410" value="00000000000000002234" order="22"/></DebitSics><OrigDetails><![CDATA[OBI=FEES DEDUCTED $17.50 53 040713 01]]></OrigDetails><Details><![CDATA[OBI=FEES DEDUCTED $17.50 53 040713 01]]></Details><CreditInfoAdvices><AdviceType value="C"/><AdviceBlock value="01"/><Name value="BANCO SABADELL"/><Address1 value="INTERNATIONAL DIVISION"/><Address2 value="P.O. BOX 1, PLAZA CATALUNA 1"/><Address3 value="SABADELL, SPAIN"/><MailCode value="030615"/><CableSequence value="0538976288"/><NumberOfAdvices value="08224"/></CreditInfoAdvices><DebitInfoAdvices><AdviceType value="D"/><AdviceBlock value="01"/><Id value="SOGEFRPPXXX"/><Name value="SOCIETE GENERALE"/><Address1 value="SBAN/OPI/CLE/ACN"/><Address2 value="8 AVENUE DES OLYMPIADES"/><Address3 value="94727 FONTENAY SOUS BOIS CEDEX FRAN"/><ChargeAmt value="1750"/><MailCode value="PARIS,SOC"/><Contact value="SYLVIE AUSSET"/><ContactPhone value="33143596262"/><AdviceFormatType value="S"/><CableSequence value="0538976288"/><NumberOfAdvices value="08224"/></DebitInfoAdvices><Iblocks><Instructor order="0"><Type value="103"/><Text value="23B=CRED33B=USD18282,"/></Instructor></Iblocks><Mblocks><![CDATA[SWXEPS02009446]]></Mblocks><TxnLegacy><ENVDirection value="O"/><ENVSender value="CP"/><ENVSenDate value="0608"/><ENVSeqType value="C"/><ENVSeqNumber value="188770"/><ENVDestination value="AT"/><ENVNull value="   CP"/><ENVType value="1"/><ENVSubtype value="0"/><ENVDataType value="1"/><ENVMessageSeq value="09446"/><ENVMessageQueue value="00045"/><MsgDataType value="1"/><CableControlNumber value="024605"/><OurFlag value="0"/><InstructionDate value="080604"/><GroupNumber value="03"/><CurrentQueId value="0000000011"/><CurrentQueKey value="=6 99171912188770C"/><CreditMailcode value="030615"/><CreditSegment value="000"/><DebitMailcode value="PARIS,SOC"/><DebitClassCode value="0411"/><DebitContactName value="SYLVIE AUSSET"/><DebitSegment value="003"/><DebitCountry value="FR"/><DebitCountryRisk value="FR"/></TxnLegacy></PAYMENT></MTMESSAGE>
0
Comment
Question by:gak2000
  • 2
6 Comments
 
LVL 26

Expert Comment

by:rdcpro
ID: 12012297
I'm not sure if there will be a solution here, either...  ;^)

gak2000, Can you identify any single piece of date in the destination XML that's in the Source XML?  This looks like a *lot* of work, so I'll give you some advice on how to proceed, but I'm not going to write the transformation.  In fact, even if I was a paid consultant on a project like this, we'd need to first work out some sort of requirements document or functional specification that unequivocally identified which parts of the source mapped to which parts in the target. For example, Altova makes a product called MapForce that makes it easy to map EDIFACT messages to an arbitrary XML document (http://www.altova.com/features_edi_mapforce.html)  I can see a lot of discussions happening before some things were clear.  Take for example, Benficiaries.

This:

      <q5:Property>
            <q5:Name>Beneficiary_Account_Number</q5:Name>
            <q5:Value Index="1">873156571178</q5:Value>
      </q5:Property>
      <q5:Property>
            <q5:Name>Beneficiary_Address1</q5:Name>
            <q5:Value Index="2">MALAYSIA BERHAD</q5:Value>
      </q5:Property>
      <q5:Property>
            <q5:Name>Beneficiary_Instructing_Info</q5:Name>
            <q5:Value Index="1"/>
      </q5:Property>
      <q5:Property>
            <q5:Name>Beneficiary_Name</q5:Name>
            <q5:Value Index="1">GLENMARK PHARMACEUTICALS LTD.</q5:Value>
      </q5:Property>
      <q5:Property>
            <q5:Name>Beneficiary_Name</q5:Name>
            <q5:Value Index="2">STANDARD CHARTERED BANK</q5:Value>
      </q5:Property>
      <q5:Property>
            <q5:Name>Beneficiary_Party_Id</q5:Name>
            <q5:Value Index="1">873156571178</q5:Value>
      </q5:Property>
      <q5:Property>
            <q5:Name>Beneficiary_Party_Id_Type</q5:Name>
            <q5:Value Index="1">AC</q5:Value>
      </q5:Property>
      <q5:Property>
            <q5:Name>Beneficiary_Src_Msg_Fmt</q5:Name>
            <q5:Value Index="2">D</q5:Value>
      </q5:Property>

must somehow map to:

            <Beneficiaries>
                  <Beneficiary order="0">
                        <Name value="/ES4100810460380070080320"/>
                        <Address1 value="COMPUCASE SPAIN HEC / IMPORT"/>
                        <Address2 value="MUELLETEDE BARCELONA"/>
                        <Address3 value="EDIDICI EST 2 PLANTA"/>
                  </Beneficiary>
            </Beneficiaries>

But it's not at all clear that this is possible, given that the second one implies multiple beneficiaries, while the first one doesn't seem to support that concept, not to mention what happens with the data that's in one but not the other.

You've got your work cut out for you, but in *general* you perform XML transformations by starting with an identity transformation, then adding templates that define rules governing each change in the source document.  An identity transform is:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >
<xsl:output method="xml" encoding="UTF-8" indent="yes"/>

<xsl:template match="/ | node()">
      <xsl:copy>
            <xsl:apply-templates select="@*"/>
            <xsl:apply-templates select="node()"/>
      </xsl:copy>
</xsl:template>

<xsl:template match="@*">
      <xsl:copy>
      </xsl:copy>
</xsl:template>

<!-- Templates to handle changes go here -->

</xsl:stylesheet>

Then a template that would change <foo>tarfu</foo> into <bar situation="tarfu"/> would look like:

<xsl:template match="foo">
      <bar>
            <xsl:attribute name="situation">
                  <xsl:value-of select="."/>
            </xsl:attribute>
      </bar>
</xsl:template>

This appears to me to be a very involved project.  If you need a recommendation on some consulting companies that could handle a project like this, send me an email (you can find it in my profile).  

Good luck!

Regards,
Mike Sharp
0
 

Author Comment

by:gak2000
ID: 12016088
I want to transform


<q5:Link><q5:Name>Text</q5:Name><q5:LinkObject Index='1'>
<q5:Object Class='Text'>aaaaaa
<q5:Property><q5:Name>ClassName</q5:Name><q5:Value>Text</q5:Value></q5:Property>
<q5:Property><q5:Name>CreatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>DataValue</q5:Name><q5:Value>{1:F01BKTRUS33DXXX4224318770}{2:O1031857040123BKI
DINBBAMHL51460879650401230827N}{4:
:20:0028/ORTT/42/522
:23B:CRED
:32A:040123USD12000,
:33B:USD12000,
:50K:GLENMARK PHARMACEUTICALS LTD.
301/305 MAHALAXMI CHAMBERS
22 BHULABHAI DESAI ROAD, MUMBAI
:52A:BKIDINBBMHL
:53A:BKIDINBBTRY
:56D:STANDARD CHARTERED BANK
NEW YORK
:57D:STANDARD CHARTERED BANK
MALAYSIA BERHAD
:59:/873156571178
GLENMARK PHARMACEUTICALS LTD.
:70:REIMBURSMENT OF EXPENSES OF
REPRESENTATIVE OFFICE.
:71A:SHA
:72:/BNF/
-}{5:{MAC:63F1A9EA}{CHK:89812974E825}}</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmCreated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmLastUpdated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property
>
<q5:Property><q5:Name>ID</q5:Name><q5:Value>36099165763141633</q5:Value></q5:Property>
<q5:Property><q5:Name>LastUpdatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Name</q5:Name><q5:Value>rcvd_SWIFT</q5:Value></q5:Property>
<q5:Property><q5:Name>Owner</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>ParentClass</q5:Name><q5:Value>Origination</q5:Value></q5:Property>
<q5:Property><q5:Name>Revision</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>State</q5:Name><q5:Value>Active</q5:Value></q5:Property>
<q5:Property><q5:Name>Status</q5:Name><q5:Value>Ready</q5:Value></q5:Property>
<q5:Property><q5:Name>Version</q5:Name><q5:Value>1</q5:Value></q5:Property>
</q5:Object>
</q5:LinkObject></q5:Link>
<q5:Link><q5:Name>Text</q5:Name><q5:LinkObject Index='2'>
<q5:Object Class='Text'>
<q5:Property><q5:Name>ClassName</q5:Name><q5:Value>Text</q5:Value></q5:Property>
<q5:Property><q5:Name>CreatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>DataValue</q5:Name><q5:Value>&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;!
DOCTYPE GMAadapter SYSTEM "GMAadapter_1_3.dtd"&gt;&lt;GMAadapter&gt;&lt;GMAadapterHeader version="1.
3"&gt;&lt;GMAGlobal&gt;&lt;CPAReferenceNumber&gt;040123G300010316&lt;/CPAReferenceNumber&gt;&lt;Send
er&gt;BKIDINBBMHL&lt;/Sender&gt;&lt;SenderSynonymType&gt;SW&lt;/SenderSynonymType&gt;&lt;Receiver&gt;
BKTRUS33XXX&lt;/Receiver&gt;&lt;ReceiverSynonymType&gt;SW&lt;/ReceiverSynonymType&gt;&lt;Segmentati
onNumber&gt;00&lt;/SegmentationNumber&gt;&lt;MsgType&gt;103&lt;/MsgType&gt;&lt;MsgFormat&gt;SW&lt;/M
sgFormat&gt;&lt;/GMAGlobal&gt;&lt;MessageOwner&gt;&lt;DebitAccountNumber/&gt;&lt;OriginatorApplicati
on&gt;MICECES0&lt;/OriginatorApplication&gt;&lt;/MessageOwner&gt;&lt;Status&gt;&lt;CopyIndicator&gt;
N&lt;/CopyIndicator&gt;&lt;ReceiveDate&gt;040123&lt;/ReceiveDate&gt;&lt;ReceiveTime&gt;1857&lt;/Rece
iveTime&gt;&lt;/Status&gt;&lt;/GMAadapterHeader&gt;&lt;GMAadapterBody&gt;{1:F01BKTRUS33DXXX422431877
0}{2:O1031857040123BKIDINBBAMHL51460879650401230827N}{4:
:20:0028/ORTT/42/522
:23B:CRED
:32A:040123USD12000,
:33B:USD12000,
:50K:GLENMARK PHARMACEUTICALS LTD.
301/305 MAHALAXMI CHAMBERS
22 BHULABHAI DESAI ROAD, MUMBAI
:52A:BKIDINBBMHL
:53A:BKIDINBBTRY
:56D:STANDARD CHARTERED BANK
NEW YORK
:57D:STANDARD CHARTERED BANK
MALAYSIA BERHAD
:59:/873156571178
GLENMARK PHARMACEUTICALS LTD.
:70:REIMBURSMENT OF EXPENSES OF
REPRESENTATIVE OFFICE.
:71A:SHA
:72:/BNF/
-}{5:{MAC:63F1A9EA}{CHK:89812974E825}}&lt;/GMAadapterBody&gt;&lt;/GMAadapter&gt;</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmCreated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property>
<q5:Property><q5:Name>DttmLastUpdated</q5:Name><q5:Value>2004-09-03 16:16:37</q5:Value></q5:Property
>
<q5:Property><q5:Name>ID</q5:Name><q5:Value>36099165763141634</q5:Value></q5:Property>
<q5:Property><q5:Name>LastUpdatedBy</q5:Name><q5:Value>Dovetail.Utility</q5:Value></q5:Property>
<q5:Property><q5:Name>Name</q5:Name><q5:Value>rcvd_GMAXML</q5:Value></q5:Property>
<q5:Property><q5:Name>Owner</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>ParentClass</q5:Name><q5:Value>Origination</q5:Value></q5:Property>
<q5:Property><q5:Name>Revision</q5:Name><q5:Value>0</q5:Value></q5:Property>
<q5:Property><q5:Name>State</q5:Name><q5:Value>Active</q5:Value></q5:Property>
<q5:Property><q5:Name>Status</q5:Name><q5:Value>Ready</q5:Value></q5:Property>
<q5:Property><q5:Name>Version</q5:Name><q5:Value>1</q5:Value></q5:Property>
</q5:Object>
</q5:LinkObject></q5:Link>


to

<TEXT><![CDATA[{1:F01BKTRUS33DXXX4575524605}{2:O1031128040806SOGEFRPPCXXX26084175860408060528N}{3:{108:EEX21913258}{119:STP}}{4:
:20:0387521901190000
:23B:CRED
:32A:040810USD18282,
:33B:USD18282,
:50K:SA UNIKA COMPUTER
ZI PARIS EST
BOULEVARD DE BEAUBOURG
77183  CROISSY BEAUBOURG     515
:57A:BSABESBB
:59:/ES4100810460380070080320
COMPUCASE SPAIN HEC / IMPORT
MUELLETEDE BARCELONA
EDIDICI EST 2 PLANTA
BARCELONA 08039 ESPAGNE
:70:53
040713 01
:71A:SHA
-}{5:{MAC:36C2F71D}{CHK:1242E6D5CE57}}]]></TEXT>


where I need only the first datavalue where q5:LinkObject Index='1'
0
 
LVL 26

Accepted Solution

by:
rdcpro earned 500 total points
ID: 12019298
Now that's a little more specific:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet
      version="1.0"
      xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
      xmlns:q5='http://ecommerce.org/schema'
      exclude-result-prefixes="q5" >
<xsl:output method="xml" encoding="UTF-8" indent="yes" cdata-section-elements="TEXT"/>

<xsl:template match="q5:LinkObject[@Index='1']/q5:Object[@Class ='Text']/q5:Property[q5:Name = 'DataValue']">
      <TEXT><xsl:value-of select="q5:Value"/></TEXT>
</xsl:template>

<!-- suppresses text output -->
<xsl:template match="text()"/>
      
</xsl:stylesheet>



which produces:

<?xml version="1.0" encoding="UTF-8"?>
<TEXT><![CDATA[{1:F01BKTRUS33DXXX4224318770}{2:O1031857040123BKI
DINBBAMHL51460879650401230827N}{4:
:20:0028/ORTT/42/522
:23B:CRED
:32A:040123USD12000,
:33B:USD12000,
:50K:GLENMARK PHARMACEUTICALS LTD.
301/305 MAHALAXMI CHAMBERS
22 BHULABHAI DESAI ROAD, MUMBAI
:52A:BKIDINBBMHL
:53A:BKIDINBBTRY
:56D:STANDARD CHARTERED BANK
NEW YORK
:57D:STANDARD CHARTERED BANK
MALAYSIA BERHAD
:59:/873156571178
GLENMARK PHARMACEUTICALS LTD.
:70:REIMBURSMENT OF EXPENSES OF
REPRESENTATIVE OFFICE.
:71A:SHA
:72:/BNF/
-}{5:{MAC:63F1A9EA}{CHK:89812974E825}}]]></TEXT>

0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now