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
  • Thanks, that makes perfect sense.  Will not be able to update all records right now, but great to think about in the future.  Found another way to use the date fields and need to update only those records that have multiple addresses.

    Thanks again,
    Karen

    From: "T.C. Brown" <bounce-tcbrown4438@tessituranetwork.com>
    Reply-To: Tessitura Development Forum <forums-development@tessituranetwork.com>
    Date: Tuesday, February 4, 2014 2:03 PM
    To: Karen Taggart <ktaggart@lobero.com>
    Subject: RE: [Tessitura Development Forum] Retrieving alternate addresses

    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!




    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
  • Thanks, that makes perfect sense.  Will not be able to update all records right now, but great to think about in the future.  Found another way to use the date fields and need to update only those records that have multiple addresses.

    Thanks again,
    Karen

    From: "T.C. Brown" <bounce-tcbrown4438@tessituranetwork.com>
    Reply-To: Tessitura Development Forum <forums-development@tessituranetwork.com>
    Date: Tuesday, February 4, 2014 2:03 PM
    To: Karen Taggart <ktaggart@lobero.com>
    Subject: RE: [Tessitura Development Forum] Retrieving alternate addresses

    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!




    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