Confirmation E-mail

Hi Sabina,

Thanks for the reply. Do you mind sending me your .xsl code if are using this option. Help is greatly appreciated.

Thanks

Harpreet

If you are using email templates that became available in Tessitura there is a special code to handle Gift Certificate purchases  - based on transaction details.

Sabina  Spilkin

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Harpreet Gangyan
Sent: Sunday, November 08, 2009 3:12 PM
To: Sabina Spilkin
Subject: [Tessitura Technical Forum] Confirmation E-mail

HI,

We have recently added Gift Voucher purchase on our Website and wants to add this information on the confirmation E-mail so that customer will receive the information of their gift certificate purchase through E-mail. Currently we have GetOrderDetails method to extract all the information needed on confirmation E-mail but Gift certificate voucher puchase is not on the order tab in Tessitura because it is not configured as performance. It is recorded as CSI under customer record and details resided in CSI and transaction history.

We will really appreciate if someone who have already this functionality set up and running can help us here to add the code in xsl file as we have deadline to have it running in next 3 days.

Thanks

Harpreet

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Sabina,

Thanks for the reply. Do you mind sending me your .xsl code if are using this option. Help is greatly appreciated.

Thanks

Harpreet

If you are using email templates that became available in Tessitura there is a special code to handle Gift Certificate purchases  - based on transaction details.

Sabina  Spilkin

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Harpreet Gangyan
Sent: Sunday, November 08, 2009 3:12 PM
To: Sabina Spilkin
Subject: [Tessitura Technical Forum] Confirmation E-mail

HI,

We have recently added Gift Voucher purchase on our Website and wants to add this information on the confirmation E-mail so that customer will receive the information of their gift certificate purchase through E-mail. Currently we have GetOrderDetails method to extract all the information needed on confirmation E-mail but Gift certificate voucher puchase is not on the order tab in Tessitura because it is not configured as performance. It is recorded as CSI under customer record and details resided in CSI and transaction history.

We will really appreciate if someone who have already this functionality set up and running can help us here to add the code in xsl file as we have deadline to have it running in next 3 days.

Thanks

Harpreet

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Sabina,

Thanks for the reply. Do you mind sending me your .xsl code if are using this option. Help is greatly appreciated.

Thanks

Harpreet

If you are using email templates that became available in Tessitura there is a special code to handle Gift Certificate purchases  - based on transaction details.

Sabina  Spilkin

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Harpreet Gangyan
Sent: Sunday, November 08, 2009 3:12 PM
To: Sabina Spilkin
Subject: [Tessitura Technical Forum] Confirmation E-mail

HI,

We have recently added Gift Voucher purchase on our Website and wants to add this information on the confirmation E-mail so that customer will receive the information of their gift certificate purchase through E-mail. Currently we have GetOrderDetails method to extract all the information needed on confirmation E-mail but Gift certificate voucher puchase is not on the order tab in Tessitura because it is not configured as performance. It is recorded as CSI under customer record and details resided in CSI and transaction history.

We will really appreciate if someone who have already this functionality set up and running can help us here to add the code in xsl file as we have deadline to have it running in next 3 days.

Thanks

Harpreet

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Many thanks to all folks Jon, Sabina, Chris replied to my mail because finally we did it with the information provided in your mails. Once again thanks a lot.

Harpreet

Harpreet, here is the code we use that includes the Gift Cert ID on our Order Confirmations.

<!-- GIFT CERT HANDLING -->
<xsl:if test="count(//GetOrderDetailsInfoResults/Payment[gc_no != '']) &gt; 0">
    <xsl:variable name="thisTotal" select="number(sum(//GetOrderDetailsInfoResults/Payment[gc_no != '']/payment_amt)*-1)"/>
    <tr>
        <td align="left" valign="top" colspan="2" style="background-color: #666666; color: #FFFFFF;">
            <b>Gift Certificates(s):</b>
        </td>
    </tr>
    <tr>
        <td align="left" valign="top" colspan="2">
            <table align="left" valign="top" cellpadding="2" cellspacing="0" width="100%">
                <tr>
                    <th align="left" valign="top" style="font-size: 11px; font-weight: bold; text-decoration: underline;">Description</th>
                    <th width="50" align="right" valign="top" style="font-size: 11px; font-weight: bold; text-decoration: underline;">Total</th>
                </tr>
                <xsl:for-each select="//GetOrderDetailsInfoResults/Payment[gc_no != '']">
                <xsl:variable name="bg">
                    <xsl:choose>
                        <xsl:when test="position() mod 2 =  1">
                            <xsl:text>#FFFFFF</xsl:text>
                        </xsl:when>
                        <xsl:otherwise>
                            <xsl:text>#EFEFEF</xsl:text>
                        </xsl:otherwise>
                    </xsl:choose>
                </xsl:variable>
                <tr bgcolor="{$bg}">
                    <td align="left" valign="top">Gift Certificate - <strong>Redemption Code: <xsl:value-of select="//GetOrderDetailsInfoResults/Payment[gc_no != '']/gc_no" /></strong><br /></td>
                    <td align="right" valign="top" width="50" ><xsl:value-of select="format-number(number(payment_amt) * -1, '$###0.00')"/></td>
                </tr>
                </xsl:for-each>
        <tr>
            <td align="right" valign="top" style="border-top: 1px solid #666666;">Total Gift Certificate Cost:</td>
            <td align="right" valign="top" style="border-top: 1px solid #666666;"><xsl:value-of select="format-number($thisTotal,'$###0.00')" /></td>
        </tr>
            </table><br />
            If  you were unable to print your gift  certificate(s) at time of purchase, <br />
please contact the TPAC Box Office at 615-782-4040 to have your gift certificate printed.
        </td>
    </tr>
</xsl:if>
<!-- /GIFT CERT HANDLING -->

Here is the code ( sorry for formatting ):

<!-- GIFT CERT HANDLING new based on gc_no variable -->

<xsl:if test="count(//GetOrderDetailsInfoResults/Payment[gc_no != '']) &gt; 0">

<xsl:variable name="thisTotal" select="number(sum(//GetOrderDetailsInfoResults/Payment[gc_no != '']/payment_amt)*-1)"/>

<tr>

<td align="left" valign="top" colspan="2" style="background-color: #666666; color: #FFFFFF;">

<b>Gift Certificates(s):</b>

</td>

</tr>

<tr>

<td align="left" valign="top" colspan="2">

<table align="left" valign="top" cellpadding="2" cellspacing="0" width="100%">

<tr>

<th align="left" valign="top" style="font-size: 11px; font-weight: bold; text-decoration: underline;">Description</th>

<th width="50" align="right" valign="top" style="font-size: 11px; font-weight: bold; text-decoration: underline;">Total</th>

</tr>

<xsl:for-each select="//GetOrderDetailsInfoResults/Payment[gc_no != '']">

<xsl:variable name="bg">

<xsl:choose>

<xsl:when test="position() mod 2 = 1">

<xsl:text>#FFFFFF</xsl:text>

</xsl:when>

<xsl:otherwise>

<xsl:text>#EFEFEF</xsl:text>

</xsl:otherwise>

</xsl:choose>

</xsl:variable>

<tr bgcolor="{$bg}">

<td align="left" valign="top">

Gift Certificate <xsl:value-of select="gc_no"/>

</td>

<td align="right" valign="top" width="50" >

<xsl:value-of select="format-number(number(payment_amt) * -1, '$####.##')"/>

</td>

</tr>

</xsl:for-each>

<tr>

<td align="right" valign="top" style="border-top: 1px solid #666666;">Total Gift Certificate Cost:</td>

<td align="right" valign="top" style="border-top: 1px solid #666666;">

<xsl:value-of select="format-number($thisTotal,'$####.##')" />

</td>

</tr>

</table>

</td>

</tr>

</xsl:if>

<!-- /GIFT CERT HANDLING -->

Sabina Spilkin

San Diego Symphony

619.615.3904

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Harpreet Gangyan
Sent: Monday, November 09, 2009 5:44 PM
To: Sabina Spilkin
Subject: RE: [Tessitura Technical Forum] Confirmation E-mail

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!


This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!