+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, SIMS Automatic Alerts in Technical; Hi, We're about to move to SIMS starting over this half term. I'm currently looking at ways of improving our ...
  1. #1

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,573
    Thank Post
    833
    Thanked 872 Times in 725 Posts
    Blog Entries
    9
    Rep Power
    324

    SIMS Automatic Alerts

    Hi,

    We're about to move to SIMS starting over this half term. I'm currently looking at ways of improving our and perhaps automating how we create and manage AD useraccounts.

    Does anyone know if their is a way for SIMS to automatically flag up to me when our admin staff add new staff or students to the database?

    Or will I be able to generate a report of new users since the last time that report was run - and can SIMS automatically run reports, perhaps daily?

    Thanks

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,193
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    There is no flag for details entered.

    You can run reports regularly. It takes a bit of setting up but the notes are good.

  3. Thanks to creese from:

    tmcd35 (23rd April 2010)

  4. #3

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,573
    Thank Post
    833
    Thanked 872 Times in 725 Posts
    Blog Entries
    9
    Rep Power
    324
    So I could set up a report to run automatically that generates a csv file of new pupils/staff added since the last time the report ran? If I can do this and know where the generated csv file would be stored I think I'd be more than halfway towards getting what I need.

  5. #4

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,193
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    Quote Originally Posted by tmcd35 View Post
    So I could set up a report to run automatically that generates a csv file of new pupils/staff added since the last time the report ran? If I can do this and know where the generated csv file would be stored I think I'd be more than halfway towards getting what I need.
    Not that I can think of off the top of my head. You could run a simple report of 'admission dates after' and run that each day but they wouldn't be a scheduled report as the date would change.

    The current Sims Reporting tool leaves a lot to be desired I'm afraid.

  6. Thanks to creese from:

    tmcd35 (23rd April 2010)

  7. #5
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Don't think you can automate reports, but you can manually run a report of new users this month, or new in a given date range.

  8. #6

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,193
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    Quote Originally Posted by enjay View Post
    Don't think you can automate reports, but you can manually run a report of new users this month, or new in a given date range.
    You can automate reports.

    Have you got access to Supportnet? Resource 12485 & 11982

  9. Thanks to creese from:

    enjay (23rd April 2010)

  10. #7
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Well, every day's a school day! Not sure I'd actually want to do this, but it could be useful.

  11. #8

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,193
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    Quote Originally Posted by enjay View Post
    Well, every day's a school day! Not sure I'd actually want to do this, but it could be useful.
    To be honest I set it up on a test database and for one Deputy in a school. No so good out of 160ish schools.

  12. #9

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,573
    Thank Post
    833
    Thanked 872 Times in 725 Posts
    Blog Entries
    9
    Rep Power
    324
    Thanks guys, I think I'm going to e-mail Capita and see if they can set up a vbs script to do what I need.

  13. #10

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,193
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    Out of curiosity, why do you want to do this?

  14. #11

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,573
    Thank Post
    833
    Thanked 872 Times in 725 Posts
    Blog Entries
    9
    Rep Power
    324
    I want to autmate the process of creating AD user accounts.

    At the moment,
    1 - Secratery adds record to Phoenix (moving to SIMS)
    2 - I find out about the new student/staff a few days down the line
    3 - I export list of new users added and ftp it to county
    4 - county return a list of userid's (part of their e-mail address system)
    5 - I want to use the county userid as the AD user account, probably importing using Wisofts BulkADUsers
    6 - An overnight sync of SIMS with Fronter *should* give the user the county userid as their Fronter logon
    7 - SIMS ADP should create a tempory AD account for SLG, which the user can consolidate with the AD account generated above.
    8 - I send the user either via register of pigeon hole their county userid, e-mail address,initial passwords and instructions on consolidating the two AD accounts.

    I want to streamline this process as much as possible. If the first few steps can be automated to the point I recieve a csv file back from county that would be a great help. Reduce the reliance on two or three office staff remembering to send files and let me know about new accounts, etc.

  15. #12

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,193
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    That makes sense. Thanks.

  16. #13
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    922
    Thank Post
    56
    Thanked 161 Times in 113 Posts
    Rep Power
    67
    It's possible to automate this process if you use SIF, there are sif agents available that will create staff and student acounts. When a student is added to your it automatically send a sif message is send and the account is then create in ad by the ad agent.

  17. #14

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    61
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    16
    Capita have an AD Provisioning Tool (I think you have to pay extra for it) which may help

  18. #15

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,573
    Thank Post
    833
    Thanked 872 Times in 725 Posts
    Blog Entries
    9
    Rep Power
    324
    We have the AD Provisioning Tool on order. It's part of the Learning Gateway. Unfortunately this only sets up tempory AD accounts to log into SLG with. The user then consilidates the temporary account with their usual AD account the first time they login to SLG. They then login to SLG with their regular AD account after that.

    I'm trying to automate the process of getting the data out of SIMS to the LEA to generate what will be the users regular AD account logon.

    The plan is, from next years year 7's, that the users will have thes same userID for the network, SLG, Fronter and E-mail even if the passwords end up being different (until Shibboleth is rolled out by the LEA).

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 1
    Last Post: 13th April 2010, 09:51 AM
  2. Smoothwall - Network Guardian Alerts
    By Macinator in forum Internet Related/Filtering/Firewall
    Replies: 3
    Last Post: 14th March 2009, 08:16 AM
  3. Low power alerts
    By CESIL in forum Hardware
    Replies: 1
    Last Post: 10th November 2008, 04:39 PM
  4. PureMessage Alerts
    By atfnet in forum How do you do....it?
    Replies: 3
    Last Post: 30th April 2008, 11:14 AM
  5. SIMS and Automatic Updates
    By techyphil in forum Windows
    Replies: 9
    Last Post: 14th June 2007, 07:40 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
  •