ctsit / rcc.billing

Automated, data-driven service billing implemented on REDCap Custodian
https://ctsit.github.io/rcc.billing/
Apache License 2.0
0 stars 3 forks source link

`cleanup_bad_email_addresses.R` fails because data.vivo.ufl.edu no longer exists #243

Closed pbchase closed 3 weeks ago

pbchase commented 1 month ago

cleanup_bad_email_addresses.R fails because data.vivo.ufl.edu no longer exists. The error is

Error: Failed to connect: Unknown MySQL server host 'data.vivo.ufl.edu' (-2) Execution halted

The code is failing at https://github.com/ctsit/rcc.billing/blob/9f201b1b546c1b4dea45f1e461e670090a80182d/etl/cleanup_bad_email_addresses.R#L70

Remove that code block and replace it with an empty data frame:

person <- dplyr::tribble(
  ~user_id, ~email,
  "foo", "bar"
) |> dplyr::filter(F)

That should cause all bad email addresses to be erased. That is better than leaving bad email addresses in place on a user record.

saipavan10-git commented 3 weeks ago

Addressed by #245