Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update MH CB 7 contact info and sync data in digital ocean and Carto #721

Open
3 tasks
TylerMatteo opened this issue Jul 30, 2024 · 0 comments
Open
3 tasks
Assignees

Comments

@TylerMatteo
Copy link
Contributor

TylerMatteo commented Jul 30, 2024

We received a request to update the contact email info for MH CB 7 [email protected]. This data is meant to be maintained by the code in the db-community-profiles repo but we do update manually now because that repo is not longer used for automations.

The emails for CBs shows up in two places in the CD Profiles app:

  1. In the email link, which gets the email address from the community_district_profiles_v202402 table in Carto

Image

  1. In the CB info CSV available for download

Image

That CSV is tracked in GH here - this file was originally intended to be built with automations but we'll have to just update it manually. That file is then uploaded to digital ocean, which is where the app downloads it from (cd_administrative.csv):

Image

Here are steps to complete that will update the contact info and make sure other recent changes are reflected in both the data coming from Carto and the downloadable CSV, while also keeping the db-community-profiles repo as something approaching a source of truth:

  • Update the output csvto have the correct email addresses for MH CBs 6 and 7 (see this commit for correct CB6 email. CB7 should be updated to [email protected].
  • Once that change is merged in, replace the file in edm-publishiing on DO with the new copy of that output CSV.
  • Confirm the email addresses for MH CB6 and 7 are correct in the email link as well as the downloadable CSV
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants