Author Topic: Database management  (Read 34922 times)

Hollis Brown

  • Administrator
  • Hero Member
  • *****
  • Posts: 7824
    • View Profile
Database management
« on: September 29, 2022, 11:44:34 AM »
The VAREI president (who tends to manage data) recently noticed that about 50 VAREI members had disappeared from the database.

I know that you and I had discussed having Members X years in arrears converted to Guests. I don't recall whether we ever implemented this. Perhaps this is what just happened to VAREI. Is that possible or is the poltergeist back?

Daniel Abrams

  • Administrator
  • Hero Member
  • *****
  • Posts: 7170
    • View Profile
    • LionsGate Creative :: Create Differently
Re: Database management
« Reply #1 on: September 29, 2022, 12:25:50 PM »
Have to checked the database to see if they are now in the GUESTS database table? Were they in arrears?
LionsGate Creative
lionsgatecreative.com
Creating differently.

Hollis Brown

  • Administrator
  • Hero Member
  • *****
  • Posts: 7824
    • View Profile
Re: Database management
« Reply #2 on: September 29, 2022, 12:38:45 PM »
Database search function doesn't work.

I don't know all the particulars but the president is looking for answers. He has the list as a CSV.

Last time I used the uploader it didn't do what I expected it to do.

Hollis Brown

  • Administrator
  • Hero Member
  • *****
  • Posts: 7824
    • View Profile
Re: Database management
« Reply #3 on: September 29, 2022, 01:01:13 PM »
It appears that Members who hadn't paid since 2019 are now Guests. No one is claiming responsibility for doing this so I assume it was automatic.

We can communicate with them, but how do we renew the ones who want to rejoin? They can rejoin one by one or we can upload the file (that we do have). I don't imagine there is a way to convert them easily back from the Guest to Member.

Daniel Abrams

  • Administrator
  • Hero Member
  • *****
  • Posts: 7170
    • View Profile
    • LionsGate Creative :: Create Differently
Re: Database management
« Reply #4 on: September 29, 2022, 01:23:04 PM »
I don't know if we ever developed a way to converting Guests back to Members.
LionsGate Creative
lionsgatecreative.com
Creating differently.

Hollis Brown

  • Administrator
  • Hero Member
  • *****
  • Posts: 7824
    • View Profile
Re: Database management
« Reply #5 on: September 29, 2022, 01:47:18 PM »
This is backfiring on us. VAREI members often go years at a time without renewing.

We need to rethink this.


Daniel Abrams

  • Administrator
  • Hero Member
  • *****
  • Posts: 7170
    • View Profile
    • LionsGate Creative :: Create Differently
Re: Database management
« Reply #6 on: September 29, 2022, 01:49:20 PM »
This is backfiring on us. VAREI members often go years at a time without renewing.

We need to rethink this.
Frankly, I never liked it. I think we should keep it the way it was where they do not convert to Guests.
LionsGate Creative
lionsgatecreative.com
Creating differently.

Hollis Brown

  • Administrator
  • Hero Member
  • *****
  • Posts: 7824
    • View Profile
Re: Database management
« Reply #7 on: September 29, 2022, 02:07:18 PM »
Then your members list is cluttered with a lot of professionals that you still want to be in touch with. Perhaps it should be a longer time. I frequently get admins questioning this, telling me that they are going to delete members who are in arrears.

All that data then disappear.

Daniel Abrams

  • Administrator
  • Hero Member
  • *****
  • Posts: 7170
    • View Profile
    • LionsGate Creative :: Create Differently
Re: Database management
« Reply #8 on: September 29, 2022, 02:23:58 PM »
This is turning into something huge until we complete what we were doing?
LionsGate Creative
lionsgatecreative.com
Creating differently.

Hollis Brown

  • Administrator
  • Hero Member
  • *****
  • Posts: 7824
    • View Profile
Re: Database management
« Reply #9 on: September 29, 2022, 03:58:23 PM »
We are not changing anything here right now. We are just acknowledging a situation that we will address in the future.

Daniel Abrams

  • Administrator
  • Hero Member
  • *****
  • Posts: 7170
    • View Profile
    • LionsGate Creative :: Create Differently
Re: Database management
« Reply #10 on: September 29, 2022, 04:37:35 PM »
Gotcha
LionsGate Creative
lionsgatecreative.com
Creating differently.