A basic online roster to be created for club member managment. We want automatic backup, SSL. Gen0 main focus is working portal that only board members be able to use. Interface should be simple enough any board member will be able to update records. Board want to know also who is new, and needs a welcome packet. Struture in expectation for only payments, and self service for club members to renew, update their own information. Board would like to be able to send emails, send renew notices, special alerts. Biggest when a club member renews, joins the club, they should get an email record/receipt immediately. Eliminate any concern payment, information is correct in anyway. Board wants zero friction on submitting information for Astronomical League computer system, reflector magazine, etc.

1. Create a subdomain site on free non-profit dreamhost account [done 2/24/26]
   • DNS records updates in wordpress.com to for it to work, email, hosted web, hosted SQL [done 2/24/26]
2. Ensure SSL works [done 2/24/26]
3. Create MySQL test databases [done 2/24/26]
   • Load raw data from previous secreaty [done 2/24/26]
   • BASIC webpage to pull from MYSQL SELECT * FROM `bas_raw`[done 2/24/26]
4. Protect club information behind individaul logins for board members
   • Use WP authenication layout [done 2/26/2026]
5. Backup site and method to export membership list to non-profit google drive
   • Backup methodm, researched. FREE shared MySQL doesn’t give local cron access, no command line. Will need to upgrade to have automation. We can use free OCI? complexe to manage currently. Using BAS member Jeff Creed servers to pull roster to csv and push to Club Google Drive shared folder “Backup” [5/7/2025]
   • Add plug in to automatically backup to google drive entire WP site [done 2/24/26]
6. Method to email from non-profit google email as membership@boiseastro.org from webpage
   • This is “you paid”, this is what we have on the roster. If something is wrong simply reply to this email with correction and board will correct.  WP Mail SMTP Lite  [ done 3/3/2026 able to send email from WP plug in as membership@boiseastro.org ]. See test email in account sent items. Using API integration [done 3/4/2026 have full email member detail send working]
   • Create renewal recevied email
     [done 4/27/2026 Reusing standard membership email template]
7. Create production SQL database with read and write using separate PHP accounts for access. Account are not super users, read only and write to database only. No drop, alter or admin level. [done, 4/27/2026]
8. Once board is logged in, we need to be able
   • Search, done
   • Add/New, done
   • Delete, done
   • Renew membership, done
   • Edit, done
   • list all, done
     [working, testing 4/27/2026]
9. COMPLEX integration with ALCON database. The requirement is that all memberships expire on 12/31 of the current year BUT if you become a member/renewal between months 9 to 12 you dont expire, and the membership is good till 12/31 of the following year. Does the csv file *need BAS officers listed? Will need to add addtional database fields. [done? 4/27/2026 unable to test till Sept 1st.]
10. Mass import all records from spreadsheet, validate spreadsheet hand by previous secerarty, run in tandeam with spreadsheet
11. WP Plug login complex and difficult. Create email/pin protected page, work on computer and mobile phone with auto-formating [Done 5/13/2026]
12.  ALCON database export in expected schema to export for reflector subscriptions. 24/7, simple click, export, protected, must login to access. [Done 5/13/2026 export as csv file] Review with AlCOR for format of data is good. [Not done yet]

BONUS round – self serivce, supply email and get email membership details [done 5/13/2026]