how to ignore namespace in xsl file while reading data from xml file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shah184
    New Member
    • May 2016
    • 1

    how to ignore namespace in xsl file while reading data from xml file

    Code:
    <?xml version="1.0"?>
    <biller-enrollment-notification xmlns="http://www.piit.com/cpbatch/billerenrollmentnotificaion1" "> 
    	<business-id>504477</business-id>
    	<file-create-date>05/14/2016</file-create-date>
    	<enrollment-notification> 
    		 <notification-type>ENROLLMENT ADDED</notification-type>
    		 <consumer-name>Customer Name1</consumer-name>
    		 <consumer-profile-id>675</consumer-profile-id>
    		 <last-update-date>2016-01-10T11:32:59</last-update-date>
    		 <notification-user-profile> 
    			 <primary-email-address>customer@email.com</primary-email-address>
    			 <contact-phone-number >7777777777</contact-phone-number>
    			 <profile-address-1>Customer Address 1</profile-address-1>
    			 <profile-address-2>Customer Address 2</profile-address-2>
    			 <profile-city>City</profile-city>
    			 <profile-state>NJ</profile-state>
    			 <profile-postal-code>08540</profile-postal-code>
    			 <profile-country-code>US</profile-country-code>
    		 </notification-user-profile> 
     	</enrollment-notification>
       	<totals>1</totals>
      </biller-enrollment-notification>
    my xsl file is like this
    Code:
    <?xml version="1.0" encoding="iso-8859-1" ?>
    <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >
      <xsl:output method="text" omit-xml-declaration="yes" />
      <xsl:template match="/">
      <xsl:strip-space elements="*" />
    
    	<!-- Header Line -->
        <xsl:text>BusinessId~FileCreateDate~NotificationType~ConsumerName~ProfileId~LastUpdateDate~PrimaryEmailAddress~ContactNumber~BillingAccountNumber~AccountNickName</xsl:text>
    	<xsl:text>~FundingAccountId~AccountAddress1~AccountAddress2~AccountCity~AccountState~AccountZip~AccountCountryCode~RoutingNumber~BankAccountNumber~FundingAccountHolderName~CardNumber~CardExpirationMonth~CardExpirationYear</xsl:text>
    	<xsl:text>~FundingAccountAdress1~FundingAccountAdress2~FundingAccountCity~FundingAccountState~FundingAccountZip~FundingAccountCountryCode~FundingAccountType~FundingAccountSubType</xsl:text>
    	<xsl:text>~AmountType~Amount~ScheduleDate~DayNumber~DurationType~SuspendDate~FrequencyType~TransactionDate~ConfirmationCode~Status~RejectReason~Totals</xsl:text>
    	<xsl:text>
    </xsl:text>
    	
    	<!-- Detail Lines -->
        <xsl:for-each select="/biller-enrollment-notification  /enrollment-notification">
    		<xsl:value-of select="../business-id"/>
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="../file-create-date" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-type"/>
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="consumer-name" />
    		<xsl:text>~</xsl:text>  
    		<xsl:value-of select="consumer-profile-id" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="last-update-date" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/primary-email-address" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/contact-phone-number" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/billing-account-number" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/notification-funding-account-nickname" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/funding-account-id" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/profile-address-1" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/profile-address-2" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/profile-city" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/profile-state" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/profile-postal-code" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-user-profile/profile-country-code" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/routing-number" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/bank-account-number" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/funding-account-holder-name" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/notification-credit-card-account/credit-card-number" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/notification-credit-card-account/expiration-month" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/notification-credit-card-account/expiration-year" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/account-address-1" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/account-address-2" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/account-city" />   <!--enrollment-notification/notification-funding-account/notification-credit-card-account/-->
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/account-state" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/account-postal-code" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/account-country-code" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/notification-funding-account-type" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-funding-account/notification-funding-account-subtype" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/payment-amount-type" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/payment-amount" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/payment-date-type" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/day-number" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/payment-duration-type" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/payment-schedule-suspend-date" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/payment-frequency" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/transaction-date" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="notification-billing-account/notification-payment-schedule/confirmation-code" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="../status" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="../reject-reason" />
    		<xsl:text>~</xsl:text>
    		<xsl:value-of select="../totals" />
    		<xsl:text>
    </xsl:text>
        </xsl:for-each>
      </xsl:template>
    </xsl:stylesheet>
    i want output to be like this
    504477~05/14/2016~ENROLLMENT ADDED
    Last edited by Dormilich; May 18 '16, 02:57 PM. Reason: please use code tags
Working...