+ Post New Thread
Results 1 to 7 of 7
How do you do....it? Thread, Staff support alert in Technical; A member of SLT wants me to create a program that when double clicked will send an alert to SLT ...
  1. #1

    Join Date
    Mar 2010
    Location
    Gloucestershire
    Posts
    154
    Thank Post
    20
    Thanked 3 Times in 3 Posts
    Rep Power
    10

    Staff support alert

    A member of SLT wants me to create a program that when double clicked will send an alert to SLT and Head of House laptops when a student needs to be removed from class.

    I haven't touched programming in 13 years, so what would the best programming language to learn to achieve this? I would like to learn several languages including a web-based language for some other projects I have in mind also.

    How easy would it be to extract data from our MIS (SIMS) into this program?

    My idea is the teacher opens the program either selects the teachers name, class room, and student (this data would have been extracted from SIMS) or enters the information manually into text boxes (probably easier) the teacher clicks send. This brings up a flashing box on the SLT and HOH laptops with the information entered.

    Any ideas would be greatly appreciated.

    Sean

  2. #2
    joe90bass's Avatar
    Join Date
    Oct 2007
    Location
    S Wales
    Posts
    1,354
    Thank Post
    327
    Thanked 107 Times in 96 Posts
    Rep Power
    51
    I thought SIMS had an alerting system built into it?

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,941
    Thank Post
    519
    Thanked 2,500 Times in 1,941 Posts
    Blog Entries
    24
    Rep Power
    840
    I believe joe90bass is right, it does somewhere. I've never used it though myself.

    To build this, I would use c# with MSSQL.

    Craft a report in SIMS which would export the information you want, and create a little application that imports that data into your own database (you shouldn't access the SIMS.net database directly, nor do you really want to - its a mess in there) - you can then make a batch script which calls the commandreporter.exe tool to run on a periodic basis to update the data stored etc...

    I'd combine the data from SIMS with usernames of the people logged in, so you can then find out which lesson/which room directly from their username. So, then you just have your client open on startup. Finally, have a button which submits the request and sticks it in the database.

    Then have another client which is running on the SLT/HOH laptops which periodically checks the database for any unacknowledged alerts and display them on screen along with an 'acknowledge' button.

    Simples.

  4. #4
    joe90bass's Avatar
    Join Date
    Oct 2007
    Location
    S Wales
    Posts
    1,354
    Thank Post
    327
    Thanked 107 Times in 96 Posts
    Rep Power
    51
    Good to know my memory is still okay.....From the help within SIMS:
    Sending an Emergency Alert


    Click the Emergency Alert button on the main SIMS toolbar, which is available from anywhere in SIMS.

    A confirmation message is displayed, indicating that the Emergency Alert has been sent.

    Click the OK button to continue.

    A message is sent immediately, via the selected communication method(s), to those people who have been selected as a recipient for an Emergency Alert.
    Attached is a screenshot of the config page for alerts
    alertconfig.jpg
    Last edited by joe90bass; 27th January 2012 at 01:09 PM.

  5. #5

    Join Date
    Mar 2010
    Location
    Gloucestershire
    Posts
    154
    Thank Post
    20
    Thanked 3 Times in 3 Posts
    Rep Power
    10
    Cheers both ill have a look.

  6. #6
    jdoyle's Avatar
    Join Date
    Mar 2008
    Location
    Republic of Swindon
    Posts
    394
    Thank Post
    70
    Thanked 49 Times in 42 Posts
    Rep Power
    57
    If you haven't programmed in a while, do you really want to spend time getting up to speed, developing, testing and then maintaining a single app?

    Why not check what you have in place and see if it can be utilized to produce what's being asked for?

    assuming everyone has email open generally, use MS Word/Excel 2010. Fill in templated data, Choose Save and Send, (PDF or Word Doc) with High Priority to a preset email group.

    Always possible to use VBA to keep the Word/Excel doc within boundaries.

    If you have Sharepoint 2010, choose Save and Send to Sharepoint and have Sharepoint send an alert by email/text to a preset group. InfoPath form as another possibility?

    alternatively, if staff have mobiles phones, possibly setup a text messaging procedure.

  7. #7


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,656
    Thank Post
    276
    Thanked 780 Times in 607 Posts
    Rep Power
    224
    I'd say IRC, IM (say Jabber with AD auth) and auto-login when their desktop loads.

    KISS. Don't re-invent the wheel just because you can.

SHARE:
+ Post New Thread

Similar Threads

  1. How many staff support your MIS?
    By pantscat in forum MIS Systems
    Replies: 21
    Last Post: 17th October 2011, 02:07 PM
  2. Replies: 28
    Last Post: 15th August 2010, 09:47 AM
  3. Support Staff or Non-Teaching?
    By webman in forum General Chat
    Replies: 58
    Last Post: 20th April 2007, 12:06 PM
  4. First Free Workshop For ICT Support Staff
    By russdev in forum General EduGeek News/Announcements
    Replies: 12
    Last Post: 10th March 2006, 10:33 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
  •