Sexual Misconduct

The Daily Californian's database of sexual misconduct cases in the University of California

data/uc_misconduct.xlsx contains data from the documents released by the UC that have been processed by DC staff

To run:

Make sure to have python2.7x installed.

Clone the repository
pip install -r requirements.txt
python manage.py migrate
python manage.py load
python manage.py runserver
Point your browser to http://localhost:8000/misconduct/

To upload to DocumentCloud

Set the environment variables DOCUMENTCLOUD_USERNAME and DOCUMENTCLOUD_PASSWORD, then run python manage.py upload_documentcloud.

To bake the site into flat files

Run python manage.py build.

To deploy to AWS

Run python manage.py publish --no-delete (--no-delete flag is added to preserve all other files in the same bucket such as projects.dailycal.org, while also updating the misconduct files.)

Notes

Make sure that there is a complaints sheet and stories sheet in the data/uc_misconduct.xlsx spreadsheet.