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.
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
Hi Revanth!
If you are using memberships, check your membership setup.
For each level, you can associate a constituency (which could be “Donor” for each level or different items for each level). If these values are populated, the constituency should be automatically created/updated with a gift that merits a membership.
Also, once the membership goes inactive (by running the Membership Update utility), the constituency should drop away.
Thanks!
Nick
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
From: Revanth Anne <bounce-revanthanne9441@tessituranetwork.com> Sent: 9/18/2009 10:05:45 AM
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!
Constituencies can also get added automatically with a gift to a specific fund. This is set up in CAMPAIGNS - REFERENCES - FUNDdale