Retrieving alternate addresses

I have searched the forums to see if there is any help on this issue.  Currently we are in a consortium and some records have multiple addresses, one of which is primary.  I have not been able to find any report or output set to select a specific type of address.  Any help would be greatly appreciated.

 

Karen Taggart

Lobero Theatre Foundation

Parents
  • Hi Karen,

     

    Addresses pull according to the mail purpose assigned to them, not by type.   One thing to note is a mail purpose works best when used for one address type.  For instance, we have a development address type and check a mail purpose of Patron when pulling devo addresses, a board address type which has the mail purpose of Board, etc.  I’m sure there are other ways to set it up, but this is how we are currently using in the Pittsburgh consortium.   So if you’re not using a mail purposes you should look into adding those to your address types.

     

    Hope that helps.

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Karen Taggart
    Sent: Monday, February 03, 2014 7:00 PM
    To: TC Brown
    Subject: [Tessitura Development Forum] Retrieving alternate addresses

     

    I have searched the forums to see if there is any help on this issue.  Currently we are in a consortium and some records have multiple addresses, one of which is primary.  I have not been able to find any report or output set to select a specific type of address.  Any help would be greatly appreciated.

     

    Karen Taggart

    Lobero Theatre Foundation




    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
  • Hi Karen,

     

    Addresses pull according to the mail purpose assigned to them, not by type.   One thing to note is a mail purpose works best when used for one address type.  For instance, we have a development address type and check a mail purpose of Patron when pulling devo addresses, a board address type which has the mail purpose of Board, etc.  I’m sure there are other ways to set it up, but this is how we are currently using in the Pittsburgh consortium.   So if you’re not using a mail purposes you should look into adding those to your address types.

     

    Hope that helps.

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Karen Taggart
    Sent: Monday, February 03, 2014 7:00 PM
    To: TC Brown
    Subject: [Tessitura Development Forum] Retrieving alternate addresses

     

    I have searched the forums to see if there is any help on this issue.  Currently we are in a consortium and some records have multiple addresses, one of which is primary.  I have not been able to find any report or output set to select a specific type of address.  Any help would be greatly appreciated.

     

    Karen Taggart

    Lobero Theatre Foundation




    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