Geek skills galore and Yahoo Groups

This last week or so has seen a major increase in my geek skills.

A week ago yesterday, I wrote my first Python script (to create a macro using the library pyAutoGui). Then I wrote several shell scripts to automate some processing of things for that project.

And then it worked out that arcadianmaggie did not have the time to set up the next stage in dealing with Yahoo Groups data (identifying fandoms and setting up a database to put the info into it)… so I learned how to use postgreSQL and pgAdmin4 and quite a bit more SQL, and I now have all of the spreadsheets I created (the Yahoo Groups Metadata that was uploaded to the IA) into a database I can work with. (I also found a few errors I need to fix in that upload at some point - they're fixed in the db.)

So now I'm currently prepping a spreadsheet of tasks that volunteers can do, using a SQL query to pull the necessary info on all the groups from the database. I have a few tabs to get ready before I can link it publicly…

Yahoo Groups fandom identification is ready to go!

If anyone here isn't already on one of the servers but would like to help, the fandom identification for Yahoo Groups is being organized on Save Yahoo Groups: https://discord.gg/JHten7wMFq
(Though anyone is also welcome to join us at Archivers-R-Us: https://discord.gg/3k9Q7ST )

If you don't do Discord but would still like to help, the (first) spreadsheet is here: https://docs.google.com/spreadsheets/d/1uv4XbJMs_YZA1UcO_RlZo5u1JSuBJf_Lm7k3tAb1NZo/edit?usp=sharing

You can comment on this post with any questions.