____________________________________________________________ Michael Mariano | Database ManagerNew York City Center | 130 W. 56th Street | New York, NY 10019Phone: 212.763.1255 | Fax: 212.247.4439 | Web: www.NYCityCenter.org
Michael,
Hello again ….
From someone who has spent two years trying to make sense and clean-up our seat sale program, I highly suggest not using attributes. I have found it very difficult to determine which seats have been sold, which are available, which were promised, etc. They way the seat sale program was handled here at the Orange County Performing Arts Center in the past was to add an attribute and then record the seat name in Names/Recognition. As that space has character limits, many of the names were abbreviated, plaques misprinted … the list goes on. In attempting to re-organize and re-launch the project, I have worked with my ticketing department to create seat maps of the halls were we sell seats and then I go in and sell a ticket to that seat. Our hope in the future is to be able to offer seat-sale opportunities online where our patrons can use seat buddy to check out the view of the seat they wish to purchase and to be able to choose their own seat from the web in real time. When you open a donor’s record, you would look for the performance of “Seat Sale” and look up the seat or seat locations there. If you wanted to use a constituency to indicate this person was a seat owner, I am sure your IT team could write a script to make the constituency appear automatically and save you time on manual entry.
I think a few other organizations are handling their seat-sale programs the same way.
Good luck with this project too!
Amber
_______________________________________________________
Amber Albert
Manager, Special Campaigns
Orange County Performing Arts Center
600 Town Center Drive Costa Mesa, CA 92626
T 714.556.2122 x4259 F 714.755.2712 E AAlbert@OCPAC.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Michael Mariano Sent: Monday, August 23, 2010 8:47 AM To: Albert, Amber Subject: [Tessitura Development Forum] Seat Naming - seat location information
(Apologies in advance; I'm about to send two e-mails to the discussion group.)
Hi everyone,
We are putting together a seat naming campaign for New York City Center. Does anyone have any suggestions on how to put this together?
A previous discussion was helpful in figuring out how people are storing the dedication text:
http://www.tessituranetwork.com/COMMUNITY/forums/t/2712.aspx
But what about seat location? If someone is naming Orchestra seat C1 - 3, where do you store that information?
We were thinking of storing the dedication text and seat locations as separate attributes.
We were also thinking of using a manual constituency to identify donors who have named seats. Does this seem useful?
Thanks to all for your advice.
-- Mike
____________________________________________________________ Michael Mariano | Database Manager New York City Center | 130 W. 56th Street | New York, NY 10019 Phone: 212.763.1255 | Fax: 212.247.4439 | Web: www.NYCityCenter.org
_______________________________________________________________________