Provide an interim solution for compiling the eligible voters list

[ncoghlan]

Currently voting eligibility information needs to be compiled from 3 sources:

• the Basic Members list in python.org (for PSF Membership checks)
• the interim Google Form set up for self-nominating as a Managing or Contributing member
• the Associate (now Supporting) Member program at https://psfmember.org/

While the long term solution is to consolidate tracking of Managing, Contributing & Supporting Member status (together with tracking of Sponsor Member delegates) into the main python.org site, it may be beneficial to have an interim solution that at least partially automates this process to reduce the time needed for Ewa to collate the voter list as PSF Secretary.

[ncoghlan]

(Ideally, such a utility would also be able to check if PSF Members were correctly registered on the PSF Members wiki, as it's conceivable ballot related materials may not always be made available to the general public)

[selenamarie]

Is there an API to this data, or are they separate SQL databases? Or?

[ncoghlan]

For the Basic member data, it's in the main python.org PostgreSQL database, and I don't know whether it has an API or not. The Managing/Contributor data is currently in Google Forms, which I assume can be remotely accessed, but don't know how.
Finally, I think the Associate Member page backs on to CiviCRM, but don't actually know for sure.

So yeah, quite a bit of ignorance happening over here :)

I've asked Ewa if she could provide a more detailed description of the current manual collation process.