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!

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!