Updating Constituencies

Updating Constituencies Subscriber,Previous Year Subscriber and Future Year Subscriber we have custom stored procedures that run every night.

I was wondering is there any system stored procedure that gets invoked to update the constituencies like Donor, Friends,Chairman Circle etc .I referred foot prints to see the LP_customer_rank gets invoked when ever the constituent is added or updated.I donot see any code that related to updating the constituencies based upon the gift amount etc.

Kindly, let me know.

Parents
  • An easy way to do this is to set up a dynamic list and then populate the constituency with the Manage Constituency Report (which can be set up to run nightly with report server).

    Here is a doc on it:  http://www.tessituranetwork.com/~/media/Documentation/Reports/Manage_Constituency.ashx

    Also, Anna Wessely featured this in her highlights webinar for 8.0, which is well worth watching.

    Here is the link to that:  http://www.tessituranetwork.com/network/Learning/Webinars/Webinars%20Archive/Version%20Releases/Tessitura%20v8%20Operational%20Highlights.aspx

     



    [edited by: Jennifer McClure at 10:45 AM (GMT -6) on 18 Sep 2009]
Reply
  • An easy way to do this is to set up a dynamic list and then populate the constituency with the Manage Constituency Report (which can be set up to run nightly with report server).

    Here is a doc on it:  http://www.tessituranetwork.com/~/media/Documentation/Reports/Manage_Constituency.ashx

    Also, Anna Wessely featured this in her highlights webinar for 8.0, which is well worth watching.

    Here is the link to that:  http://www.tessituranetwork.com/network/Learning/Webinars/Webinars%20Archive/Version%20Releases/Tessitura%20v8%20Operational%20Highlights.aspx

     



    [edited by: Jennifer McClure at 10:45 AM (GMT -6) on 18 Sep 2009]
Children
  • Hi Jennifer,

    Thank you for your reply,

    I am sorry, I guess I did not explain properly, the updating of constituencies is working fine but I am unable to figure out how?

    The constituencies I am taking about are based on memberships (Friends, Chairman Circle Members, Hip tix Gold etc...)

     

    Thank you,

    Revanth Kumar Anne.


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jennifer McClure
    Sent: Friday, September 18, 2009 11:47 AM
    To: Revanth Anne
    Subject: Re: [Tessitura Technical Forum] Updating Constituencies

     

    An easy way to do this is to set up a dynamic list and then populate the constituency with the Manage Constituency Report (which can be set up to run nightly with report server).

    Here is a doc on it:  http://www.tessituranetwork.com/~/media/Documentation/Reports/Manage_Constituency.ashx

     

    Also, Anna Wessely featured this in her highlights webinar for 8.0, which is well worth watching.

    From: Revanth Anne <bounce-revanthanne9441@tessituranetwork.com>
    Sent: 9/18/2009 10:05:45 AM

    Updating Constituencies Subscriber,Previous Year Subscriber and Future Year Subscriber we have custom stored procedures that run every night.

    I was wondering is there any system stored procedure that gets invoked to update the constituencies like Donor, Friends,Chairman Circle etc .I referred foot prints to see the LP_customer_rank gets invoked when ever the constituent is added or updated.I donot see any code that related to updating the constituencies based upon the gift amount etc.

    Kindly, let me know.




    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!