MIS Systems Thread, CommandReporter script to export all staff and students in Technical; Hi all,
I'm looking for a script which is hopefully relatively straightforward. I'd like to run CommandReporter.exe every day (via ...
24th April 2013, 11:13 AM #1
- Rep Power
CommandReporter script to export all staff and students
I'm looking for a script which is hopefully relatively straightforward. I'd like to run CommandReporter.exe every day (via scheduled task) and have it produce me an XML file which I can then manipulate with PHP.
I'd like the script, if possible, to produce the following information:
- Intake Year
- Registration Group
- Flags (SEN, FSM etc)
Does anyone have such a script currently working that I might be able to have a look at? I've fiddled with CommandReporter.exe before, albeit some time ago. If I remember correctly, I had to send it some parameters in the form of an XML file?
Thanks in advance,
24th April 2013, 11:20 AM #2
CommandReporter is simply a CLI method of running SIMS reports. You create a report in SIMS via the usual method (Reports > Design Report) then you run command reporter passing it the name of the report with the "/report" argument. e.g. if you created a report called Export Students, the command to run it via CommandReporter would be:
If the data you need is going to be the same every time (i.e. you apply the same set of filters), it'll be much easier to set these filters in SIMS rather than via XML. Just add the filters you want to the report in SIMS but don't tick "prompt at runtime", then whenever you run the report those filters will be applied.
CommandReporter.exe /user:username /password:password /report:"Export Students" output:"path\to\save\file.xml"
Or if you're using AD authentication to login to SIMS:
CommandReporter.exe /trusted /report:"Export Students" /output:"path\to\save\file.xml"
As for running it as a scheduled task - create a BAT file containing the call and add it to your server's scheduled tasks as you would any other program
24th April 2013, 11:56 AM #3
- Rep Power
Perfect, cheers LO
24th April 2013, 12:30 PM #4
If you go to http://www.beaconhillcott.net then you could download some software I wrote some time ago which will enable you to run SIMS reports remotely. It does use Glassfish though but you can get the results of the report via webservices and WSDL, this is what I use. As long as you are not bothered with the time it takes for a report to run, you will never get the same response as direct access using SQL.
By timethrow in forum Scripts
Last Post: 30th November 2011, 04:12 PM
By adder1230 in forum General Chat
Last Post: 24th October 2010, 09:13 PM
By ITWombat in forum How do you do....it?
Last Post: 14th December 2009, 12:33 PM
By woody in forum Scripts
Last Post: 27th November 2005, 11:41 PM
By mark in forum School ICT Policies
Last Post: 12th July 2005, 01:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread