How Can I Pass Text to SIMS Command Line Reporter

[Grazza]

I've been busy developing software in visual studio that automatically runs sims reports and imports them into my own software's SQL database.

 

This works fine, but now I need to pass a line of text (the name of an aspect) to Command Line Reporter.

 

Example of text is:

A8 Computing PRED

 

I have specified in the report ask at runtime, and the variable is:

Aspect Name

 

Can anybody help with the XML for this? Mine just does not work.

 

Regards

 

Graham

[vikpaw]

Check the help on the commandreporter, there are a few threads on the topic here too.

You have a parameter that is /paramdef or something that will generate an XML output for sample, then you can pass an amended version of that file back in or provide as a string i think.

If you're already got that far, then put some examples of the file/code here so people can see what it looks like and maybe spot any errors.

[LosOjos]

Hey @Grazza - notice your local (I live in Walsall, work in Sandwell)

 

You'll want to look at param def files; there's been loads posted on here over the years, but these threads should get you started:

http://www.edugeek.net/forums/mis-systems/66215-sims-net-reporting.html

http://www.edugeek.net/forums/mis-systems/82481-commandreporter-param-files-parameter-ids-2.html

http://www.edugeek.net/forums/mis-systems/57084-sims-command-reporter-working-examples.html

[Grazza]

I've sorted it and it's all working.

 

I didn't realise that running with /PARAMDEF actually produced the XML for you, as I was manually writing it. There was a lot of XML in the file which I removed and just left the variable to pass.

 

My programme now writes out the smaller XML file and runs the same report to get multiple information out. It took a while as it ran the same report 23 times and that's just for year 10, but it's working now thanks.

 

Thanks all for your help.