How do you Extend Tessitura today?

Hi,

As we explore and refine the potential architecture approach for the Next Generation product, a key element is extensibility.  The current Tessitura software provides a variety of ways for organizations to extend the software today, and we have heard loud and clear that a high degree of customization/extensibility in the future product is a key requirement.  One way to help us understand future extensibility needs is to first understand how you customize today.  This is a purposefully open-ended question: 

 

Please provide us with examples of customizations or extensions you have made to Tessitura and the business case behind why you made the extension.

 

We aren’t looking for every customization, but one or two samples that are either most representative or most difficult to accomplish in current Tessitura.

 

 

A quartet of examples:

1.       We created a custom Box Office Statement in InfoMaker to match specific output field requirements of our promoter.  This allows us to settle with the promoter in an efficient and speedy fashion, without us having to run multiple reports and combine them after the fact.

2.       We adapted lp_customer_rank to automatically assign a constituency code of ‘Student’ if the constituent has purchased tickets to our Education season and has a customer type of Child.  This allows CSRs to quickly identify students when looking up an account, and makes list pulling easier.

3.       We created a custom constituent screen using InfoMaker to hold detailed information about our Press contacts.  This allows us to have information about all constituents in one place, and ensures we can track specific seating assignments and preferences based on the reviewer.

4.       We created a set of pages on our website to record individual member names on a family membership, tied to a custom table and custom membership card output so we can print individual member names on membership cards and link them back to a single membership in Tessitura.  This means that multiple members of a household can each have their own personalized membership card while retaining a single membership on the household itself.

 

 

Thanks!

Andrew

Parents
  • Here are a few customizations, hopefully this is what you are looking for.

    Custom Package Sales Report:
    We do all of our exchanges, donated seats etc. within the original super package order so we have a report that maintains the value of the package before any exchanges, donated seats etc. have happened. This is what we use to report on subscription revenue.

    Lead Sheet Extract:
    Custom report to pull a single row of data per constituent that details 5 years of subscription packages, last 5 performances attended and last 5 years of donation history. This is also a good report to use in verifying extraction data that deals with similar information.

    Auto restrict eAddress:
    lp_customer_rank automatically populates the e-market restriction to "restricted" as we have an opt-in policy for email.

    Update restrictions report:
    Because of our email policy and that constituent import doesn't trigger lp_customer_rank (or at least didn't last I checked) we have a report to change mail phone and e-market restrictions en masse, via a list.

    Update MOD report:
    Because we do short season subscriptions using the dummy performance technique we need to ensure that when we have exchanged out the dummy performances that the tickets do not print in the batch ticket printing. To do this we use a specific method of delivery. After short seasons have been printed we need to update this MOD to ensure exchanged tickets are being printed so we created a report to do that.

Reply
  • Here are a few customizations, hopefully this is what you are looking for.

    Custom Package Sales Report:
    We do all of our exchanges, donated seats etc. within the original super package order so we have a report that maintains the value of the package before any exchanges, donated seats etc. have happened. This is what we use to report on subscription revenue.

    Lead Sheet Extract:
    Custom report to pull a single row of data per constituent that details 5 years of subscription packages, last 5 performances attended and last 5 years of donation history. This is also a good report to use in verifying extraction data that deals with similar information.

    Auto restrict eAddress:
    lp_customer_rank automatically populates the e-market restriction to "restricted" as we have an opt-in policy for email.

    Update restrictions report:
    Because of our email policy and that constituent import doesn't trigger lp_customer_rank (or at least didn't last I checked) we have a report to change mail phone and e-market restrictions en masse, via a list.

    Update MOD report:
    Because we do short season subscriptions using the dummy performance technique we need to ensure that when we have exchanged out the dummy performances that the tickets do not print in the batch ticket printing. To do this we use a specific method of delivery. After short seasons have been printed we need to update this MOD to ensure exchanged tickets are being printed so we created a report to do that.

Children