• Replies 5 replies
  • Subscribers 415 subscribers
  • Views 100 views
  • Users 0 members are here
Related

event guest list

Monika Jouvert (Past Member)
$organization

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

 

Parents
  • $organization

    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

  • $organization in reply to Dale Aucoin

    We put guest names in as “Last, First” (minus the quotation marks) so that we can alphabetize. Our code then separates the names into two fields using the comma. Same idea.

     

    Lucie

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Thursday, September 24, 2009 12:38 PM
    To: Lucie Spieler
    Subject: Re: [Tessitura Development Forum] event guest list

     

    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

    From: Monika Jouvert <bounce-monikajouvert7203@tessituranetwork.com>
    Sent: 9/24/2009 11:17:55 AM

    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

     




    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!

Reply
  • $organization in reply to Dale Aucoin

    We put guest names in as “Last, First” (minus the quotation marks) so that we can alphabetize. Our code then separates the names into two fields using the comma. Same idea.

     

    Lucie

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Thursday, September 24, 2009 12:38 PM
    To: Lucie Spieler
    Subject: Re: [Tessitura Development Forum] event guest list

     

    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

    From: Monika Jouvert <bounce-monikajouvert7203@tessituranetwork.com>
    Sent: 9/24/2009 11:17:55 AM

    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

     




    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!

Children
No Data