03 January, 2017 · less than a minute to read
Free Utility to Check Email Addresses
Inspired by a discussion on Edugeek I've quickly knocked up a quick utility to check the format of email addresses in a csv file. You can download it from here.
This utility will iterate through an input file and check the validity of email addresses. Each line of the input file must be of the format identifier,email address. The identifier is used in the output message, and the email is of course checked.
Example input file
002345,info@salamandersoft.co.uk 002346,me@domain.com 002347,do not email
The utility will pick up the 3rd line as an invalid email address and output
POSSIBLY INVALID:002347:do not email
Internally it uses a regular expression to check the email. This is not perfect and will give false positives when compared to RFC 2822, but it is good enough for most purposes.
The regular expression used is: ^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$
To use:
So to use to check your email addresses in Sims, first create a report which contains their Admission Number and email which saves to csv. The run the report and the use the resulting file as input to CheckEmails.
You can run CheckEmails.exe /? for a brief help summary.
Founder / Chairman
Richard started SalamanderSoft in 2007 after a successful career as a software developer. Wanting to start his own company and with experience in integrating school systems he set out to build the best integration system for schools and to exceed customer expectations. He starting out on his own, doing all the coding, support and sales until finally the growing number of customers meant he needed to start growing the team. He is still heavily involved in coding the core Integration Suite product.