+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, SIMS report to output students who have a birthday today in Technical; I've been asked to see if its possible to show a "Happy birthday to" section on our digital signage. The ...
  1. #1

    Join Date
    Dec 2007
    Posts
    149
    Thank Post
    0
    Thanked 5 Times in 5 Posts
    Rep Power
    16

    SIMS report to output students who have a birthday today

    I've been asked to see if its possible to show a "Happy birthday to" section on our digital signage. The easiest way I can see it is to get sims to report the names and for me then to "perl" these into a web page or rss feed that the digital signage software (Xibo) will pull down and display.

    I just need to know a) how to run a sims report on a schedule (it has to be automated!) and b) how to get the sims report to default to "today" for the matched DOB filter.

    If only I could do a "select name, surname, dob from 'students' where 'students.dob' eq %todaysdate% "

    Any ideas appreciated.

    (ps don't pick me up on my sql syntax it was just to demonstrate how easy it should be to get at the information in SIMS!_)

    ChrisJ

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    SQL is possible, but there is a report built in that shows a birthday list, defaults to today and shows a list which you can filter by reg group / year showing days to next birthday. obviously you need to just show those with 0. we run an edited version for a weekly list, but it's done manually.

    As for scheduled. Set up the report and you can use something like command reporter to run it with a script.

    To use the built in scheduled feature you have to get the manual from Capita SupportNet, it may already be in the built in documentation on server but i don't think so. This describes the process in detail, including the setting up of a scheduled task to run the report for you.

    Hopefully that is the easiest way and does what you want.

    By the way, the default output was to excel i think, i guess that's okay for you.
    Last edited by vikpaw; 5th January 2011 at 05:11 PM. Reason: neatness

  3. #3

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    would be interesting to here actually - never really thought of using Xibo for this but could be cool to have an RSS feed along the bottom or something

  4. #4

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,154
    Thank Post
    12
    Thanked 224 Times in 214 Posts
    Rep Power
    66
    Just to butt in but if that was me at a school I wouldn't want everyone knowing my birthday, isn't there some breach of confidential information here possibly if been displayed on the board its their birthday?

    Just a thought.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by MatthewL View Post
    Just to butt in but if that was me at a school I wouldn't want everyone knowing my birthday, isn't there some breach of confidential information here possibly if been displayed on the board its their birthday?

    Just a thought.
    it's for kids, so don't they go around bragging that they are 7 and 3 quarters to everyone...? and bring cakes in. I know i do, add 30 odd years though.

  6. #6

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,154
    Thank Post
    12
    Thanked 224 Times in 214 Posts
    Rep Power
    66
    I know but still I know I wouldn't of wanted my birthday spreading around when I was at school, just something to think off, some kids don't like the world to know everything about them.

  7. #7

    Join Date
    Dec 2007
    Posts
    149
    Thank Post
    0
    Thanked 5 Times in 5 Posts
    Rep Power
    16
    Quote Originally Posted by glennda View Post
    would be interesting to here actually - never really thought of using Xibo for this but could be cool to have an RSS feed along the bottom or something
    Does that mean you use xibo too? Just installed it the week before Christmas after failing to get on well with Sedao/Image flyer.

    If I get it working I'll let you know (via this thread.)

  8. #8

    Join Date
    Dec 2007
    Posts
    149
    Thank Post
    0
    Thanked 5 Times in 5 Posts
    Rep Power
    16
    Quote Originally Posted by MatthewL View Post
    I know but still I know I wouldn't of wanted my birthday spreading around when I was at school, just something to think off, some kids don't like the world to know everything about them.
    That's a good point but its not a technical one. I'll sort out the service, they can sort out the permissions/implications/ DPA breach related issues. ;0) I've been itching to get a scheduled sims report running but not had a "Non essential" reporting task to try it on yet. Looks like this is my guinea pig.

    Thanks for the heads up on the existing report. I'll mod it to output to csv, then parse the file with a php page to present it as an rss feed or similar.

  9. #9

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    Yeah I have been using xibo for just under a year - replaced all our old Mediacat's with xibo machines. Currently got 4 screens around the school and hopefully more in the pipeline.

    I think its a pretty cool idea and if we can get it all automated would be great - i currently have a .htm file that uses javascripting to create the date and display it, then RSS feed at the top with BBC news then a few powerpoints in the middle!
    Last edited by glennda; 5th January 2011 at 10:56 PM.

  10. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    can you get the sims report to output to html or xml so it's more usable....?

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS output to XML
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 14th December 2010, 07:10 AM
  2. [MS Office - 2010] SIMS Report
    By rh91uk in forum Office Software
    Replies: 2
    Last Post: 13th November 2010, 09:00 AM
  3. Another Sims Report
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 29th January 2008, 04:58 PM
  4. Report Students with *.mp3 *.avi *.ogg
    By roland in forum How do you do....it?
    Replies: 8
    Last Post: 24th August 2007, 04:50 PM
  5. Students on report
    By Jamie_a in forum MIS Systems
    Replies: 9
    Last Post: 10th May 2007, 07:24 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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