+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, Exporting Attendance Data from SIMS.Net in Technical; We use scheduled commandreporter and custom reports to export timetable and student data from SIMS to be imported into other ...
  1. #1
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20

    Exporting Attendance Data from SIMS.Net

    We use scheduled commandreporter and custom reports to export timetable and student data from SIMS to be imported into other data systems.

    In the same way, I would now like to create a custom report in SIMS.Net which reports AM/PM attendance marks for all students over a period of time (such as an academic year) and would like the report to export as XML, ideally in the following basic format (the xml tags are hypothetical):

    <student admissionnumber=”010000”>
    <attendancedata>
    <attendancemark date=”05/09/2008” session=”am” mark=”/” />
    <attendancemark date=”05/09/2008”/>session =”pm” mark=”\” />
    <attendancemark date=”06/09/2008” session =”am” mark=”/” />
    <attendancemark date=”06/09/2008” session =”pm” mark=”\” />
    Etc. etc.
    </attendancedata>
    </student>

    Etc. etc.

    Is anyone aware of a way to do this?

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Where is this going to?

  3. #3
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20
    As with the existing reports, the report would be set to export as XML onto a location on the SIMS server and would be run via commandreporter at scheduled times. A few minutes later, the resulting XML file is then read from a script which updates a SQL Server DB.

    The idea will be that we use that data (in the SQL Server DB) to provide attendance data on a future parent portal (aka online reporting) and potentially on existing data systems such as progress tracking and student learner profile.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Are you a company doing this? Or a school who's made a inhouse solution?

  5. #5
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20
    We are a school.

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    You can do this. Just not sure why you would want to do this? You're going to hit a lot of security\data protection stuff. What's wrong with SLG2?

  7. #7

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    247
    Thank Post
    23
    Thanked 37 Times in 28 Posts
    Rep Power
    20
    I don't have SIMS running from home at the moment (long story) so I can't look at the reporting tree, but it should be feasible.

    Attendance in general is certainly possible; AM/PM split may be, or at least you could export all the attendance marks and aggregate the data outside of SIMS if need be, although that way would be fairly inefficient.

    I'm exporting our attendance data as summaries, in order to import previous attendance data into assessment aspects (since you can't show what we want in a marksheet otherwise) and it can be done, one way or another.

    If you're doing it for online reporting, though, there is a strong case for using something like SLG, as the authentication issues involved are solved that way. "Rolling your own" auth mechanism is doable, but to make it really robust is a whole other matter! Many LAs, and certainly Capita themselves, offer a hosted SLG service, which would allow you to show data without having to worry about the implementation side.

  8. #8
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20
    What's wrong with SLG2
    That's probably the wrong question since we're looking at what we want to achieve first, then what the best solution to that requirement is. We are currently gathering requirements but it is possible that SLG2 won't meet our Requirements Specification and in addition is pretty expensive. Finally, our LA appear to have put a (presumably) cheaper LA hosted SLG2 solution firmly on the back burner.

    As I say, we are only at the stage of gathering requirements and assessing feasibility at this point.
    Last edited by u8dmtm; 8th September 2009 at 02:29 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  2. Historical data in SIMS.net
    By MattMitchell in forum MIS Systems
    Replies: 13
    Last Post: 23rd May 2009, 08:11 AM
  3. SIMS.net Attendance and Pupil ID Cards
    By penfold_99 in forum MIS Systems
    Replies: 4
    Last Post: 24th April 2009, 01:40 PM
  4. Exporting your Sims.net Diary to Outlook 2003
    By the.damon in forum MIS Systems
    Replies: 1
    Last Post: 5th November 2008, 02:55 PM
  5. Exporting Pupil Data From SIMS
    By David_Paylor in forum MIS Systems
    Replies: 9
    Last Post: 23rd March 2007, 03:16 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
  •