+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, PHP and commandreporter.exe in Technical; ...
  1. #1

    Join Date
    Sep 2010
    Location
    Suffolk
    Posts
    2
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    PHP and commandreporter.exe

    Hi there,

    I have an excellent new PHP/mySQL-based reward system for my school that I would to integrate with SIMS. To start, I've installed a web server (IIS) on the same server (windows 2008) as SIMS. PHP is working fine so I run the following code in an attempt to get lots of XML on the web page I am looking at.

    Code:
    $output = shell_exec(escapeshellarg("c:/Program Files (x86)/SIMS/SIMS .net/CommandReporter.exe")." /USER:joebloggs /PASSWORD:joebloggs /REPORT:TimTest 2>&1");
    
    echo "<pre>".$output."</pre>";
    This produces the following output and error:

    SIMS.net Command Line Report Exporting Utility 7.60 Copyright (C) Capita Education Services 2006. All rights reserved. Logging into to SIMS.net as user joebloggs Getting reports for user joebloggs Report 'TimTest' found.
    Error Loading Report. Reason :The type initializer for 'SIMS.Processes.DocumentServers' threw an exception.


    I had a brief look at the way Moodle interacts with SIMS but its like a sledgehammer is being used to crack an egg (does it really need to be that messy?). A simple solution is what I am after, but any solution will do. I've spent about a week on this problem and I welcome anything that may be of help. I'm sure Capita could tell me the answer but I don't fancy their £1,000 per day tech support

    Tim

  2. #2

    Join Date
    Jun 2012
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Tim158 View Post
    Hi there,

    I have an excellent new PHP/mySQL-based reward system for my school that I would to integrate with SIMS. To start, I've installed a web server (IIS) on the same server (windows 2008) as SIMS. PHP is working fine so I run the following code in an attempt to get lots of XML on the web page I am looking at.

    Code:
    $output = shell_exec(escapeshellarg("c:/Program Files (x86)/SIMS/SIMS .net/CommandReporter.exe")." /USER:joebloggs /PASSWORD:joebloggs /REPORT:TimTest 2>&1");
    
    echo "<pre>".$output."</pre>";
    This produces the following output and error:

    SIMS.net Command Line Report Exporting Utility 7.60 Copyright (C) Capita Education Services 2006. All rights reserved. Logging into to SIMS.net as user joebloggs Getting reports for user joebloggs Report 'TimTest' found.
    Error Loading Report. Reason :The type initializer for 'SIMS.Processes.DocumentServers' threw an exception.


    I had a brief look at the way Moodle interacts with SIMS but its like a sledgehammer is being used to crack an egg (does it really need to be that messy?). A simple solution is what I am after, but any solution will do. I've spent about a week on this problem and I welcome anything that may be of help. I'm sure Capita could tell me the answer but I don't fancy their £1,000 per day tech support

    Tim
    Did you ever solve this? I'm in an identical situation.

  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
    The way I did it was to run the reports as a scheduled task, then just grab those XML files as you would any other.

  4. #4

    Join Date
    Jun 2012
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I'm trying to avoid that because of the data protection issues of having student details left in an unprotected file. It appears to be somethig to do with permissions of the user used by IIS8 to execute the command.

  5. #5

    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
    Quote Originally Posted by graym View Post
    I'm trying to avoid that because of the data protection issues of having student details left in an unprotected file. It appears to be somethig to do with permissions of the user used by IIS8 to execute the command.
    If someone has access to that server, then they have access to the data already, as they can just copy the sims database...

  6. #6

    Join Date
    Jun 2012
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    The addresses in the sims databases are encrypted. I'll do that as a last resort, but I can't for the life of me figure out why running the shell command manually on the webserver works fine, but running it through the website (as the same user - checked in IIS) won't.

  7. #7

    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
    Quote Originally Posted by graym View Post
    The addresses in the sims databases are encrypted. I'll do that as a last resort, but I can't for the life of me figure out why running the shell command manually on the webserver works fine, but running it through the website (as the same user - checked in IIS) won't.
    No they aren't. They are plain text, just like all the info in the SIMS db. Or at least, they were when I last looked 6 months ago.

  8. #8
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    178
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    It's probably having a problem finding the My Documents for the IIS user. Try setting Load User Profile to True on the application pool.

  9. #9
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,856
    Thank Post
    930
    Thanked 429 Times in 362 Posts
    Blog Entries
    12
    Rep Power
    89
    Tried to do something very similar last term. There is a 7 page thread on it here.

    In the end I gave up with command reporter. It seemed to me that Capita didn't want to make it easy to use it, especially in a batch way.

    In the end we bought a piece of software called tasc insight which did everything perfectly including achievements and reports to parents/students for less than a grand.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS ID Interface / CommandReporter Example
    By LosOjos in forum MIS Systems
    Replies: 10
    Last Post: 7th June 2010, 01:51 PM
  2. SIMS.Net CommandReporter scheduled doesn't work
    By u8dmtm in forum MIS Systems
    Replies: 9
    Last Post: 8th January 2009, 11:07 AM
  3. CommandReporter List Parameters
    By Willzzz in forum MIS Systems
    Replies: 0
    Last Post: 15th October 2008, 12:31 PM
  4. CommandReporter Reports
    By kerlj001 in forum MIS Systems
    Replies: 5
    Last Post: 29th September 2008, 10:47 PM
  5. CommandReporter - History of Changes?
    By DaveS in forum MIS Systems
    Replies: 5
    Last Post: 27th February 2008, 11:44 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
  •