PHP and commandreporter.exe
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.
This produces the following output and error:
$output = shell_exec(escapeshellarg("c:/Program Files (x86)/SIMS/SIMS .net/CommandReporter.exe")." /USER:joebloggs /PASSWORD:joebloggs /REPORT:TimTest 2>&1");
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 :eek: