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!

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!