Inactive membership...reactivate

I could be wrong, but I think membership status can only be changed by running a query in SSMS. It gets changed via the membership update utility (however often you have that scheduled to run), but other than that I think you have to run a SQL query to change it. It was the only way we could change incorrect initiation dates that came over with our legacy data.

We actually have the issue with the incorrect initiation, dates as well! If you have time, I would love to hear more about how you fixed it if you have that info readily available!

I'll dig back through my emails and find the table we updated for you first thing tomorrow morning.

Thanks so much!

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_MEMBERSHIP
SET 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.

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_MEMBERSHIP
SET 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.