How add exception to xslt code?

Questions about XML that are not covered by the other forums should go here.
winkimjr2
Posts: 62
Joined: Thu Jun 26, 2014 9:00 pm

How add exception to xslt code?

Post by winkimjr2 »

I have 4 TransactionTypeText being handled by xslt code which include TransactionTypeText='Charge', TransactionTypeText='Payment', TransactionTypeText='Credit', TransactionTypeText='Disbursement'.
The problem is that, this code is not handling other types (TransactionTypeText) that are not one of the the 4 types.
When I try TransactionTypeText='Adjustment', I am getting an error Unknown transaction type Adjustment because I have an exception in my xslt code to handle TransactionTypeText when it is of type other than the 4.
So I would like to modify my code so that it can handle all types of TransactionTypeText.
The requirement is that, to handle (other) TransactionTypeText that are not of type Charge, Credit, Disbursement, Payment, use the following condition:
For TransactionTypeText that are not Charge; Payment; Credit, and Disbursement get amount that is not equal to zero from any of the amount elements. The reason is that amount for other types can be in any amount element.

Note: Unlike the 4 types, other types can have amount in any element. The amount for Charge is in ChargeAmount element, amount for Payment is in PaymentAmount element, amount for Disbursement is in DisbursementAmount element, amount for Credit is in CreditAmount. This is not the case for other types. So, for other types, I need to get amount from any element that has amount that is great than zero.

[b]Note:[/b] For each of the other types, only one of the amount elements can have amount greater than zero.
If there is more than one amount element with amount that is greater than zero, add exception with exception text "Transaction has more than one amount type.

Currently I have except to handle when type is not Charge, Payment, Credit or Disbursement.

[b]This is the xslt code that I need to modify.[/b]
[Codebox=xml file=Untitled.xml]<xsl:choose>
<xsl:when test="../TransactionTypeText='Charge'">
<xsl:value-of select="mscef:formatCurrency(string(ChargeAmount))"/>
</xsl:when>
<xsl:when test="../TransactionTypeText='Payment'">
<xsl:value-of select="mscef:formatCurrency(string(PaymentAmount))"/>
</xsl:when>
<xsl:when test="../TransactionTypeText='Credit'">
<xsl:value-of select="mscef:formatCurrency(string(CreditAmount))"/>
</xsl:when>
<xsl:when test="../TransactionTypeText='Disbursement'">
<xsl:value-of select="mscef:formatCurrency(string(DisbursementAmount))"/>
</xsl:when>
<xsl:otherwise>
<xsl:message terminate="yes">Unknown transaction type. <xsl:value-of select="../TransactionTypeText"/>
</xsl:message>
</xsl:otherwise>
</xsl:choose>[/Codebox]


[B]Expected output[/B]
[Codebox=xml file=Untitled.xml]<FinancialDetail>
<FinancialTransaction>
<TransactionID>1639560336</TransactionID>
<TransactionTypeText>Charge</TransactionTypeText>
<TransactionDate>2016-07-11</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1650110685</FeeDetailID>
<FeeDetailFeeCodeText code="REST">Restitution</FeeDetailFeeCodeText>
<FeeDetailFeeAmount>500</FeeDetailFeeAmount>
</TransactionFeeDetail>
<TransactionCommentText/>
<TransactionPaymentCreditTypeText/>
</FinancialTransaction>
<FinancialTransaction>
<TransactionID>1639560337</TransactionID>
<TransactionTypeText>Adjustment</TransactionTypeText>
<TransactionDate>2016-07-11</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1650110685</FeeDetailID>
<FeeDetailFeeCodeText code="REST">Restitution</FeeDetailFeeCodeText>
<FeeDetailFeeAmount>-500</FeeDetailFeeAmount>
</TransactionFeeDetail>
<TransactionCommentText>Testing</TransactionCommentText>
<TransactionPaymentCreditTypeText/>
</FinancialTransaction>
</FinancialDetail>[/Codebox]

[b]my xslt code[/b]
[Codebox=xml file=Untitled.xml]xslt stylesheet
<xsl:stylesheet version="1.0" xmlns="http://www.courts.state.mn.us/CourtXML/3" xmlns:msc="http://www.courts.state.mn.us/CourtXML/3" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:mscef="courts.state.mn.us/extfun" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="mscef msxsl msc">
<xsl:output method="xml" encoding="UTF-8"/>
<xsl:template name="FinancialDetailType">
<xsl:for-each select="ancestor::Integration/FinancialDetail/Transaction[count(TransactionFeeDetail[FeeDetailFeeCode='REST'])>0]">
<FinancialTransaction>
<TransactionID>
<xsl:value-of select="TransactionID"/>
</TransactionID>
<TransactionTypeText>
<xsl:value-of select="TransactionTypeText"/>
</TransactionTypeText>
<TransactionDate>
<xsl:value-of select="substring(TransactionDate,1,10)"/>
</TransactionDate>
<xsl:for-each select="TransactionFeeDetail[FeeDetailFeeCode='REST']">
<TransactionFeeDetail>
<FeeDetailID>
<xsl:value-of select="FeeDetailID"/>
</FeeDetailID>
<FeeDetailFeeCodeText>
<xsl:attribute name="code">
<xsl:value-of select="FeeDetailFeeCode"/>
</xsl:attribute>
<xsl:value-of select="FeeDetailFeeCodeText"/>
</FeeDetailFeeCodeText>
<FeeDetailFeeAmount>
<xsl:choose>
<xsl:when test="../TransactionTypeText='Charge'">
<xsl:value-of select="mscef:formatCurrency(string(ChargeAmount))"/>
</xsl:when>
<xsl:when test="../TransactionTypeText='Payment'">
<xsl:value-of select="mscef:formatCurrency(string(PaymentAmount))"/>
</xsl:when>
<xsl:when test="../TransactionTypeText='Credit'">
<xsl:value-of select="mscef:formatCurrency(string(CreditAmount))"/>
</xsl:when>
<xsl:when test="../TransactionTypeText='Disbursement'">
<xsl:value-of select="mscef:formatCurrency(string(DisbursementAmount))"/>
</xsl:when>
<xsl:otherwise>
<xsl:message terminate="yes">Unknown transaction type. <xsl:value-of select="../TransactionTypeText"/>
</xsl:message>
</xsl:otherwise>
</xsl:choose>
</FeeDetailFeeAmount>
</TransactionFeeDetail>
</xsl:for-each>
<TransactionCommentText>
<xsl:value-of select="TransactionCommentText"/>
</TransactionCommentText>
<TransactionPaymentCreditTypeText>
<xsl:value-of select="TransactionPaymentCreditTypeText"/>
</TransactionPaymentCreditTypeText>
</FinancialTransaction>
</xsl:for-each>
</xsl:template>
<msxsl:script language="JScript" implements-prefix="mscef">
<![CDATA[

function formatCurrency(asCurrency){
asCurrency = asCurrency.replace("\$","");
asCurrency = asCurrency.replace("\,","");
return parseFloat(asCurrency);
}
function formatTwoDecimalCurrency(asCurrency){
if(asCurrency.length==0){
return "";
}
asCurrency = asCurrency.replace("\$","");
asCurrency = asCurrency.replace("\,","");
return parseFloat(asCurrency).toFixed(2);
}
]]></msxsl:script>
</xsl:stylesheet>[/Codebox]

[b]my xml document[/b]
[Codebox=xml file=Untitled.xml]<Integration>
<Case InternalID="1612988653" ID="5226206" xmlns:user="http://tylertechnologies.com">
</Case>
<FinancialDetail>
<Transaction>
<TransactionID>1621246445</TransactionID>
<TransactionTypeText>Charge</TransactionTypeText>
<TransactionDate>2010-06-30T00:00:00</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1624242662</FeeDetailID>
<FeeDetailFeeCode>CRMTRAF5</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Crim/Traffic Surcharge 2005</FeeDetailFeeCodeText>
<ChargeAmount>72.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242663</FeeDetailID>
<FeeDetailFeeCode>LAWLIBCR</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Law Library Criminal</FeeDetailFeeCodeText>
<ChargeAmount>10.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242664</FeeDetailID>
<FeeDetailFeeCode>MUNICCTY</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Municipal Fines-County Share</FeeDetailFeeCodeText>
<ChargeAmount>233.3800</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242665</FeeDetailID>
<FeeDetailFeeCode>10CHAS23</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Chaska (0300) 2/3</FeeDetailFeeCodeText>
<ChargeAmount>466.6200</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242666</FeeDetailID>
<FeeDetailFeeCode>CRTCOSTS</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Court Costs</FeeDetailFeeCodeText>
<ChargeAmount>3.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242667</FeeDetailID>
<FeeDetailFeeCode>PROSCOSTS</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Prosecution Costs</FeeDetailFeeCodeText>
<ChargeAmount>700.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
</Transaction>
<Transaction>
<TransactionID>1621279946</TransactionID>
<TransactionTypeText>Charge</TransactionTypeText>
<TransactionDate>2010-07-06T00:00:00</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1624281693</FeeDetailID>
<FeeDetailFeeCode>CRTCOSTS</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Court Costs</FeeDetailFeeCodeText>
<ChargeAmount>20.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
</Transaction>
<Transaction>
<TransactionID>1621541452</TransactionID>
<TransactionTypeText>Payment</TransactionTypeText>
<TransactionDate>2010-08-06T00:00:00</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1624242664</FeeDetailID>
<FeeDetailFeeCode>MUNICCTY</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Municipal Fines-County Share</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>32.2800</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242665</FeeDetailID>
<FeeDetailFeeCode>10CHAS23</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Chaska (0300) 2/3</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>64.5400</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242666</FeeDetailID>
<FeeDetailFeeCode>CRTCOSTS</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Court Costs</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.4100</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624281693</FeeDetailID>
<FeeDetailFeeCode>CRTCOSTS</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Court Costs</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>2.7700</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
</Transaction>
<Transaction>
<TransactionID>1621746487</TransactionID>
<TransactionTypeText>Disbursement</TransactionTypeText>
<TransactionDate>2010-09-01T00:00:00</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1624242664</FeeDetailID>
<FeeDetailFeeCode>MUNICCTY</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Municipal Fines-County Share</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>32.2800</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242665</FeeDetailID>
<FeeDetailFeeCode>10CHAS23</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Chaska (0300) 2/3</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>64.5400</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624242666</FeeDetailID>
<FeeDetailFeeCode>CRTCOSTS</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Court Costs</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.4100</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
<TransactionFeeDetail>
<FeeDetailID>1624281693</FeeDetailID>
<FeeDetailFeeCode>CRTCOSTS</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Court Costs</FeeDetailFeeCodeText>
<ChargeAmount>0.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>2.7700</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
<RecipientAccountID>1610014856</RecipientAccountID>
<NameLast>MN Department of Finance</NameLast>
</TransactionFeeDetail>
</Transaction>
<Transaction>
<TransactionID>1639560336</TransactionID>
<TransactionTypeText>Charge</TransactionTypeText>
<TransactionDate>2016-07-11T00:00:00</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1650110685</FeeDetailID>
<FeeDetailFeeCode>REST</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Restitution</FeeDetailFeeCodeText>
<ChargeAmount>500.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
</TransactionFeeDetail>
</Transaction>
<Transaction>
<TransactionID>1639560337</TransactionID>
<TransactionCommentText>Testing</TransactionCommentText>
<TransactionTypeText>Adjustment</TransactionTypeText>
<TransactionDate>2016-07-11T00:00:00</TransactionDate>
<TransactionFeeDetail>
<FeeDetailID>1650110685</FeeDetailID>
<FeeDetailFeeCode>REST</FeeDetailFeeCode>
<FeeDetailFeeCodeText>Restitution</FeeDetailFeeCodeText>
<ChargeAmount>-500.0000</ChargeAmount>
<CreditAmount>0.0000</CreditAmount>
<DisbursementAmount>0.0000</DisbursementAmount>
<PaymentAmount>0.0000</PaymentAmount>
</TransactionFeeDetail>
</Transaction>
</FinancialDetail>
</Integration>[/Codebox]
Radu
Posts: 9018
Joined: Fri Jul 09, 2004 5:18 pm

Re: How add exception to xslt code?

Post by Radu »

Hi,

This XSLT question is not related to Oxygen's implicit functionality.
You can try to find an XSLT mailing list or ask the question on Stack Overflow.

Regards,
Radu
Radu Coravu
<oXygen/> XML Editor
http://www.oxygenxml.com
Post Reply