• Replies 7 replies
  • Subscribers 209 subscribers
  • Views 207 views
  • Users 0 members are here
Related

Pulling School List with Multiple Individual Affiliates

Cassie Robel
$organization

Hi All,

For one of our education events, we have school groups sign up - often multiple individuals (teachers) from each school. I have been creating a constituency for the school then listing the individual consituants under relationships --> affiliation. This is where the individual email lives.

What I need is a list that includes the school name, the affiliate(s) (under relationships) and there email. Is this possible?

If not - where could I be listing these individuals and their emails allowing me to pull the list?

Thanks!

Parents
  • Former Member
    Former Member $organization

    In the teacher constituent record, record their school name in the ‘Organisation’ field in the general tab. ‘Salutation Outside Line 2’ in the output set will display that information.

     

    Hope that helps!

     

    Thanks,

    Hannah Schneider

    Coordinator, Schools Programs

    9281 8582

     

    From: Tessitura Education Forum [mailto:forums-education@tessituranetwork.com] On Behalf Of Cassie Robel
    Sent: Friday, 3 March 2017 11:13 AM
    To: Hannah Schneider <Hannah.Schneider@artscentremelbourne.com.au>
    Subject: RE: [Tessitura Education Forum] Pulling School List with Multiple Individual Affiliates

     

    Hi Hannah,

    This worked - but seperates the schools and affiliates so I do not know who is affiliated with the school is there a criteria I could pull to distinguish what school they are with?

    From: Hannah Schneider <bounce-hannahschneider8848@tessituranetwork.com>
    Sent: 3/2/2017 11:59:01 PM

    Hi Cassie,

     

    I think what you are asking could be solved by using the ‘add individuals’ tab at the bottom of the list criteria screen. You can choose to add specific affiliation types (eg. Teacher), so when you run output sets it will pull the school and all teachers affiliated with that school.

     

    Warm regards,

    Hannah

     

    Hannah Schneider

    Coordinator, Schools Programs
    Arts Centre Melbourne

     

    T +61 3 9281 8582

    Email: Hannah.Schneider@artscentremelbourne.com.au

    Website: www.artscentremelbourne.com.au/schools

     

    From: Tessitura Education Forum [mailto:forums-education@tessituranetwork.com] On Behalf Of Cassie Robel
    Sent: Friday, 3 March 2017 10:11 AM
    To: Hannah Schneider <Hannah.Schneider@artscentremelbourne.com.au>
    Subject: [Tessitura Education Forum] Pulling School List with Multiple Individual Affiliates

     

    Hi All,

    For one of our education events, we have school groups sign up - often multiple individuals (teachers) from each school. I have been creating a constituency for the school then listing the individual consituants under relationships --> affiliation. This is where the individual email lives.

    What I need is a list that includes the school name, the affiliate(s) (under relationships) and there email. Is this possible?

    If not - where could I be listing these individuals and their emails allowing me to pull the list?

    Thanks!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Education Forum. You may reply to this message to post to the Education 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!

    Click here to report this email as spam.

     

    This message has been scanned for malware by Websense. www.websense.com




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Education Forum. You may reply to this message to post to the Education 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!

  • Former Member
    Former Member $organization in reply to Former Member

    Hey Hannah...

    That "Organisation" field is a localisation of yours, not standard Tess. Kim sorted it out for us up here, so I presume she's set it up for you guys as well - I think quite a few folks have done it, though.

    It basically takes over the "Salutation 2" field on the General Tab to be used as an Org name.

    For anyone else - If you want to do that (and we think it's useful), you need to do two things:

    1. For all relevant salutation formats in TR_SALUTATION_FORMAT, set the values of the  Single Name L2 and Double Name L2 columns  to "!" (That's a special code that means "Don't overwrite", so that the Gen Sal process won't try to generate a value automatically, but will leave your organisation name value alone.)
    2. Change the label on the General Tab to say "Organisation" (or whatever), instead of "Salutation 2"). (Did you know you can do that? See Bob Bell's explanation here)

    There's some discussion about that on a previous forum thread, too.

     

    Ken

     

Reply
  • Former Member
    Former Member $organization in reply to Former Member

    Hey Hannah...

    That "Organisation" field is a localisation of yours, not standard Tess. Kim sorted it out for us up here, so I presume she's set it up for you guys as well - I think quite a few folks have done it, though.

    It basically takes over the "Salutation 2" field on the General Tab to be used as an Org name.

    For anyone else - If you want to do that (and we think it's useful), you need to do two things:

    1. For all relevant salutation formats in TR_SALUTATION_FORMAT, set the values of the  Single Name L2 and Double Name L2 columns  to "!" (That's a special code that means "Don't overwrite", so that the Gen Sal process won't try to generate a value automatically, but will leave your organisation name value alone.)
    2. Change the label on the General Tab to say "Organisation" (or whatever), instead of "Salutation 2"). (Did you know you can do that? See Bob Bell's explanation here)

    There's some discussion about that on a previous forum thread, too.

     

    Ken

     

Children
No Data