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
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
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!
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.
If you still use this script, can I get a copy of it as well?
Thanks.
Adria
Hi Adria
I've put a copy of the scripts in my files here
It outputs 5 datasets - each time I run it, I copy and paste each of them into a worksheet within one excel file; then it's used for various checking processes; then some of the columns are deleted to simplify things, and the whole thing is sent to our mailing house, who produce the individualised renewal form/covering letter, using their own software to link the various bits of info in the different worksheets.
A few caveats.
It's still fairly local - you'd need to work through it carefully and update magic numbers etc.
It assumes that the rollover has completed, and that all packages are in a single Season ( although you could obviously run it once for each Season if you use multiples.
It relies on local functions to produce the seating description, and to select a login to use if the person has more than one.- They're there as well.
There is another script there, which we run first, to create dummy logins for subscribers who don't have one, so that they can log on and renew online.
If we have an email, but no login, we just create a login for them, and set an initial pw of their order number. If we don;t have an email for them, we create a dummy one of those as well, first. If they do use the dummy login to renew, we ask them to update it to a real one (but they don't have to - we ask them after they've completed the renewal, so as not to interfere with the renewal process)
In this version, we provide subs who have an existing login with a hint for the pw - we won't be able to do that in v12. i think we'll still be able to create a dummy login and assign an initial pw, but I haven't worked thought that yet. Sufficient unto the day, etc.
We use an Association to link Companion Subscribers - we print their names on the renewals where we know who they are, and ask for the names if we don't.
HTH.