• Replies 6 replies
  • Subscribers 413 subscribers
  • Views 205 views
  • Users 0 members are here
Related

Output element-first and last name of A1/A2 of a household

Former Member
Former Member $organization

Does anyone know what output element is needed to get the First Name and Last Name of the A1 and A2 of a Household using an output set? We're having a difficult time isolating and outputting the first and last names of a household. We've tried using advanced list options and replacing the household with the individual accounts, but that's not working because it outputs as two different accounts on two different lines in excel. Too much manual work in excel trying to figure out who's in a household together at that point.

Thanks for any help; it's greatly appreciated.

-Angie Weeks

Tennessee Performing Arts Center

Parents
  • $organization
    Thanks Lucie. I thought I saw a problem with running extractions when using one over the other so I changed it to !.sort_name. If it's okay I'll leave it. 

    Since I have your attention. I was wondering if you knew about pulling an output set for confirmation letters. I have been working now for over a week on having Lynch2 design an output set that I can pull into a merge document for my subscription confirmations. The info I need is performance name, venue, day, date, time and seats.  
    The output set I have right now pulls thirty one lines at random for people that cross over sections/zones in our houses. It makes for a lot of cutting and pasting for about two hundred people and the letters go out Tuesday. What do you guys use? Any advice or suggestions. 

    Thanks.

    On Fri, Jul 24, 2015 at 1:41 PM, Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com> wrote:

    Hi, Adria:

     

    Both ways work. The first (using Customer rather than T_CUSTOMER) is more Tessitura-idiomatic, so that’s the one I’d use.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    Florida Grand Opera



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/8452/43343.aspx#43343 or reply to this message

    Adria Gunter | Subscriptions Manager

    STUDIO THEATRE

    1501 14TH ST NW

    WASHINGTON DC  20005

    T  202-232-7267, ext. (365)

    F  202-588-5262

    www.studiotheatre.org

    Subscriptions are online!

    2014-2015 SEASON    BELLEVILLE |BAD JEWS |CHOIR BOY |  LAUGH  | JUMPERS FOR GOALPOSTS

    2014-2015 SEASON    STUDIO 2ND STAGE  TERMINUS | MARY-KATE OLSEN IS IN LOVE   | SILENCE! THE MUSICAL

    2014-2015 SEASON    SPECIAL EVENTS  AND LAB   THE WOLFE TWINS | MURDER BALLAD

Reply
  • $organization
    Thanks Lucie. I thought I saw a problem with running extractions when using one over the other so I changed it to !.sort_name. If it's okay I'll leave it. 

    Since I have your attention. I was wondering if you knew about pulling an output set for confirmation letters. I have been working now for over a week on having Lynch2 design an output set that I can pull into a merge document for my subscription confirmations. The info I need is performance name, venue, day, date, time and seats.  
    The output set I have right now pulls thirty one lines at random for people that cross over sections/zones in our houses. It makes for a lot of cutting and pasting for about two hundred people and the letters go out Tuesday. What do you guys use? Any advice or suggestions. 

    Thanks.

    On Fri, Jul 24, 2015 at 1:41 PM, Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com> wrote:

    Hi, Adria:

     

    Both ways work. The first (using Customer rather than T_CUSTOMER) is more Tessitura-idiomatic, so that’s the one I’d use.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    Florida Grand Opera



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/8452/43343.aspx#43343 or reply to this message

    Adria Gunter | Subscriptions Manager

    STUDIO THEATRE

    1501 14TH ST NW

    WASHINGTON DC  20005

    T  202-232-7267, ext. (365)

    F  202-588-5262

    www.studiotheatre.org

    Subscriptions are online!

    2014-2015 SEASON    BELLEVILLE |BAD JEWS |CHOIR BOY |  LAUGH  | JUMPERS FOR GOALPOSTS

    2014-2015 SEASON    STUDIO 2ND STAGE  TERMINUS | MARY-KATE OLSEN IS IN LOVE   | SILENCE! THE MUSICAL

    2014-2015 SEASON    SPECIAL EVENTS  AND LAB   THE WOLFE TWINS | MURDER BALLAD

Children
No Data