Email Address Verification

1
E-mail Address Verification

• Using SQL, TextPad and Web Link Validator

2
First, a little SQL

• The first PL/SQL script does a pattern check for
  common errors, such as hotmial.com, invalid
  domain, etc.
• The second SQLPlus script generates a list of
  e-mail addresses and User IDs, to be used in Web
  Link Validator

3
A bit of massaging in TextPad

• For Web Link Validator to work, the list of
  e-mails must look like a web page TextPad can be
  used to quickly add html tags

Use Fill Block to add html tags
4
A bit of massaging...final result
Add a header using a macro
Html tags were added, and blanks spaces collapsed.
5
Web Link Validator

• Web Link Validator checks the e-mail addresses by
  querying the DNS server and the mail servers.
• This goes beyond simply checking the patterns.

6
Web Link Validator Report
Response from mail server (domain is correct)
Response from DNS server (domain is invalid)
7
Corrections made in Aleph Circ Module

• Common errors (typos) are corrected by staff
• Invalid e-mails are removed from the records, and
  a note is put in asking the user to enter a valid
  e-mail address (note field on tab 1 of Local User
  Information)