Good morning all -
We are relatively new to using Tessitura for our student academy, and I am struggling with finding the best way to pull a list of student rosters and emails for students enrolled in a specific class (performance) or student level (production season). The performances are dated the first week of Sept 22 when our classes began, and they go through May 23.
Some things to consider:
1. The students are the recipient of the performance, but I would like to pull all emails of the household to make sure all parents are included.
2. Orders are a mix of single tickets and packages. More advanced students with a prescribed curriculum take packages, younger students can take one or two classes as single performances. (this has made it difficult to find a report that encompasses all of the performances).
3. Orders are a mix of paid and unpaid - scholarship students are paid and students who paid upfront at the beginning of the year have no balance, but the rest of the kids are on payment plans (again this has made it hard to find a report that encompasses all performance orders, regardless of payment or "attendance" status).
I haven't had much luck with list manager - there is no criteria available based solely on orders. (Can I build my own criteria)? And I do not seem to understand the rhyme or reason to which email from the household a list will pull.
I also haven't found a good report for listing out the list of classes (performances) with the recipient name to use as class rosters. The performance seating book is ok, but is there a way to configure it with extra criteria I want, and take away the stuff I don't? (for instance the instructors don't need to see "paid v unpaid" on the report, and I would prefer the full performance description at the top versus just the code).
Thank you all for your help!
Katie J. Toomey said:I haven't had much luck with list manager - there is no criteria available based solely on orders. (Can I build my own criteria)? And I do not seem to understand the rhyme or reason to which email from the household a list will pull.
I did create a custom criteria set for Order details we wanted to search on. List Criteria (and Output Sets) can be extended by organizations, though it requires at least a little SQL knowledge.
That's kind of what I thought. I'm slowly learning SQL. I wasn't sure how easy it would be to add my own criteria and output data points, or if it's something they would steer towards consulting.
It mostly depends on your comfort level and familiarity with the database itself. And certainly deadlines and budget when it comes to whether you want to punt it to consulting, which I still do from time to time if projects are building up.
Generally the hardest part of building a new criteria set is if you need to pull together information that isn't currently organized in that fashion in the database: that is you need to create a new view in the database. Adding a new criteria set for orders would generally be on the easier end of things, since you would just need to know your way around the orders table (T_ORDER) and just do the setup in System Tables (T_KEYWORD and T_KEYWORD_CATEGORY).