CTHUB - GER email validation

katerinkus commented 1 month ago

Describe the task Users should get a warning when uploading the GER dataset if a cell in the Email column contains an invalid email. Users should be able to ignore this warning and proceed to the upload.

Purpose Reduces the number of emails that will bounce because of incorrect spelling.

Acceptance Criteria

[ ] Basic issues such as missing @, improper domain names such as gmail.org should be caught.
[ ] User should get a warning at the end regarding these issues with row index and the problematic email.
[ ] Users should be able to ignore this warning.

Additional context Please see GER_notes_for Agile_team, section 5 for my implementation using a python package called email_validator.

ArawuSamuel1 commented 1 month ago

Hey team! Please add your planning poker estimate with Zenhub @emi-hi @tim738745

tim738745 commented 2 weeks ago

Note: the check_deliverability feature of the email_validator doesn't appear to work on dev; firewall/dns issues? Will have to look into this further

tim738745 commented 1 week ago

Updated the email validator to use the 8.8.8.8 dns resolver and not the one found in /etc/resolv.conf in the openshift pod; should work on openshift now hopefully!

bcgov / cthub

CTHUB - GER email validation #324