civictechindex / CTI-website-frontend

Join a worldwide movement to catalog 
every open source 
civic tech project.
https://civictechindex.org
MIT License
30 stars 30 forks source link

Verify django db values match google sheets list #1016

Open ladissi opened 3 years ago

ladissi commented 3 years ago

Overview

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

Action Items

Resources/Instructions

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

ExperimentsInHonesty commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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