This repository will house various scripts that can be used from year-to-year.

Clone the repo

$ git clone https://github.com/pyconca/scripts.git

Create a virtualenv

$ mkvirtualenv -p `which python2.7` scripts && cd scripts

Install PIP requirements

(scripts) $ pip install -r requirements.txt

If running a script that uses the Google Sheets video production spreadsheet or the YouTube API, create credentials using these instructions and put the credentials in scripts/client_secret.json

The Slide Generation script pulls JSONs from the web API that have schedule and talk data, and creates PNG slides. The slides are used as intros to the YouTube videos of PyCon talks.

Install webkit2png

$ brew install webkit2png

Change directories to the root directory of this repo, and run:

(scripts) $ PYTHONPATH=. python create_slides/create_slides.py

The slides will be in create_slides/output.

For more options run

(scripts) $ PYTHONPATH=. python create_slides/create_slides.py --help

The Spreadsheet Creation script populates a Google Sheets spreadsheet with information about all of the PyCon Canada talks. The spreadsheet can be provided to the company that does video production, and they can use it to track which videos have been uploaded to YouTube.

Follow the instructions at https://developers.google.com/sheets/quickstart/python, and then put the client secret file in client_secret_sheets.json.

You must first create a spreadsheet in the shared PyCon Canada Google Drive, then copy the spreadsheet's ID from the URL.

You can get

(scripts) $ PYTHONPATH=. python populate_sheet/populate_sheet.py [SPREADSHEET_ID]

This script finds newly uploaded YouTube videos based on the Google Sheets spreadsheet, and then sets certain metadata (like title, category, and description). It also sets the video to 'Delisted' status, which means it will be available to anyone who has a link.

(scripts) $ PYTHONPATH=. python publish_videos/publish_videos.py [SPREADSHEET_ID]