• Replies 13 replies
  • Subscribers 339 subscribers
  • Views 119 views
  • Users 0 members are here
Related

Confirmation E-mail

Harpreet Gangyan
$organization

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

Parents
  • $organization

    Hi Harpreet,

    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 call to the web api's ExecuteLocalProcedure method from the email template aspx page.  Once you get the data back you 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

     



    [edited by: Jon Ballinger at 5:03 PM (GMT -6) on 9 Nov 2009]
Reply
  • $organization

    Hi Harpreet,

    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 call to the web api's ExecuteLocalProcedure method from the email template aspx page.  Once you get the data back you 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

     



    [edited by: Jon Ballinger at 5:03 PM (GMT -6) on 9 Nov 2009]
Children
  • $organization in reply to Jon Ballinger

    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

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, 10 November 2009 10:39
    To: Harpreet Gangyan
    Subject: Re: [Tessitura Technical Forum] Confirmation E-mail

     

    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

     

    From: Harpreet Gangyan <bounce-harpreetsinghgangyan5939@tessituranetwork.com>
    Sent: 11/8/2009 5:09:09 PM

    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!