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

I haven’t tried this yet but I saved Lucie’s tip here that should help:

 

Go to the TR_QUERY_ELEMENT system table. Add a row:

Description = Customer_sort_name

Category = Constituent

Data Select = sort_name

Data From = Customer

Data Where = [blank]

Control Group = (Default Control Group)

Single Row = [checked box]

Primary Group Default = [unchecked box]

 

This gives you the element that sorts by last name the way it appears in the header.

 

Go to Tools and select Output Set Builder. Choose New Set from the buttons at the bottom of the screen.

 

Here’s what I’ve added to my query, in the order I have them:

From the Constituent folder:

                Salutation_outside_line1

                Salutation_outside_line2

                Salutation_business_title

From the Address Information folder:

                Address_street3

                Address_street2

                Address_street1

                Address_city

                Address_state

                Address_postal_code

                Address_country_desc

From the Constitutent folder:

                Salutation_inside

                Salutation_sal_type

                Customer_sort_name

 

I used to have Customer_lname and Customer_fname, but I don’t think that’s useful anymore. I’ve named my query the eloquent “Mailing-Inside Sal-Sort Name.”

 

The nice thing about queries is that you can put in what you want, in the order you want them, and they pull that way when you run reports or extractions using them. You get to pick mailing date, mailing purpose, and salutation, just as in User Defined Output from a List. You just can’t have your results auto-sort in various ways.

 

The only gotcha about using sort name is that deceased people don’t have one—although, for me, that’s actually a plus. If I am running a mailing list, this gives me a quick and easy way to catch patrons who should not be there, because they will be at the top of my list, out of alpha order, when I sort.

 

Lucie

 

 

 

_____________________________
Lucie Spieler
IT Development and Training Manager

Editor, Season Program Book

FLORIDA GRAND opera

 

 

 

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

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!

I haven’t tried this yet but I saved Lucie’s tip here that should help:

 

Go to the TR_QUERY_ELEMENT system table. Add a row:

Description = Customer_sort_name

Category = Constituent

Data Select = sort_name

Data From = Customer

Data Where = [blank]

Control Group = (Default Control Group)

Single Row = [checked box]

Primary Group Default = [unchecked box]

 

This gives you the element that sorts by last name the way it appears in the header.

 

Go to Tools and select Output Set Builder. Choose New Set from the buttons at the bottom of the screen.

 

Here’s what I’ve added to my query, in the order I have them:

From the Constituent folder:

                Salutation_outside_line1

                Salutation_outside_line2

                Salutation_business_title

From the Address Information folder:

                Address_street3

                Address_street2

                Address_street1

                Address_city

                Address_state

                Address_postal_code

                Address_country_desc

From the Constitutent folder:

                Salutation_inside

                Salutation_sal_type

                Customer_sort_name

 

I used to have Customer_lname and Customer_fname, but I don’t think that’s useful anymore. I’ve named my query the eloquent “Mailing-Inside Sal-Sort Name.”

 

The nice thing about queries is that you can put in what you want, in the order you want them, and they pull that way when you run reports or extractions using them. You get to pick mailing date, mailing purpose, and salutation, just as in User Defined Output from a List. You just can’t have your results auto-sort in various ways.

 

The only gotcha about using sort name is that deceased people don’t have one—although, for me, that’s actually a plus. If I am running a mailing list, this gives me a quick and easy way to catch patrons who should not be there, because they will be at the top of my list, out of alpha order, when I sort.

 

Lucie

 

 

 

_____________________________
Lucie Spieler
IT Development and Training Manager

Editor, Season Program Book

FLORIDA GRAND opera

 

 

 

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

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!