MIS Systems Thread, SIMS Command Reporter - Accessing pre-defined "Registration Certificate Report" in Technical; Hello Everybody,
I am currently using the SIMS command reporter to extract data for a schools reporting web service. I ...
9th May 2013, 11:33 AM #1
- Rep Power
SIMS Command Reporter - Accessing pre-defined "Registration Certificate Report"
I am currently using the SIMS command reporter to extract data for a schools reporting web service. I am able to design my own custom reports and call then using the report:"*reportname*" command line arguements on the command reporter. I am however looking to extract the attendance report for individual users as XML then parse this and display it nicely.
SIMS has a built in way of doing this through the "Registration Certificate Report" which I can access through the SIMS interface and generate the XML I need. However I need to be able to do this programatically, and when I try and give "Registration Certificate Report" as the report name I get an error saying the report cannot be found. Does anybody know how I can get the command reporter to run this report?
Many Thanks In Advance
11th May 2013, 02:30 PM #2
I'm pretty sure that the built-in reports are not available for command reporter. You'd have to create your own custom report.
11th May 2013, 03:15 PM #3
I have had very good success using vbscripts to automate certain SIMS tasks. Usually, this is conducted by priming the system (Assessment) to a certain stage, ready to carry out bulk changes to for example resultsets in a marksheet.
There's no reason why this couldn't be used to run SIMS and step through the menus to run the report you want. The menus and options in SIMS are accessible through keyboard shortcuts and tabs even when there is no visible cursor. The only messy part would be saving the output of the XML from the output file depending on where and how it opens.
If you have a dedicated machine to do the task it can all be tested and hard-coded.
You're supposed to be able to open SIMS and auto open a menu item, but that doesn't work for me, probably because i don't use trusted logins.
Once open, though you can Alt+r+n+i+r | use Tab / Shift+Tab to move around and ctrl+s to search, ctrl+p to print.
The thread with details and a sample script is here SIMS AM7 Template Change resultset script
If you want to go that route and need help, give me a shout. For a simple run one report kind of task, you could also use something like AutoIT.
p.s. to EG
Last edited by vikpaw; 11th May 2013 at 03:16 PM.
By ieuanprice in forum MIS Systems
Last Post: 27th February 2013, 12:35 PM
By Eric in forum MIS Systems
Last Post: 4th July 2011, 09:36 AM
By wesleyw in forum MIS Systems
Last Post: 19th October 2010, 10:48 AM
By browolf in forum MIS Systems
Last Post: 1st July 2010, 01:45 PM
By randle in forum MIS Systems
Last Post: 18th June 2007, 01:35 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread