Manual Reporting

To manually run the monthly report:

1- Update the template: https://github.com/opencollective/opencollective-api/blob/main/templates/emails/collective.monthlyreport.hbs

2- If you want to preview some of the emails, you can run it locally with

PG_DATABASE=opencollective_prod_snapshot DEBUG=preview npm run cron:monthly

(it won't send real emails but it will output links to preview them in the browser)

3- Run bash on heroku production:

heroku run bash --app opencollective-prod-api

4- Run the monthly cron job manually:

npm run cron:monthly

If you want to only run it for certain collectives, modify the query here: https://github.com/opencollective/opencollective-api/blob/main/cron/monthly/collective-report.js