[sims] SIMS.net CommandReporter.exe Error Running Report

[mikebah]

I would like to run and save the output of a SIMS.net report using the CommandReporter.exe tool included with the package.

I have tried running the following command:

 

CommandReporter.exe /user:username /password:password /report:"No Photograph Report" /output:nophotoreport

 

And when I run it, this is displayed:

 

SIMS.net Command Line Report Exporting Utility 7.159.4.0
Copyright ¸ Capita Business Services Ltd 1984-2014. All rights reserved.
Logging into to SIMS.net as user username
Getting reports for user username
Report 'No Photograph Report' found.
Running Report
Error Running Report. Reason :Incorrect syntax near ')'.
Incorrect syntax near 'a0'.

 

Do I have to include parameters aswell? Is it a problem with permissions?

 

Thanks in advance.

[LosOjos]

That's a new one to me

 

Does the report run properly in SIMS itself?

[mikebah]

Yeah, it's absolutely fine running from the SIMS application.

 

Would you happen to know where the reports are kept in Windows?

[Meldrew]

Odd error, but 2 things spring to mind. The "/output:nophotoreport" should be a pathname, eg c:\nophoto.xml, might be making it act odd. Also I usually specify /server and /database. Does it work with these specified?

 

Meldrew

[chilbs]

Is best to use the full path in the output and yes it might be after some parameters if you add /PARAMDEF to your code the output should be a xml file with the default parameters for that report

[mikebah]

Ah, I see. It is only when I run an imported report (that is, not made internally). Other reports generated by staff here run successfully with the current command parameters put in.

 

What should I dictate using /paramdef to get the imported report working?

[chilbs]

the /paramdef does not require any additional input. Have you looked at the help generated by running CommandReporter.exe on it own with no switches.

[Meldrew]

My understanding is that you run it once with /paramdef, specifying the output file, eg /paramdef / output:"c:\parameters.xml". This gives you the necessary parameters that you need to populate in the xml file, then you run commandreporter again, specifying /paramdef:"c:\parameters.xml" and commandreporter pulls these values in from the xml file as values for the report.

 

HTH,

 

Meldrew.

[chilbs]

when running the commandreporter again the switch to input the parameters xml file is /PARAMFILE e.g. /PARAMFILE:"c:\parameters.xml"

[mikebah]

I've chucked /paramdef /output:H:\nophotoreport.xml at the end of the command and it has generated a file successfully. But I can't seem to decipher what it i.e. I can't see any valuable information such as names of students.

[chilbs]

try running this next. Replace the .csv with the file type the report is supposed to output

 

CommandReporter.exe /user:username /password:password /report:"No Photograph Report" /output:"H:\nophotoreport.csv" /PARAMFILE:"H:\nophotoreport.xml"

[mikebah]

This is still not working. I get the same error after specifying the /paramfile parameter.