Update CROW Rounds - Amsterdam/schoonmonitor GitHub Wiki

  1. Download the project:
git clone https://github.com/Amsterdam/schoonmonitor.git
  1. go to crowdownloader, install requirements and run
cd crowdownloader
pip install requirements.txt
python downloadRounds.py results

  1. copy new files to objectstore dataservice_extern with FileZilla and solve moved columns issue in new rounds.

  2. Go to importer

  3. start a docker postgres db by using:

docker-compose build database
docker-compose up database

Docker way (fastest)

  1. Add password for login to objectstore
export EXTERN_DATASERVICES_PASSWORD=####

6 start importer

docker-compose build importer
docker-compose up database

Or use the non docker way

Create auth.conf file with use of the example file for objectstore login credentials

  1. Run objectstore downloader
python download_from_objectstore.py dev data
  1. Run importer to PG
python load_xls_pg.py dev data

5 Run additional sql (add area codes)

python additional_sql.py dev

  1. Open DBeaver and save crowscorestotaal as CSV with ; and header

  2. Open Tableau dashboard and replace data source with new csv.

  3. Save