• Replies 3 replies
  • Subscribers 415 subscribers
  • Views 369 views
  • Users 0 members are here
Related

Web Ranking: Getting Started

Cody Palmer (Past Member)
$organization

Hello all,

I'm wanting to set up Web Ranking for our constituents based on membership levels so when they log onto our TNEW site with their member account "Member" price type are hidden or unavailable until they log in.  I'm a bit confused on where to start, however, I can set up a new rank, but I've no idea how to tie that to a Membership Organization.  I'm assuming it is done through a stored procedure at some point.  I need some advice on where to start, maybe testing with one constituent.

I understand Rankings directly tie to Modes of Sale as well.  So does this mean for each Member Level/Ranking I have to create a new Mode of Sale?  Currently all of our Web sales are done through a "Web Sales" MOS.  Can I associate Ranking MOS with the Web Sales MOS so we don't have to add each Ranking MOS to every single performance with Web Sales?

Also, Start/End numbers are a bit confusing, I'm not sure what the significance of having a large vs smaller number means or why a Ranking would have a range, say 425-500 vs 425-600.  Why would you have a large ranking number?  Why would you have shorter or larger range on your rankings?

Thank you in advance. Cheers!

Parents
  • $organization

    Hi Cody,

     

    We recently separated our membership levels by Modes of Sale to achieve the online user experience you are looking for.

     

    We created separate Modes of Sale for each member level (e.g. Online Member Friend, Online Member Supporter…etc.). The new modes of sale do need to be added to all performances.

     

    We used very simple web ranking numbers 10/20/30… to keep it straightforward. Just update TR_Web_Ranking with the rank type of Web Rank and your new modes of sale with their corresponding web rank numbers. Make sure all of your performances have the matching Web Rank designation.

     

    For testing, I use myself as a constituent and change my web rank to see what price types are available to me when I login as a member.

     

    Hope this helps!

     

    Jennie

     

     

    Jennie Herreid

    Ticket Services Manager

    Thompson Arts Center at Park Avenue Armory

    643 Park Avenue at 67th Street

    New York, NY 10065

    (212) 933-5827

    (212) 933-5812 Box Office

    jherreid@armoryonpark.org  

    www.armoryonpark.org

     

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Cody Palmer
    Sent: Thursday, July 14, 2016 11:55 AM
    To: Jennie Herreid
    Subject: [Tessitura Ticketing Forum] Web Ranking: Getting Started

     

    Hello all,

    I'm wanting to set up Web Ranking for our constituents based on membership levels so when they log onto our TNEW site with their member account "Member" price type are hidden or unavailable until they log in.  I'm a bit confused on where to start, however, I can set up a new rank, but I've no idea how to tie that to a Membership Organization.  I'm assuming it is done through a stored procedure at some point.  I need some advice on where to start, maybe testing with one constituent.

    I understand Rankings directly tie to Modes of Sale as well.  So does this mean for each Member Level/Ranking I have to create a new Mode of Sale?  Currently all of our Web sales are done through a "Web Sales" MOS.  Can I associate Ranking MOS with the Web Sales MOS so we don't have to add each Ranking MOS to every single performance with Web Sales?

    Also, Start/End numbers are a bit confusing, I'm not sure what the significance of having a large vs smaller number means or why a Ranking would have a range, say 425-500 vs 425-600.  Why would you have a large ranking number?  Why would you have shorter or larger range on your rankings?

    Thank you in advance. Cheers!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • $organization in reply to Jennie Herreid

    Success! 

    I've managed to test it in small-scale on just my constituent record with success.  Now I'm wondering:  How do I edit the LP_CUSTOMER_RANK stored procedure to update the ranking for a constituent automatically when A) We update their Membership/Membership Level and B) Their membership becomes inactive.

    I don't even know where to access stored procedures, I may not even currently have permission. Any further ideas on where to get started?

    Thanks for your help so far!



    [edited by: Cody Palmer at 11:32 AM (GMT -6) on 18 Jul 2016]
  • $organization in reply to Cody Palmer (Past Member)

    We have our own custom stored procedures that insert rankings into customer accounts based on certain criteria, just like you want to do. However, it requires a knowledge of databases and SQL. Our IT manager and myself both had to take classes and teach ourselves how to use SQL in order to start doing our own procedures. And then we had to request access to the SQL Server Management Studio from RAMP.

    Also, as far as we know, you can't setup the procedure as a Trigger (as in it is triggered by an action taking place in the tessitura application.) We have to set ours up as jobs, so they run at scheduled times, for us the beginning of the day and the end of the work day. So if a membership becomes inactive, the ranking wont clear out till the next scheduled time the job is run. Or you can edit the ranking manually before the job runs. If you don't have anyone at your organization who knows SQL, Tessitura or a consulting agency could probably write it for you for a consulting fee.

Reply
  • $organization in reply to Cody Palmer (Past Member)

    We have our own custom stored procedures that insert rankings into customer accounts based on certain criteria, just like you want to do. However, it requires a knowledge of databases and SQL. Our IT manager and myself both had to take classes and teach ourselves how to use SQL in order to start doing our own procedures. And then we had to request access to the SQL Server Management Studio from RAMP.

    Also, as far as we know, you can't setup the procedure as a Trigger (as in it is triggered by an action taking place in the tessitura application.) We have to set ours up as jobs, so they run at scheduled times, for us the beginning of the day and the end of the work day. So if a membership becomes inactive, the ranking wont clear out till the next scheduled time the job is run. Or you can edit the ranking manually before the job runs. If you don't have anyone at your organization who knows SQL, Tessitura or a consulting agency could probably write it for you for a consulting fee.

Children
No Data