Verify django db values match google sheets list

[ladissi]

Overview

To complete affiliate topic tag logic: Verify organizations django db in production has organizations that have been identified as contributors.

Action Items

• [ ] verify in django db that affiliate tags in this sheet are present

Resources/Instructions

How to find out who is using the topic tag: civictechindex : https://github.com/topics/civictechindex

[ExperimentsInHonesty]

We don't want to be editing the database manually we want to go and find who is using the topic tag civictechnindex automatically and compare that against who we show is a contributor in the db and put in a queue for approval. Talk to CNK about how this is currently structured.

[fyliu]

From what I remember, we use the query in resources above to find contributing repos, then get the list of orgs they're under. Then we compare that to the contributor orgs in the db, and add any that are not already in the db, creating GitHub issues at the same time as notifications.

I'm not too clear on this next part, but there is a manual approval step. An admin would need to go(click through the link in the issue) into the Django admin interface to mark the new org as approved I think.

Sounds like this issue wants to do something different but not by much. Is this going to be a one time task or should this be made into a script that'll need to be run at future times?

[smsada]

@ExperimentsInHonesty Want to Validate that #818 is solving this issue