How to Run Python Scripts

How to Run Python Scripts

1) automation_mentors.py: appends new mentors in samples/mentors.xslx to _data/mentor.yml (or updates all existing mentors if using WRITE mode)

2) download_image.py: downloads image for each mentor from a specified URL and saves in assets/images/mentors. It uses data from samples/mentors.xlsx sheetname Mentors Images.

3) meetup_import.py: imports new upcoming events from the WCC MeetUp page using the iCal feed: https://www.meetup.com/women-coding-community/events/ical/

4) automation_create_mentor_spreadsheets.py: creates spreadhseets for each longterm mentor with filenames like WCC - Long Term - MentorName.xlsx. All the files are saved in a folder named Long Term Mentors. It uses the data from Mentorship Programme long-term Registration Form for Mentees (Responses).xlsx sheetname Revised Menteesas input.

5) automation_prepare_adhoc_availability.py: updates mentors data with specified availability hours in samples/adhoc-prep.xlsx in preparation for monthly ad-hoc mentorship.

Dependencies

python 3.11 or above

How to Execute on Mac

A) automation_mentors.py

sh run_mentor_automation.sh

Notes:
If running locally:

If using GitHub Actions, the GHA workflow is ONLY for adding new mentors. It uses a Google Cloud service account setup to retrieve the Excel file from Google Drive. The service key has been configured for womencodingcommunity Google Drive account and the file to be used/updated has been shared with the service account email (the ID of this file has also been saved to GitHub secrets as NEW_MENTORS_FILE_ID).
Hence, to run the GHA workflow, you only need to provide:

For more information on the GC service account configurations, you can read the documentation in the blog automation folder.

B) download_image.py

Before running the script, make sure to update mentors.xslx sheetname: Mentors Images with the data for the new mentors that you want to download their images If you want to use another file source, adjust XLSX_FILE_PATH parameter in the script to match the file path.

You can then run:

sh run_download_automation.sh

C) meetup_import.py

Before running the script, make sure to download the most recent iCal feed using this link.

Place the downloaded .ics file inside the tools/files folder and make sure it is renamed to meetup.ics.

Afterwards, run the command below:

sh run_meetup_import.sh

Note:

How to Execute on Windows

1) Install python

2) Navigate to the project’s \tools directory:

```
cd tools
```

3) Execute the desired script with the same steps as in How to Execute on Mac.

D) automation_create_mentor_spreadsheets.py

1) Install python 2) Download ad save the Mentorship Programme long-term Registration Form for Mentees (Responses).xlsx data file in the ‘tools/samples’ directory as the script file 3) Ensure sheet_name is set correctly in the script as Revised Mentees 4) Update output_dir to a local folder path/Long Term Mentors 5) The script creates the folder Long Term Mentors that will have .xlsx files for each mentor 6) Execute the script automation_create_mentor_spreadsheets.py 7) Each mentor will have a separate Excel file inside this folder, named: WCC - Long Term - {Mentor Name}.xlsx 8) Each file will contain mentee information specific to that mentor, including their reasons for selecting them

Note:

📁 Long Term Mentors
│── WCC - Long Term - Nonna Shakhova.xlsx
│── WCC - Long Term - Rajani Rao.xlsx
│── WCC - Long Term - Gabriel Oliveira.xlsx └── (more mentor files…)

E) automation_prepare_adhoc_availability.py

sh run_adhoc_prep_automation.sh

Note:

For more information on the GC service account configurations, you can read the README in the blog automation folder.