Dashboard

Dashboard from Project Open Data scans the 24 CFO act agency for compliance with M-13-13. This system needs work to meet the Open Government Data Act.

Environments

Instance	Url
Production	labs.data.gov/dashboard
Staging	dashboard-datagov.dev-ocsit.bsp.gsa.gov
sandbox	dashboard.ci.datagov.us

Common tasks

Database dump

Occasionally we need data for development. These commands are run from one of the dashboard-web hosts.

First, set the database credentials from the application in your shell.

$ source /var/www/dashboard/current/.env

Then, create a compressed archive.

$ mysqldump -h $DB_HOST -u $DB_USER -p $DB_NAME | gzip > $(date +%Y-%m-%d)-staging-dashboard.sql.gz

Supply $DB_PASSWORD when prompted. You can use scp to retrieve the file.

Worker tasks

The Dashboard has two nightly jobs that scan the agency data.json files. Quarterly, the dashboard compiles the results into a milestone.

Alerts

Cron failures

If the jobs (e.g. dashboard-cfo-act-full-scan) repeatedly fail (example), this should be investigated immediately because the dashboard will become more and more out of date.