• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 33 views
  • Users 0 members are here
Related

Subscription history not moving from individual to household

Former Member
Former Member $organization

At Bass Hall, we are *still* dealing with various problems related to legacy data from the previous ticketing system.
Of my many weekly data checks, I added a process to check for individual transactions where the individual is part of a household, then moving those transactions from the individual record to the household.

I discovered the process Constituents=>Household Operations=>Move Transactions to Household works as expected on most data, but it does not on some subscription records for some individuals.

Individual #123 is part of household #456.  From the legacy data the individual as subscription history.  I probably created the household after our migration and added individual #123 as a member to household #456.
Nothing occurs when I attempt to move the Subscription history from the individual to the household.  There are no errors but the data remains on the individual record.

Any thoughts?

Best Regards
Wendell Baskin
Bass Hall - Fort Worth
wbaskin@basshall.com



  • Former Member
    Former Member $organization

    Wendell,

    Looking through the Move transactions procedure, I'd start by checking in TR_CUSTOM_TAB.  Make sure that the "Update Table" column is correct for your subscription history table and make sure that the "Object ID" column = 78.

    If those are all correct and you are still seeing issues, I'd recommend opening a TASK ticket.

     

  • Former Member
    Former Member $organization

    Thanks, Levi ..

     

    We have yet to use custom tabs, but I’ll look ..

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Friday, January 17, 2014 15:38
    To: Wendell Baskin
    Subject: Re: [Tessitura Technical Forum] Subscription history not moving from individual to household

     

    Wendell,

    Looking through the Move transactions procedure, I'd start by checking in TR_CUSTOM_TAB.  Make sure that the "Update Table" column is correct for your subscription history table and make sure that the "Object ID" column = 78.

    If those are all correct and you are still seeing issues, I'd recommend opening a TASK ticket.

     

    From: Wendell Baskin <bounce-wendellbaskin7249@tessituranetwork.com>
    Sent: 1/17/2014 1:45:32 PM

    At Bass Hall, we are *still* dealing with various problems related to legacy data from the previous ticketing system.
    Of my many weekly data checks, I added a process to check for individual transactions where the individual is part of a household, then moving those transactions from the individual record to the household.

    I discovered the process Constituents=>Household Operations=>Move Transactions to Household works as expected on most data, but it does not on some subscription records for some individuals.

    Individual #123 is part of household #456.  From the legacy data the individual as subscription history.  I probably created the household after our migration and added individual #123 as a member to household #456.
    Nothing occurs when I attempt to move the Subscription history from the individual to the household.  There are no errors but the data remains on the individual record.

    Any thoughts?

    Best Regards
    Wendell Baskin
    Bass Hall - Fort Worth
    wbaskin@basshall.com

     




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