Does anyone know how to reactivate an inactive membership? We have run into this issue trying to use the Membership Extend Expiry utility...but some of our memberships we need to extend are already inactive...
Exactly! You may want to bump second expiration to... AND cm.expr_dt < '2020-08-01 00:00:00' to catch any that don't end at midnight. I think the default end time is like 23:59:59.997
May also want to check on their constituency end dates if you use those.
Also, realizing you need to mark the record as current...so that would be: cm.cur_record='Y' after making it active again.
Ah yes. Probably good to compare one that's untouched and one of these in tx_cust_membership to make sure all the columns look good.
HI Emily, The table I used to make the changes is TX_CUST_MEMBERSHIP. First you have to determine which membership record you are looking for. I ran
SELECT *FROM TX_CUST_MEMBERSHIP WHERE customer_no= the constituent ID of the person you are looking for
Then I looked at the dates for each membership record for that person and found the corresponding cust_memb_no.
The query to change the date was:UPDATE TX_CUST_MEMBERSHIPSET init_dt = 'YYYY-MM-DD'WHERE cust_memb_no = the number you determined above.
Make sure you put the date in single quotes -- that tripped me up at first. And, of course, try it out in TEST first. :-) As I'm sure you know, there's no undo in SSMS so make sure you have changed the date and membership number as you move through them. We only had a couple dozen so I just worked through them one by one and it didn't take too long.
I hope that helps. Let me know if it doesn't make sense or work.