Education questions

Holly -

I've worked with Tessitura in an Education setting extensively through previous positions. Would be happy to help! Feel free to ping me off-list with any questions.

Patrick Schley
Marketing Manager - Milwaukee Repertory Theater
pschley@milwaukeerep.com

 

Hi Holly,

At the Young Vic we're in the process of integrating our 'Taking Part' department into Tessitura as much as possible.  This is definitely an ongoing process, but if there's anything I can help with, please don't hesitate to give me a shout.

Grae

Hi Graeme,

What would you advise about adding schools to the database? Can a school record be added with multiple names attached to it , or does each individual teacher need to be added seperately? If this is the case how would you find information about how many tickets a school had bought overall?

Hope that makes sense. I would be glad of any advice

Jean Baynham

Cheltenham Festivals Box Office

-- Holly Dabbs | Data and Systems Coordinator | 020 7424 6779 | www.roundhouse.org.uk

Each year the Roundhouse works with over 3,000 11-25s enabling them to realise their creative potential; and offers audiences of all ages new and extraordinary experiences in live music, circus, theatre and new media.

Roundhouse Trust registered office: 100a Chalk Farm Road, London NW1 8EH. A company limited by guarantee. Registered in England and Wales. Company number 3572184. Charity number 1071487. This message is private and confidential. If you've received it in error, please notify us and remove it from your system.

Hi Holly,

At the Young Vic we're in the process of integrating our 'Taking Part' department into Tessitura as much as possible.  This is definitely an ongoing process, but if there's anything I can help with, please don't hesitate to give me a shout.

Grae

Hi

Im emailing from the Roundhouse in London we run craetive programme for 11-25yrs. I am responible for the educational side of Tessituria. Im currently trying to streamline the way that we do this arcoss our core, outreach and young member programme so that the best data can be pulled for funding reports etc. We are currently  having a bit of a total re-vamp of the way our organisation uses the system and I was wondering if I could contact someone who works with Tessituria in a 'educational' way for some advice.

Thanks in advance,

Holly

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Education Forum. You may reply to this message to post to the Education 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!
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet
________________________________________________________________________

Hi Jean,

We work it similarly to Patrick at Milwaukee Rep.  Schools records have individual teacher records associated with them.  All the bookings live on the school record and we link the teacher's record to the order as well in the 'Custom Data' tab on the order.

This is quite handy because we can also track a teacher if they move schools.

Does that make sense?  Let me know if you have any other questions.

Grae

Thanks Grae,
That's t really interesting.

Can I ask you about the Customer Data tab. I have looked and and I cant seem to add any extra information to it. Am I missing something obvious?

Jean Baynham
Box Office Supervisor
Cheltenham Festivals
+44 (0)1242 505444
http://cheltenhamfestivals.com

The Cheltenham Jazz Festival 27 April - 2 May 2011
The Times Cheltenham Science Festival 7 - 12 June 2011
The HSBC Cheltenham Music Festival 29 June - 10 July 2011
The Times Cheltenham Literature Festival 7 - 16 October 2011
Address: CF Ticketing, Unit 77, Regent Arcade Shopping Centre, High Street. Cheltenham GL501 1JZ
Cheltenham Festivals Ltd: Charity No 251765 / Vat Reg No 100 1140 13

________________________________

From: Tessitura Education Forum on behalf of Graeme Ellis
Sent: Mon 21/03/2011 17:21
To: Baynham, Jean
Subject: Re: [Tessitura Education Forum] Education questions



Hi Jean,

We work it similarly to Patrick at Milwaukee Rep. Schools records have individual teacher records associated with them. All the bookings live on the school record and we link the teacher's record to the order as well in the 'Custom Data' tab on the order.

This is quite handy because we can also track a teacher if they move schools.

Does that make sense? Let me know if you have any other questions.

Grae

From: Jean Baynham
Sent: 3/18/2011 7:54:36 AM


Hi Graeme,

What would you advise about adding schools to the database? Can a school record be added with multiple names attached to it , or does each individual teacher need to be added seperately? If this is the case how would you find information about how many tickets a school had bought overall?

Hope that makes sense. I would be glad of any advice

Jean Baynham

Cheltenham Festivals Box Office




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

This E-mail message, including any attachments, is intended only for the person or entity to which it is addressed, and may contain confidential information. If you are not the intended recipient, any review, retransmission, disclosure, copying, modification or other use of this E-mail message or attachments is strictly forbidden. If you have received this E-mail message in error, please contact the author and delete the message and any attachments from your computer.
You are also advised that the views and opinions expressed in this E-mail message and any attachments are the author's own, and may not reflect the views and opinions of Cheltenham Festivals Ltd.
www.cheltenhamfestivals.com

Hi Jean

We configure all our custom data tabs using a SQL stored procedure and an InfoMaker object.

There is some documentation on custom tabs stored on the T drive (or your relevant drive):

T:\Documentation\IT and DBA Documentation\Customizations

Hope this helps.

 

Mark