I have yet another question about using the Tessitura Event History Screen.
The Guest Name Field unfortunately is only one field, which makes it hard to
1) create an alpha sort – can only be accomplished when you enter the name LAST NAME, FIRST NAME
2) print table cards, envelope labels etc. – can only be accomplished when you enter the name FIRST NAME LAST NAME
3) have a way to formally address them (including Mr. / Mrs. to their name) – can only be accomplished when you enter the name MR.MRS FIRST NAME LAST NAME
I saw at a presentation in the 2009 conference that someone came up with a solution for that putting a * in between the first and last name – so this could be filtered out in excel? Unfortunately I have forgotten whose presentation I was watching, and what the details were.
If you read this would you mind sharing the information again??
I also remember seeing in 2008 that NYC OPERA is using the performance Seat Field to enter the name again using LAST NAME, FIRST NAME.
Does any one have other suggestions?
Also related to that we would like to use the Event Listing Report that comes with the system. Has anyone by any chance modified it to include the CNFR checkbox and the Source number?
Thanks everyone!
Monika
Monika Jouvert
Brooklyn Academy of Music
Development Business Process Director
718.623.7810 x6 / internally x4253
mjouvert@bam.org
http://www.bam.org
Monika,
It was Alex at Seattle Rep who presented on Events and putting an * between first and last name. In excel you can use the "text to columns" function (from the Data dropdown) to separate them into 2 separate columns.Dale
Hi Monika,
In addition to the Excel solution I mentioned at the conference, we’ve also built a local view that mirrors tx_event_guest, but breaks out guest_name into last name, first name, and full name. The code for the view is:
CREATE VIEW [dbo].[LVX_EVENT_GUEST]
AS
SELECT evex_no,
campaign_no,
customer_no,
source_no,
guest_name,
substring(ltrim(guest_name),1,
isnull(nullif(charindex('*',guest_name)-1,-1),len(guest_name)))
AS [guest_lname],
substring(ltrim(guest_name),nullif(charindex('*',guest_name)+2,2),len(guest_name))
AS [guest_fname],
+' '
+substring(ltrim(guest_name),1,
AS [guest_full_name],
table_no,
seat_no,
perf_seat,
cust_guest_ind,
mir_lock,
guest_cust_no,
level
FROM tx_event_guest
It’s a little less DIY/punk rock than the Excel solution, but makes it easy to incorporate the guest name into Output Set Builder and custom reports.
Hope that helps,
Alex
Alex Harris | Director of Individual Gifts | 206.443.2210 x1018 | Fax: 206.443.2379 SEATTLE REPERTORY THEATRE | www.seattlerep.org | In Lower Queen Anne at Seattle Center
ON SALE NOW | The 39 Steps Sep 25-Oct 18 | Opus Oct 30-Dec 6
PLAY A PART! Now more than ever, Seattle Rep needs your support. From classics to comedies, swords to antique lamp shades, every dollar counts. Make your tax-deductible gift online today.
Seattle Rep is Closed on Mondays
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dale Aucoin Sent: Thursday, September 24, 2009 9:37 AM To: Alex Harris Subject: Re: [Tessitura Development Forum] event guest list
It was Alex at Seattle Rep who presented on Events and putting an * between first and last name. In excel you can use the "text to columns" function (from the Data dropdown) to separate them into 2 separate columns. Dale
From: Monika Jouvert <bounce-monikajouvert7203@tessituranetwork.com> Sent: 9/24/2009 11:17:55 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!