Jump to content

Accept All (bypass filter condition) using SIMS.net CommandReporter


Recommended Posts

Posted
I have a SIMS report that I use to extract data for a year, the whole school or an individual student. This report is run using commandreporter and a suitable XML file depending on what criteria I want to use when running the report. This all works well, the problem comes when I want to report on all students. I currently have a filter on the student admission number. I pass an XML file to command reporter and the report is run against that student. What value do I pass in the XML file to simulate the Accept All (bypass filter condition) option that I could use if running the reports from SIMS?
Posted (edited)

From the manual the example it gives is

[TABLE="width: 624"]
[TR]
[TD]CommandReporter /USER:user1 /PASSWORD:abcd /REPORT:"SomeReport" /QUIET [color=#ff0000]/PARAMS:"version ='1.0' encoding= 'utf-8'?>bypass='True'>13
"[/color][/TD]
[/TR]
[/TABLE]
The effect of this call would be to tell the CommandReporter to ignore the Parameter with id 1 and set the value of parameter 2 to 13. 
Then run the report. In reality the Command Reporter produces a unique id for each report parameter, this is in the form of an base64 encoded hash value 
(such as 'AFSC0Yv85p6cl85rhlkKjw==') which identifies the report parameter. 

So the bit you need is bypass='True'

Edited by Esteban_Child_of_the_Sun
  • Thanks 1
Posted
Thanks for this. Exactly what I needed. We actually use a Powershell wrapper for CommandReporter so we can pass in human readable variables to the Powershell script which it converts in to the encoded values and makes a correctly formatted XML file from. Looks like I need to update the script to take a bypass argument now.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...