Getting Price Reserve on a Subs Renewal Notice

Hi Janna

I'm currently doing some work on that script, getting ready for our own renewals, which go out in August,. As part of that, I'll do some tidy-up.

So I might post it here after that, i think. Will be easier to read after I get rid of some of the cruft. Probably next week. OK?

Ken

From: Janna Ellis <bounce-jannaellis6942@tessituranetwork.com>
Sent: 6/19/2012 8:33:13 AM

Ken,

We ALWAYS have issues running our InfoMaker Sub Renewal form and have often wished I had a script that would pull the info into a spreadsheet that I could mail merge into a form.  It sounds like this might do the trick.  If you are willing to share, I would LOVE to try it.

Thanks,

Janna

 

Janna J Ellis

Associate Director of Audience Services and Tessitura Specialist

Yale Repertory Theatre/Yale School of Drama

203-432-1522

www.yalerep.org

 

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ken McSwain
Sent: Tuesday, June 19, 2012 2:59 AM
To: Ellis, Janna
Subject: Re: [Tessitura Ticketing Forum] Getting Price Reserve on a Subs Renewal Notice

 

Hi Dale

You can certainly get the Reserve and other information, because once you've done the rollover, you've got an Order you can use as a source for the rest of the info.

We don't use the standard renewal notice, of course. We pull a variety of information into a series of spreadsheeten,and send that off to a mailing house to produce the actual renewals, after a lot of proofing.

That uses a mildly complex script developed by Martin, and fairly localised. It's based on the assumption that all of your rollover orders are in a particular season, and there aren't any other active package orders in there, which seems reasonable.

I'm  happy to share it if you'd like to look at it, to see if you'd like to go that way. Usual caveats - it's written to be run manually and modified if necessary each time, it's not tidied up or well documented, and it is localised, with magic numbers and so on.

Ken

From: Dale Bradbury <bounce-dalebradbury9774@tessituranetwork.com>
Sent: 6/18/2012 1:15:08 AM

Hi,

The standard Subs Renewal Notice does not include the Price Reserve.  This is apparently because the Base Seat Map is used to hold the package seat locations for rollovers and is not associated with any performance.  As the customer would like to know what Reserve they are sitting in, there must be some way to get this data out as part of the Renewal Notice?

Can anyone assist?

Thanks

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!

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!