Confirmation E-mail

Thanks Jon. It is really helping us a lot. If you don’t mind please send one of your template as you have mentioned in your mail.

Thanks a lot

Harpreet

Hi Harpeet,

What you can do  is create a stored procedure that pulls the CSI information that you need.  Then set this stored procedure up to be used through the web api's ExecuteLocalProcedure method.  Once this is done you can then make the web api's ExecuteLocalProcedure method from the email template aspx page.  Once you get the data back ou can use it in the email template, you can even add this data to the oder details xml so that it can be used in your transform.  Here is a link to an earlier post I sumbited on doing this.

 www.tessituranetwork.com/COMMUNITY/forums/t/977.aspx

If you need any other help or would like to check out one of our templates let me know.

Regards,

Jon

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 info. Do you think that code can extract Gift Certificate number as well as amount as we are looking at only these two things to print on E-mail.

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 Jon,

For some reason I can’t see the template attached with the mail. Is it possible for you to resend it please.

Thanks

Harpreet

Hi,

The attached template is pulling in extra subscription data, then appending it to the order details xml data before the transform. 

Regards,

Jon

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!