[SIMS] SIMs and Command Reporter

[RuAware]

I am trying to create an auto script to dump a rtf on the network that shows all children not in school when the report is run.

I have created the report in reports using

Attendance Marks
Is not Present
Mark Date

As filters

Running it is fine and gives me the result i want either using sims or the command reporting tool.

Running through sims - i can change the date at prompt for "Mark Date"

But i need to tell the command reporting tool to use the current date on run.

Anyone know how i can do this?


Thank you

Jamie

[dhicks]

But i need to tell the command reporting tool to use the current date on run.

I seem to remember you have to pass an XML file with your parameters to CommandReporter. Sorry, I don't have any more details to hand at the moment and that's all I can remember.

--
David Hicks

[RuAware]

Thanks for the reply... I am trying to pass paramaters using xml but it is just not listening!! Any help greatly appreciated

Thanks

[MattMitchell]

Ask your LA or Capita support for the third-party reporting documentation - apparently that'll tell you how to do it.

[Greg]

you can do this via a bat file.
You need to get the date and then convert into the correct format in DOS. The required date format is yyyy-mm-dd

You can do this with the following code
for /f "tokens=1-4 delims=/ " %%f in ('date /t') do (
set dd=%%f
set mm=%%g
set yyyy=%%h
)

Then call commandreporter with the required parameters and add the following between the <ReportParameters><Parameter> </Parameter></ReportParameters> tags
subreportfilter='True'><Values><Date>%yyyy%-%mm%-%dd%</Date></Values>

Make sure that you have a corresponding date filter set in the report.

[robins]

Thansk - thats clever. With regards the SIMS report designer - I've asked for the concept of a current date range like today, this week, this month, this term etc to be added to the data dictionary in some future release.
Simailarly it would be nice to choose 'current user' as a filter so its not necessary to customise report designs to only pick up records that relate to them, eg kids in their class or behaviour incidents attributed to them etc.

[J_Pratt]

I'm having great trouble making commandreporter do what I want it to. I have got it running reports, but it does not use the parameters I try to give it. This is what I have rtied to use:

C:\Program Files\SIMS\SIMS .net>commandreporter /user:MYUSERNAME /password:MYPASSWORD /report:"JPs Todays Register" /params:"<ReportParameters><Parameter><Values><Date >2010-01-15</Date></Values></Parameter></ReportParameters>" /output:"C:\current register.txt"

The report runs fine, but it doesn't use the parameter (instead it gives me the register for 5/10/09 as that is the default day in the prompt when you run the report in sims).

Any idea how I can make it use my parameter to limit it to today's register.

PS I'm generating the above line in VBA from Microsoft Access so I can import the data to a database to process it.

Cheers

J Pratt

[MattMitchell]

Have you tried running commandreporter without an output switch (or whatever the syntax is) to see what the parameters should look like? I'm pretty sure you have to name the parameter.

[J_Pratt]

I have tried doing that, but I'm not sure which bit I'm looking for.

My report starts:

- <SuperStarReport>
- <xs:schema id="SuperStarReport" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
- <xs:element name="SuperStarReport" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="Record">
- <xs:complexType>
- <xs:sequence>
<xs:element name="multiple_id" type="xs:string" minOccurs="0" />
<xs:element name="Adno" type="xs:string" minOccurs="0" />
<xs:element name="Mark" msdata:Prefix="REL" type="xs:string" minOccurs="0" />
<xs:element name="AM_x002F_PM" msdata:Prefix="REL" type="xs:string" minOccurs="0" />
<xs:element name="Mark_x0020_date" msdata:Prefix="REL" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>

The mark date data is also very complicated, as it is includes a time.

Mark Date in the main report is recorded as either:

• 2009-10-01T09:00:00+01:00
• 2009-10-01T13:00:00+01:00

I have tried changing <Date> in my original attempt to <Mark_x0020_date>, but it still ignored it.

J Pratt

[LosOjos]

if you run the report from commandreporter with the /PARAMDEF switch, the output file will be the paramdef file you need to pass to set parameters. Just read the XML from that and alter the relevant values to specify your parameters.

EDIT:
Set a default value for the parameters manually in Sims before you run commandreporter, that way you get an example in the output XML

[J_Pratt]

Thanks - it is working beautifully now.

J Pratt

[vikpaw]

Thansk - thats clever. With regards the SIMS report designer - I've asked for the concept of a current date range like today, this week, this month, this term etc to be added to the data dictionary in some future release.
Simailarly it would be nice to choose 'current user' as a filter so its not necessary to customise report designs to only pick up records that relate to them, eg kids in their class or behaviour incidents attributed to them etc.

good idea have you got a change request number we can vote on..?

[browolf]

anychance someone can email me the documentation for command reporter? /pm

[penfold_99]

anychance someone can email me the documentation for command reporter? /pm

The documentation is bound by an agreement with capita, so can't be shared.

To be frank you have more information here plus the /? output of command reported than the documentation contains.

[vikpaw]

The documentation is bound by an agreement with capita, so can't be shared.

To be frank you have more information here plus the /? output of command reported than the documentation contains.

lol - that's shocking