+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, SIMS Reporting on Email Address contents in Technical; Say I have a couple of thousand email addresses in SIMS, entered by people with varying levels of understanding what ...
  1. #1


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,629
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223

    SIMS Reporting on Email Address contents

    Say I have a couple of thousand email addresses in SIMS, entered by people with varying levels of understanding what an RFC-compliant email address looks like.

    Is there any way (using built-in SIMS tools or read-access to the database) I can search through them all and flag up any that are broken? Writing my own rules as to "broken" is fine - I just want a way of weeding out commas, "binternet", multiple @ etc without manually* reviewing everything.

    (And yes, I have submitted a Feature Request because Capita's idea of "checking email addresses" seems to consist of "does it have an @ and something after the dot?").

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    I don't think there is I'm afraid...

    If I were in your shoes (and I soon will be with parent's online reporting), I'd dump the lot out to Excel and write a VBA function with your checking rules in it

  3. #3

    Join Date
    Jun 2011
    Location
    Hampshire
    Posts
    61
    Thank Post
    2
    Thanked 5 Times in 5 Posts
    Rep Power
    7
    If you are thinking of using a comms package there is a quick way. We use school comms which gives us a bounce report for each outgoing email. When we went live I sent a test email to validate addresses. If you back that up with a text, you can also ask parents to check for email and alert you if not received. Worked well with our new year 7 parents this year.

  4. #4

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,203
    Thank Post
    372
    Thanked 376 Times in 334 Posts
    Rep Power
    147
    Similar checking to the mobile numbers.

    In theory it should be a case of does it have 11 numbers (yes / no)

  5. #5

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    I don't know how effective it would be but using the IF/AND filtering with "contains" should weed out most things.

    EDIT: I've just quickly put a report together. It picks up "@@" will pick up binternet. It won't allow a "," to be put in now.

    This report would obviously rely on you entering the likely error into the filter.
    Last edited by creese; 15th July 2011 at 08:50 AM.

  6. Thanks to creese from:

    pete (15th July 2011)

  7. #6
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    I've just knocked up a quick utility to validate email addresses in a csv file. So if you create a report in Sims containing Admission Number and email address and create a csv file from that it can check the format of the email addresses.

    It uses the regular expression ^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$ to do the checking, so it certainly doesn't handle all formats as defined in RFC 2822, but it's good enough for most purposes.

    More information and download at at Free Utility to Check Email Addresses.

  8. 2 Thanks to rpwillis:

    pete (15th July 2011), vikpaw (16th July 2011)

  9. #7


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,629
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    Quote Originally Posted by rpwillis View Post
    I've just knocked up a quick utility to validate email addresses in a csv file. So if you create a report in Sims containing Admission Number and email address and create a csv file from that it can check the format of the email addresses.

    It uses the regular expression ^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$ to do the checking, so it certainly doesn't handle all formats as defined in RFC 2822, but it's good enough for most purposes.

    More information and download at at Free Utility to Check Email Addresses.
    Er thanks, very much - wasn't expecting that.

    I assume it doesn't actually care what's in the first column in the csv? Just that there's an identifier of some type?

    (Reason I ask - we attach emails to the contact, rather than the kid - it ensures an update to $contact will update siblings as well)

  10. #8


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,629
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    And......it appears CTF files still allow things like "Grandparents 01234 567 890" to get slung in the email fields.

    *mutters darkly about primary schools*

  11. #9
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    Quote Originally Posted by pete View Post
    I assume it doesn't actually care what's in the first column in the csv? Just that there's an identifier of some type?
    Correct, it's just for the message that's it's an invalid email address so you can find it in the input file.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 3
    Last Post: 28th September 2011, 12:57 PM
  2. [SIMS] sims.net on sql server 2008_windows 2003
    By Uraken in forum MIS Systems
    Replies: 12
    Last Post: 24th May 2011, 07:57 AM
  3. Replies: 2
    Last Post: 23rd February 2011, 08:19 PM
  4. [SIMS] Bulk import staff email address
    By matt40k in forum MIS Systems
    Replies: 16
    Last Post: 31st October 2010, 10:59 PM
  5. Sims.net - Reporting on Achievement and Behaviour
    By Iain.Faulkner in forum MIS Systems
    Replies: 22
    Last Post: 21st November 2009, 09:35 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •