+ Post New Thread
Page 1 of 4 1234 LastLast
Results 1 to 15 of 48
MIS Systems Thread, Accessing the SIMS database and querying it to retrieve information in Technical; Hi all, Looking to develop a system (using PHP, which I'm confident with) which queries the SIMS database to retrieve ...
  1. #1

    Join Date
    Mar 2011
    Location
    Newcastle upon Tyne
    Posts
    14
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Question Accessing the SIMS database and querying it to retrieve information

    Hi all,

    Looking to develop a system (using PHP, which I'm confident with) which queries the SIMS database to retrieve attendance information.

    Does anyone have any suggestions as to where I can start? A tutorial, or the like? Or is it simply a case of finding the DB that SIMS is running on, getting a username&password, and querying it as you would with any other DB?

    Cheers,
    Duncan

  2. #2

    Join Date
    Jan 2008
    Posts
    148
    Thank Post
    12
    Thanked 27 Times in 25 Posts
    Rep Power
    20
    You will need to use command reporter.

    generate an xml file that has the data you want to query attendance on.
    Code:
    commandreporter.exe /user:USERNAME /password:PASSWORD /report:"REPORT NAME" /PARAMFILE:"XML FILE WITH DATE" /output:"XML OUT"
    You can then use php to import it to mysql.

  3. 2 Thanks to chris_uk:

    dunc (7th October 2011), matt40k (6th October 2011)

  4. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Yer, going straight into the database would equal death in my book. Attendance data isn't the sort of stuff you want in real-time (assuming we're talking parents) so @chris_uk is right on the money.

  5. #4


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    It is doable - our old Moodle integration system did this. The problem comes if Capita unexpectedly change the database. You would be better off using commandreporter, or a SIF agent ( see SchoolsICT - enabling 21st century learning if you want to report data to parents), groupcall to do this. Also capita have made a complete mess of the database so it would be an uphill struggle.

  6. #5

    Join Date
    Jan 2008
    Posts
    148
    Thank Post
    12
    Thanked 27 Times in 25 Posts
    Rep Power
    20
    If you create the correct reports it's so easy to pull data out overnight. We have student timetables, attendance, contact details. It all updates nightly into MySQL for some web apps that we have in school. Pulling the data out as XML makes it even easier over pulling it out as a CSV. If you contact your support provider for SIMS you can get an additional help file that includes all of the commands for command reporter.

  7. #6

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,958
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    If the command reporter doesn't give exactly what you need, you can combine views. PM sent.

  8. Thanks to jinnantonnixx from:

    dunc (7th October 2011)

  9. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by jinnantonnixx View Post
    If the command reporter doesn't give exactly what you need, you can combine views. PM sent.
    PM sent include details about creating a limited user account for it to use?

  10. #8

    Join Date
    Mar 2011
    Location
    Newcastle upon Tyne
    Posts
    14
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for the help gents. E-mail system was down all day yesterday so I didn't realise I had so many replies

    I'll look into the PM you sent jinn, and the solution you've suggested chris - many thanks.

  11. #9

    Join Date
    Mar 2011
    Location
    Newcastle upon Tyne
    Posts
    14
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by chris_uk View Post
    You will need to use command reporter.

    generate an xml file that has the data you want to query attendance on.
    Code:
    commandreporter.exe /user:USERNAME /password:PASSWORD /report:"REPORT NAME" /PARAMFILE:"XML FILE WITH DATE" /output:"XML OUT"
    You can then use php to import it to mysql.
    Hi again chris,

    I've set up my attendance report; found CommandReporter.exe; run the line you gave me and it works insofar as the XML is displayed in my CMD window, but it doesn't generate an XML file.

    The exact line I was using:
    Code:
    C:\Program Files\SIMS\SIMS .net>CommandReporter.exe /user:Duncan.Wraight /passwo
    rd:password /report:"100% Attendance" /output: "g:\test.xml"
    Last edited by dunc; 7th October 2011 at 09:25 AM.

  12. #10
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    The exact line I was using:
    Code:
    C:\Program Files\SIMS\SIMS .net>CommandReporter.exe /user:Duncan.Wraight /passwo
    rd:password /report:"100% Attendance" /output: "g:\test.xml"
    You got some extra white space between /output: and the file name. Use

    Code:
    C:\Program Files\SIMS\SIMS .net>CommandReporter.exe /user:Duncan.Wraight /passwo
    rd:password /report:"100% Attendance" /output:"g:\test.xml"
    Last edited by rpwillis; 7th October 2011 at 09:54 AM. Reason: Get rid of quote markup

  13. Thanks to rpwillis from:

    dunc (7th October 2011)

  14. #11

    Join Date
    Mar 2011
    Location
    Newcastle upon Tyne
    Posts
    14
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Wow, what a noob Thanks very much Richard!

  15. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by chris_uk View Post
    ... If you contact your support provider for SIMS you can get an additional help file that includes all of the commands for command reporter.
    Does it contain any more than you can get from running it with the "/?" parameter?

  16. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by vikpaw View Post
    Does it contain any more than you can get from running it with the "/?" parameter?
    Maybe

  17. #14

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    Quote Originally Posted by matt40k View Post
    Maybe
    Take that as a yes then? I've tried getting this from my local support but they have no clue what I'm talking about, very frustrating.

  18. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    To be fair to them, it's one of those areas not many people use and unless you've used it, you won't know about it.

SHARE:
+ Post New Thread
Page 1 of 4 1234 LastLast

Similar Threads

  1. script to rename computer and join it to domain ...
    By RabbieBurns in forum Scripts
    Replies: 22
    Last Post: 2nd May 2013, 11:08 AM
  2. [SIMS] move sims db and log files to different partitions
    By ful56_uk in forum MIS Systems
    Replies: 7
    Last Post: 28th April 2011, 05:16 PM
  3. Script Help - Query AD and add it to a reg key
    By Stuart_C in forum Scripts
    Replies: 6
    Last Post: 14th May 2010, 06:04 PM
  4. Creating Home Folder.. and getting it to map for users
    By dgrams in forum How do you do....it?
    Replies: 16
    Last Post: 26th February 2010, 05:15 PM
  5. Restrict where student from accessing the C drive and Server
    By laputa01 in forum How do you do....it?
    Replies: 2
    Last Post: 1st May 2009, 10:56 AM

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 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
  •