Order Email Confirmations

Hi Tessiturians,

I've customized Order Email Confirmation that our Education department sends to schools attending a concert.  But sometimes they need a printed copy of this email - is there a way to send this email to a printer from within Tessitura?

Thanks, Sabina.

 

 

 

  • You could set the bcc: field to your Education staff and they can print out.
    --------------------------
    Sent using BlackBerry


    -----

    Original Message -----
    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To: Matt Hilgers
    Sent: Wed Apr 27 18:13:17 2011
    Subject: [Tessitura Technical Forum] Order Email Confirmations

    Hi Tessiturians,

    I've customized Order Email Confirmation that our Education department sends to schools attending a concert.  But sometimes they need a printed copy of this email - is there a way to send this email to a printer from within Tessitura?

    Thanks, Sabina.










    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!

  • Matt, is there a way to bcc only Education emails - I bcc all confirmation emails from a setting in T_DEFAULTS.  Thank you !


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Hilgers
    Sent: Wednesday, April 27, 2011 4:18 PM
    To: Sabina Spilkin
    Subject: Re: [Tessitura Technical Forum] Order Email Confirmations

    You could set the bcc: field to your Education staff and they can print out.
    --------------------------
    Sent using BlackBerry


    -----

    Original Message -----
    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To: Matt Hilgers
    Sent: Wed Apr 27 18:13:17 2011
    Subject: [Tessitura Technical Forum] Order Email Confirmations

    Hi Tessiturians,

    I've customized Order Email Confirmation that our Education department sends to schools attending a concert.  But sometimes they need a printed copy of this email - is there a way to send this email to a printer from within Tessitura?

    Thanks, Sabina.










    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!
  • You're right, I hadn't thought it through.  This is why I never answer these things. 

    You could still do a bcc and then add an Outlook rule based on the subject line to auto delete any of the ones not Education.   Or send them from a test environment after flipping the email addresses.

    --------------------------
    Sent using BlackBerry


    -----

    Original Message -----
    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To: Matt Hilgers
    Sent: Wed Apr 27 18:33:20 2011
    Subject: RE: [Tessitura Technical Forum] Order Email Confirmations

    Matt, is there a way to bcc only Education emails - I bcc all confirmation emails from a setting in T_DEFAULTS.  Thank you !


    ________________________________

            From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Hilgers
            Sent: Wednesday, April 27, 2011 4:18 PM
            To: Sabina Spilkin
            Subject: Re: [Tessitura Technical Forum] Order Email Confirmations
           
           

            You could set the bcc: field to your Education staff and they can print out.
            --------------------------
            Sent using BlackBerry
           
           
            ----- Original Message -----
            From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
            To: Matt Hilgers
            Sent: Wed Apr 27 18:13:17 2011
            Subject: [Tessitura Technical Forum] Order Email Confirmations
           
            Hi Tessiturians,
           
            I've customized Order Email Confirmation that our Education department sends to schools attending a concert.  But sometimes they need a printed copy of this email - is there a way to send this email to a printer from within Tessitura?
           
            Thanks, Sabina.
           
           
           
           
           
           
           
           
           
           
            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!

  • Hi Sabina,

    A couple things come to mind.  First I would think there would be a template for just education so that other types of orders  would  not send a copy of the email.  Then in your education template there are two things I might try to do.  First is in the template aspx page I would try to create and fire off an email with in it.  createatig a new message with the order information.  Something like the following:

    <%@ Import Namespace="System.Web.Mail" %>
    <%
    MailMessage objMail = new MailMessage();
    objMail.From = "jballinger@mccarter.org";
    objMail.To = "jballinger@mccarter.org";
    objMail.Subject = "Response from website";
    objMail.Body = "This an edu order" + OrderData.OrderNumber ;
    SmtpMail.SmtpServer = "192.169.1.1;
    SmtpMail.Send(objMail);
    %>

    My second thought if this does not work is to execute a local procedure from the email confirmation and have the local procedure send an email out to the edutcation recipient with the proper information.  Thie code in the template file could be something like:

    <%
    Tessitura.WebAPI.Tessitura tess = new Tessitura.WebAPI.Tessitura();
    string sessionkey = tess.GetNewSessionKey("");
    tess.ExecuteLocalProcedure(sessionkey, 1, "@ORDER_NO=" + OrderData.OrderNumber +"@RECIPIENT=jballinger@mccarter.org");
    %>

    Hope this helps,

    Jon



    [edited by: Jon Ballinger at 9:23 PM (GMT -6) on 27 Apr 2011]
  • Hi Sabina,  I had a chance to test out the first example and it works.  One thought I had with either method is that you could use a custom field in the order as the email addresses to be copied on.  Then  use that data in the template to send the email. 

  • Jon,  thanks again!  I pasted your first solution into .aspx template for education ( changed the IP address and from/to : ).  Is there a specific place in the .aspx template to place this code? 
    Sabina


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Thursday, April 28, 2011 6:05 AM
    To: Sabina Spilkin
    Subject: Re: [Tessitura Technical Forum] Order Email Confirmations

    Hi Sabina,  I had a chance to test out the first example and it works.  One thought I had with either method is that you could use a custom field in the order as the email addresses to be copied on.  Then  use that data in the template to send the email. 

    From: Jon Ballinger <bounce-jonballinger5072@tessituranetwork.com>
    Sent: 4/27/2011 9:18:05 PM

    Hi Sabina,

    A couple things come to mind.  First I would think there would be a template for just education so that other types of orders  would  not send a copy of the email.  Then in your education template there are two things I might try to do.  First is in the template aspx page I would try to create and fire off an email with in it.  createatig a new message with the order information.  Something like the following:

    <%@ Import Namespace="System.Web.Mail" %>
    <%
    MailMessage objMail = new MailMessage();
    objMail.From = "jballinger@mccarter.org";
    objMail.To = "jballinger@mccarter.org";
    objMail.Subject = "Response from website";
    objMail.Body = "This an edu order" + OrderData.OrderNumber ;
    SmtpMail.SmtpServer = "192.169.1.1;
    SmtpMail.Send(objMail);
    %>

    My second thought if this does not work is to execute a local procedure from the email confirmation and have the local procedure send an email out to the edutcation recipient with the proper information.  Thie code in the template file could be something like:

    <%
    Tessitura.WebAPI.Tessitura tess = new Tessitura.WebAPI.Tessitura();
    string sessionkey = tess.GetNewSessionKey("");
    tess.ExecuteLocalProcedure(sessionkey, 1, "@ORDER_NO=" + OrderData.OrderNumber +"@RECIPIENT=jballinger@mccarter.org");
    %>

    Hope this helps,

    Jon




    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!
  • The import should be up at the top.  Is it possible for me to take a look at your aspx file?  Also are you getting an error message when sending the confirmation at all?

  • Sabina,  Attached is my working example granted there are some extra calls to the webapi's executelocalprocedure that would not apply. But you can see where i have the email code in  place.

  • Jon,  I am attaching our .aspx file. I looked at your example and realize that my placement is not correct .... I am attaching our .aspx file if you have a chance to take a look.  Thanks a bunch!

    Sabina

  • Just to update what I have found with sending in either method.  If you have both an html & text template for the confirmation the email code should go in the text template.  It seems both files are executed so you only need it once.  If you have just an html template then put the code in the html template.

     

  • Jon. 

    Do you know if it's possible to have the other printing options turned off when either an email confirmation is chosen from the dropdown or when the Acknowledgment box is checked? We, of course, occasionally accidentally forget to uncheck the boxes at the top of the Print menu when sending email confirmations. I'm trying to troubleshoot getting rid of that risk.

    Thanks. 

  • Hi Adria,

    Not that I am aware of .  But you might want to investigate have an interceptor for this purpose.  For example you might be able to have an interceptor plugin fire on an order save  and it would go an automatically send the email confirmation.  This would remove the need to go into print tickets at all to send the email confirmation.

    Jon

  • I didn't thank you for this. Thanks. 

    On Sat, Jul 11, 2015 at 4:37 PM, Jon Ballinger <bounce-jonballinger5072@tessituranetwork.com> wrote:

    Hi Adria,

    Not that I am aware of .  But you might want to investigate have an interceptor for this purpose.  For example you might be able to have an interceptor plugin fire on an order save  and it would go an automatically send the email confirmation.  This would remove the need to go into print tickets at all to send the email confirmation.

    Jon

    From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>
    Sent: 7/10/2015 7:10:27 PM

    Jon. 

    Do you know if it's possible to have the other printing options turned off when either an email confirmation is chosen from the dropdown or when the Acknowledgment box is checked? We, of course, occasionally accidentally forget to uncheck the boxes at the top of the Print menu when sending email confirmations. I'm trying to troubleshoot getting rid of that risk.

    Thanks. 



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/4456/43119.aspx#43119 or reply to this message

    Adria Gunter | Subscriptions Manager

    STUDIO THEATRE

    1501 14TH ST NW

    WASHINGTON DC  20005

    T  202-232-7267, ext. (365)

    F  202-588-5262

    www.studiotheatre.org

    Subscriptions are online!

    2014-2015 SEASON    BELLEVILLE |BAD JEWS |CHOIR BOY |  LAUGH  | JUMPERS FOR GOALPOSTS

    2014-2015 SEASON    STUDIO 2ND STAGE  TERMINUS | MARY-KATE OLSEN IS IN LOVE   | SILENCE! THE MUSICAL

    2014-2015 SEASON    SPECIAL EVENTS  AND LAB   THE WOLFE TWINS | MURDER BALLAD

  • Custom Data can be pulled into the email confirmations.  This is done by writing code in the asp page to pull in the custom information. Earlier posts on this thread  have examples of custom data being brought in.   There are many examples of this  in forum posts and some conference  presentations .



    [edited by: Jon Ballinger at 3:24 PM (GMT -6) on 17 Jul 2015]
  • Jon, 
    Do you know if anyone has any kind of SQL or custom report that will pull confirmation info? Like the following:

    «TORCH_title»

    Mead Theatre

    «TORCH_date»  «TORCH_row» «TORCH_num»

    «HOPEY_title»

    Milton Theatre

    «HOPEY_date»  «HOPEY_row» «HOPEY_num»

    «SWEET_title»

    Milton Theatre

    «SWEET_date»  «SWEET_row»

    «TRIBES_title»

    Mead Theatre

    «TRIBES_date»  «TRIBES_row»«TRIBES_num»

    «WATER_title»   

    Metheny Theatre              

    «WATER_date»  «WATER_row»«WATER_num»       

    «COCK_title»

    Milton Theatre

    «COCK_date»  «COCK_row»«COCK_num» 

     The output should be something like this:


    Torch Song Trilogy

    Mead Theatre

    Sunday, September 15, 2013, 2 PM  G 213-214

    That Hopey Changey Thing

    Milton Theatre

    Sunday, December 29, 2013, 3 PM  B 204-205

    Sweet and Sad

    Milton Theatre

    Not yet purchased   

    Tribes

    Mead Theatre

    Sunday, January 19, 2014, 2 PM  G213-214

    Water By The Spoonful    

    Metheny Theatre              

    Sunday, March 16, 2014, 2 PM  F208-209  

    ***

    Milton Theatre

    Sunday, May 25, 2014, 2 PM  B204-205     


    On Sat, Jul 11, 2015 at 4:37 PM, Jon Ballinger <bounce-jonballinger5072@tessituranetwork.com> wrote:

    Hi Adria,

    Not that I am aware of .  But you might want to investigate have an interceptor for this purpose.  For example you might be able to have an interceptor plugin fire on an order save  and it would go an automatically send the email confirmation.  This would remove the need to go into print tickets at all to send the email confirmation.

    Jon

    From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>
    Sent: 7/10/2015 7:10:27 PM

    Jon. 

    Do you know if it's possible to have the other printing options turned off when either an email confirmation is chosen from the dropdown or when the Acknowledgment box is checked? We, of course, occasionally accidentally forget to uncheck the boxes at the top of the Print menu when sending email confirmations. I'm trying to troubleshoot getting rid of that risk.

    Thanks. 



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/4456/43119.aspx#43119 or reply to this message

    Adria Gunter | Subscriptions Manager

    STUDIO THEATRE

    1501 14TH ST NW

    WASHINGTON DC  20005

    T  202-232-7267, ext. (365)

    F  202-588-5262

    www.studiotheatre.org

    Subscriptions are online!

    2014-2015 SEASON    BELLEVILLE |BAD JEWS |CHOIR BOY |  LAUGH  | JUMPERS FOR GOALPOSTS

    2014-2015 SEASON    STUDIO 2ND STAGE  TERMINUS | MARY-KATE OLSEN IS IN LOVE   | SILENCE! THE MUSICAL

    2014-2015 SEASON    SPECIAL EVENTS  AND LAB   THE WOLFE TWINS | MURDER BALLAD