Using custom data in an email confirmation

Hi again – here is another example that adds custom data retrieved from a stored procedure to one or more line items in the order confirmation data:

<%

    Tessitura.WebAPI.Tessitura tess = new Tessitura.WebAPI.Tessitura();

    string sessionkey = tess.GetNewSessionKey("");

    ds = tess.ExecuteLocalProcedure(sessionkey, 114, "@ORDER_NO=" + OrderData.OrderNumber);

   for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)

    {

        string liSeqNo = ds.Tables[0].Rows[i]["li_seq_no"].ToString();

        string pkgDesc = ds.Tables[0].Rows[i]["pkg_desc"].ToString();

        XmlNode xm = OrderData.CartDocument.SelectSingleNode("//LineItem[li_seq_no=" + liSeqNo + "]");

        if (xm != null)

        {

            XmlElement xePkgDesc = OrderData.CartDocument.CreateElement("new_pkg_desc");

            xePkgDesc.InnerText = pkgDesc;

            xm.AppendChild(xePkgDesc);

        }          

    }

%>

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Patrick Schley
Sent: Friday, August 28, 2015 12:57 PM
To: David Frederick <DFrederick@scfta.org>
Subject: [Tessitura Technical Forum] Using custom data in an email confirmation

(I'm cross-posting this to a couple of forums; apologies to those who get multiple copies...)

Tessiturians -

I am currently working with our DBA to investigate the possibility of creating an order confirmation email that can be used by our financial aid staff. Currently, we use an excel sheet (shudder) and a Word/Outlook mail merge (shudder again) to accomplish this. Ideally, it would be infinitely better if the staff person could just send a confirmation right from Tess instead.

The problem we are running into is including some custom data in these confirmations. Our DBA and I have only a small smidgen of experience with Web API stuff, but from reading the documentation we are unsure about bringing in some of the data elements we'd like to have on the confirmation. Specifically, the name of the Recipient for each line item, and the total financial aid disbursement (which is recorded on a custom screen on the constituent record).

Does anyone have experience with doing something like this?

Thanks!

Patrick Schley
Academy Services Manager
First Stage 

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 again – here is another example that adds custom data retrieved from a stored procedure to one or more line items in the order confirmation data:

<%

    Tessitura.WebAPI.Tessitura tess = new Tessitura.WebAPI.Tessitura();

    string sessionkey = tess.GetNewSessionKey("");

    ds = tess.ExecuteLocalProcedure(sessionkey, 114, "@ORDER_NO=" + OrderData.OrderNumber);

   for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)

    {

        string liSeqNo = ds.Tables[0].Rows[i]["li_seq_no"].ToString();

        string pkgDesc = ds.Tables[0].Rows[i]["pkg_desc"].ToString();

        XmlNode xm = OrderData.CartDocument.SelectSingleNode("//LineItem[li_seq_no=" + liSeqNo + "]");

        if (xm != null)

        {

            XmlElement xePkgDesc = OrderData.CartDocument.CreateElement("new_pkg_desc");

            xePkgDesc.InnerText = pkgDesc;

            xm.AppendChild(xePkgDesc);

        }          

    }

%>

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Patrick Schley
Sent: Friday, August 28, 2015 12:57 PM
To: David Frederick <DFrederick@scfta.org>
Subject: [Tessitura Technical Forum] Using custom data in an email confirmation

(I'm cross-posting this to a couple of forums; apologies to those who get multiple copies...)

Tessiturians -

I am currently working with our DBA to investigate the possibility of creating an order confirmation email that can be used by our financial aid staff. Currently, we use an excel sheet (shudder) and a Word/Outlook mail merge (shudder again) to accomplish this. Ideally, it would be infinitely better if the staff person could just send a confirmation right from Tess instead.

The problem we are running into is including some custom data in these confirmations. Our DBA and I have only a small smidgen of experience with Web API stuff, but from reading the documentation we are unsure about bringing in some of the data elements we'd like to have on the confirmation. Specifically, the name of the Recipient for each line item, and the total financial aid disbursement (which is recorded on a custom screen on the constituent record).

Does anyone have experience with doing something like this?

Thanks!

Patrick Schley
Academy Services Manager
First Stage 

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!