+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
MIS Systems Thread, Report for historic attendance figures in Technical; Originally Posted by PhilNeal This is what I have so far: Rather than trying to retrieve this data from the ...
  1. #16

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    Quote Originally Posted by PhilNeal View Post
    This is what I have so far:

    Rather than trying to retrieve this data from the reporting dictionary, it is possible to run one of the built in Attendance reports such as the Percentage Attendance Report. From this you can choose your own date ranges, and then save the output as raw XML, which can then be opened and modified in Excel to then run your macros on.
    Problem with that though is no CommandReporter for automation and extra steps for users to get the result they need, you'd have to provide them with an Excel template or something to load the XML in to so that it could churn through it... I can just imagine the response I'd get trying to tell some of our teachers to do that!

  2. #17

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    7,231
    Thank Post
    1,446
    Thanked 1,859 Times in 1,252 Posts
    Blog Entries
    22
    Rep Power
    559
    Quote Originally Posted by PhilNeal View Post
    This is what I have so far:
    Rather than trying to retrieve this data from the reporting dictionary, it is possible to run one of the built in Attendance reports such as the Percentage Attendance Report. From this you can choose your own date ranges, and then save the output as raw XML, which can then be opened and modified in Excel to then run your macros on.
    Thanks @PhilNeal
    This is pretty much what I have done now. So, I am using the AM/PM built in report for the dates required, dumping to xml then have some VBA code in our spreadsheet to reverse the name order (to match the name order used by the Attendance Officer in her spreadsheet) and workout the overall attendance %, then I can run the VBA that I had written to do all the stuff that the attendance officer needs.

    It appears to me that this is (possibly) needlessly complicated. The reason I got involved in this was our Attendance Officer couldn't work out how to get over attendance % for a given range out of Sims and into her spreadsheet. So some observations from this experience:
    • Unless I have missed something (and as indicated in a previous post) there is no built in report that can give overall attendance % for a given range. It would be useful to either have an overall % at the end of the AM/PM report or have a separate report showing this.
    • It would be even better if we could have access to the more than just current attendance % in the reporting dictionary; if we had access to historic marks then (I think) it wouldn't be that difficult to build a report that filters marks between certain dates.

  3. #18

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    The report probably runs a stored procedure which could be scheduled and possibly give the data in a more user friendly format. But that's a hack

  4. #19
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,427
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    One of the biggest problems I had was a lot of templates just went bang one day and disappeared, never got to the bottom of it. I haven't been able to recover them and subsequently stopped using macros and templates full stop.



SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] Attendance Reports for date range
    By ieuanprice in forum MIS Systems
    Replies: 1
    Last Post: 11th October 2013, 03:29 PM
  2. Online Reporting for September
    By Cache in forum CLEO
    Replies: 5
    Last Post: 12th October 2009, 08:55 PM
  3. Online reporting for parents
    By pooley in forum How do you do....it?
    Replies: 1
    Last Post: 19th May 2008, 01:15 PM
  4. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 12:27 PM
  5. Attendance figures from SIMS inconsistent
    By kingswood in forum MIS Systems
    Replies: 2
    Last Post: 8th June 2006, 11:28 AM

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
  •