+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, pupil emails in Technical; having recently started giving pupils email accounts, is there some way to bulk import their emails into sims?...
  1. #1
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,524
    Thank Post
    106
    Thanked 88 Times in 74 Posts
    Blog Entries
    46
    Rep Power
    40

    pupil emails

    having recently started giving pupils email accounts, is there some way to bulk import their emails into sims?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    this came up in a thread on SupportNet too i believe, as far as we know, no. i think someone checked and it wouldn't work from a CTF or other method either.
    we set our usernames and emails to be the SIMS admission number, so it's already in there, and can be reported on. simples.

  3. #3
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,524
    Thank Post
    106
    Thanked 88 Times in 74 Posts
    Blog Entries
    46
    Rep Power
    40
    Quote Originally Posted by vikpaw View Post
    this came up in a thread on SupportNet too i believe, as far as we know, no. i think someone checked and it wouldn't work from a CTF or other method either.
    we set our usernames and emails to be the SIMS admission number, so it's already in there, and can be reported on. simples.
    hmmm. ours are generated from active directory usernames ie username@domain, which are unrelated to anything in sims and not wholly consistent thru the years . I wonder if there's a way to do it with AutoIt v3 - Automate and Script Windows Tasks - For Free!

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,391
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    The problem would be marrying them up. What's the chances you have the UPN or admission number in your AD? Also not sure why you would want the school email address within SIMS?

  5. #5
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,524
    Thank Post
    106
    Thanked 88 Times in 74 Posts
    Blog Entries
    46
    Rep Power
    40
    Quote Originally Posted by matt40k View Post
    The problem would be marrying them up. What's the chances you have the UPN or admission number in your AD? Also not sure why you would want the school email address within SIMS?
    No chance.

    Emails in sims would create possibilities for teachers to email the students reminders or other stuff, and I believe groupcall can utilize emails too.

  6. #6

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by browolf View Post
    hmmm. ours are generated from active directory usernames ie username@domain, which are unrelated to anything in sims and not wholly consistent thru the years . I wonder if there's a way to do it with AutoIt v3 - Automate and Script Windows Tasks - For Free!
    I did this in stages using autoit, extract list of students from SIMS, extract list of emails address from network in the same order.

    Get autoit to enter address and keep hitting next on the student entry page.

    It wasn't completely reliable and SIMS does go bang when you enter too much data, i.e. after about 70 students the client crashes (same thing happened when entering by hand).

  7. #7

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by matt40k View Post
    The problem would be marrying them up. What's the chances you have the UPN or admission number in your AD? Also not sure why you would want the school email address within SIMS?
    Because SIMS is the centre of all things !

    (We store admission number in AD "ExtensionAttribute1"/"Custom Attribute1" and as a double link, network logon name in SIMS udf.)

    Hmmm, well... we did this so that staff can email groups of students using SIMS reporting, it's messy because they have to type/paste the group name but can be made to work.

    e.g. choose
    7Ma1, Your homework is...
    Year8Choir, Remember be here on Friday at 3:30 for practise

    etc.

    Bit of a crossover with what you might do with a VLE.

    (VBA in Excel report output creates pre-addressed email in Outlook.)

    This can be expanded; email the teachers of "John Smith", parents of, supervisors of group etc., oh and with appropriate SMS service, text students in group, parent/carers, supervisors etc..

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,391
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Sorry if I'm missing what's going on here, but don't you want to run a SIMS report to export the students\staff and basic details (admission no etc) then also run another to add them into groups - such as lessons\reg\subjects? Then the staff and use the distribution groups

  9. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I'm thinking that when we get our sharepoint set up working, teachers, students and parents will all be represented and have data directly taken from SIMS, grouped into AD and sharepoint groups.

    Sharepoint will provide a means to email groups, and so we wont need it in SIMS.

    We're almost thinking that this system will make things like Schoolcomms (our system for email/texting parents about absence or other notices) redundant and only used for texting. The nice feature it retains is that when an email/text is replied to by a parent it can update attendance.

  10. #10

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by matt40k View Post
    Sorry if I'm missing what's going on here, but don't you want to run a SIMS report to export the students\staff and basic details (admission no etc) then also run another to add them into groups - such as lessons\reg\subjects? Then the staff and use the distribution groups
    Yes, have pondered doing that but we have over 1000 teaching classes, never mind other groups, so a lot of stuff to add to AD and never quite up to date.

    Also, I'm just tweaking a version which a member of staff can use to email a chosen group some assessment results, e.g. for "here's your predicted grade" etc.

    We do have some student voice groups which are supposedly synced (but I haven't finished it yet) from SIMS to network as students (not just staff) need to bulk email the groups.

    One thing that annoys me though is the really awkward mechanism for choosing options at run time in SIMS reporting. Either long scrolly, unresposive checkbox lists or text entry for names of things.

    tim

  11. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,391
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    SamanderSoft does a nice SIMS > AD solution, adds users and users to groups. Just a question of how often do you want it to check for changes.

    It's easy enough to make something, so long as you think about it first. Really should a EduGeek SIMS to AD.

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by matt40k View Post
    SamanderSoft does a nice SIMS > AD solution, adds users and users to groups. Just a question of how often do you want it to check for changes.

    It's easy enough to make something, so long as you think about it first. Really should a EduGeek SIMS to AD.
    SalamanderSoft* - Richard (MD) is on the forums, it does more than SIMS ADP and i spoke to him at BETT and he is also amenable to site specific bespoke requests for any extra functions you might want adding. (no doubt for a fee )

SHARE:
+ Post New Thread

Similar Threads

  1. Undeliverable emails
    By onder in forum Windows
    Replies: 2
    Last Post: 16th December 2008, 12:24 PM
  2. Staff emails and VLE emails
    By e_g_r in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 12th November 2008, 06:26 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
  •