Hello,
My Development department is adding two new levels to a membership organization. New constituencies have been created and assigned ranks but these memberships are not triggering the addition of the rankings to the customer record like the existing ones.
From what I gather an update to LP_CUSTOMER_RANK might be needed but since this was created as part of our implementation I am not sure what I am looking for to update. Does anyone have experience adding new membership levels and updating this procedure to apply the rankings? Is there something else I am missing setting this up?
Thanks!
Tim
Tim Helmer said:Does anyone have experience adding new membership levels and updating this procedure to apply the rankings?
Lots! And yes, you will have to update the SQL in LP_CUSTOMER_RANK to change the Web Ranking of the customers with those memberships.
Thanks! I think I just got this working. A local table storing the constituency code and ranking value needed to be updated to include the newly created codes/rankings. I am seeing all accounts used for testing being updated now.
Ah, good, that sounds well-designed, then.
Gawain Lavers I'm diving into a LP_CUSTOMER_RANK that needs a bit of refreshing. Do you have one that you are willing to share?
tgbrown@lsc.org
Sure, just sent it over.
Hi Gawain,
Any chance you'd be willing to share this with me as well? I'm having to make some major updates to this and would really appreciate any insights.
jessica.jelinek@houstonsymphony.org
I can share the LP_CUSTOMER_RANK that I have, but it's trivial: it's just five or six calls to custom stored procedures that do a variety of things. Whatever you have that is currently doing updates (rank or otherwise) is certainly custom to your installation. What does your LP_CUSTOMER_RANK update? Ours does update a ranking type rank, but also some custom tables storing additional Contribution information, a variety of Constituencies and an Interest.
Now, I have a very complicated system for ranking calculation that uses a system table to define how different rank types should be calculated, allowing you to use Constituencies, Attributes, Interests and Memberships, and to a choose between an additive numeric calculator and a "binary switch" calculator.