Web Source Codes

There are a couple ways that you can pass this type of information to the Web API. Take a look at the system tables for tr_local_data and tr_local_procedure. The web API methods GetLocalData and ExecuteLocalProcedure respectively then pull from custom views or procedures stored in these tables. I have always used the tr_local_data. Seems to work fine for me. You would just have to build the view to pull the appropriate sources respecting start and end dates at the source, appeal, and campaign levels and also filter out if the source is contribution only. I would have a sneaky suspicion that there would be several sources you would not want available for customer selection on the web such as walk-up so you would need to figure out how to filter those out through your view.  The Login methods and the RegisterWithPromoCodes method would populate the order with the source. Also keep in mind that if the source is designed to do a Mode of Sale switch or apply an offer, these sources are also stored in the system table tr_web_source_no. So if the customer received an promotion code, they would need the ability to enter the source number or code. Sometimes these codes are only for a certain group of customers and not available for the general public and therefore shouldn't be in the drop down.

If you have any other questions, don't hesitate to ask.

Marty

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Christopher Wright
Sent: Friday, June 29, 2012 6:42 AM
To: Martin A. Jones
Subject: [Tessitura Web Forum] Web Source Codes

Hi All

We're currently having our new website built and our web developers are having trouble with how we want to handle source codes.

What we want is to have a drop down box where the customer can choose where they heard about the show, (very much like when you choose the source code when you are doing a telesale) that would be populated from the source codes stored in Campaigns > Appeals and then have the selection stored in the order.

Does anyone know if this is possible and which API method they should use for both pulling the list of available sources and storing the selection in the order.

Many Thanks,

Chris.

You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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 Chris,

We just implemented this functionality. We have a drop down on the payment page where people select the source. The web method is UpdateSourceCode. You can see this on our site www.flynntix.org. Put something in the cart and go all the way to the payment page.

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Christopher Wright
Sent: Friday, June 29, 2012 7:43 AM
To: Gloria Ormsby
Subject: [Tessitura Web Forum] Web Source Codes

Hi All

We're currently having our new website built and our web developers are having trouble with how we want to handle source codes.

What we want is to have a drop down box where the customer can choose where they heard about the show, (very much like when you choose the source code when you are doing a telesale) that would be populated from the source codes stored in Campaigns > Appeals and then have the selection stored in the order.

Does anyone know if this is possible and which API method they should use for both pulling the list of available sources and storing the selection in the order.

Many Thanks,

Chris.

You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

Not on staff. We have a local company we work with. They are very good and know the API very well.

VT Design Works

Andrew F Allen  andrew@vtdesignworks.com

802-383-7679

Yes. It uses the default source in that circumstance.

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Brian Laczko
Sent: Tuesday, July 03, 2012 10:50 AM
To: Gloria Ormsby
Subject: RE: [Tessitura Web Forum] Web Source Codes

Hi Gloria,

Cool feature.  What happens when a customer uses a promo code?  Does the dropbox disable?

Thanks,

Brian