• Replies 2 replies
  • Subscribers 412 subscribers
  • Views 108 views
  • Users 0 members are here
Related

pulling constituents with expired constituency

Ruthie Hubka
$organization

Hello, I've encountered a problem with a donor constituency that has been entered with incorrect expiration dates. These donors show with the proper constituency code on their account, but when I try to use this constituency as the criteria for a list or extraction, they do not come up due to the expiration date. For some reason, they were added 8/18/10 to the constituency, and the expiration date was put in as 8/24/10. I proved that this was the case by pulling a list and doing a simple output set of name and address and found that the few I had identified with the expiration were not included, though I have no way of knowing who the other may be out of our thousands of  constituents. I desperately need a way to pull a list of these constituents with the expired constituency so that I can use the Manage Constituency report to correct them.

Greatly appreciated.

Parents
  • Former Member
    Former Member $organization
    Hi, this happened to me recently and I created a T_KEYWORD from tx_const_cust instead of vxs_const_cust.  This allowed me to see who had the expired constituency code and fix them.  That may not have been the best (or easiest) way to do it but it worked.  

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ruthie Hubka
    Sent: Monday, May 23, 2011 5:45 PM
    To: Jeri Henderson
    Subject: [Tessitura Development Forum] pulling constituents with expired constituency

    Hello, I've encountered a problem with a donor constituency that has been entered with incorrect expiration dates. These donors show with the proper constituency code on their account, but when I try to use this constituency as the criteria for a list or extraction, they do not come up due to the expiration date. For some reason, they were added 8/18/10 to the constituency, and the expiration date was put in as 8/24/10. I proved that this was the case by pulling a list and doing a simple output set of name and address and found that the few I had identified with the expiration were not included, though I have no way of knowing who the other may be out of our thousands of  constituents. I desperately need a way to pull a list of these constituents with the expired constituency so that I can use the Manage Constituency report to correct them.

    Greatly appreciated.




    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
  • Former Member
    Former Member $organization
    Hi, this happened to me recently and I created a T_KEYWORD from tx_const_cust instead of vxs_const_cust.  This allowed me to see who had the expired constituency code and fix them.  That may not have been the best (or easiest) way to do it but it worked.  

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ruthie Hubka
    Sent: Monday, May 23, 2011 5:45 PM
    To: Jeri Henderson
    Subject: [Tessitura Development Forum] pulling constituents with expired constituency

    Hello, I've encountered a problem with a donor constituency that has been entered with incorrect expiration dates. These donors show with the proper constituency code on their account, but when I try to use this constituency as the criteria for a list or extraction, they do not come up due to the expiration date. For some reason, they were added 8/18/10 to the constituency, and the expiration date was put in as 8/24/10. I proved that this was the case by pulling a list and doing a simple output set of name and address and found that the few I had identified with the expiration were not included, though I have no way of knowing who the other may be out of our thousands of  constituents. I desperately need a way to pull a list of these constituents with the expired constituency so that I can use the Manage Constituency report to correct them.

    Greatly appreciated.




    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