[sims] command reporter no output

[haci]

Morning Guys

 

Just wondering if anyone can assist me with this my data manager has asked me to automate one of his reports I've followed a few videos he sent and have the batch file running but once it completes there is no file output.

does anyone have any pointers or have any idea why that may be?

 

"C:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.EXE" /USER:username /password:password /SERVERNAME:servername /DATABASENAME:simsdatabase /REPORT:"Pastoral Behaviour Report SN2" /OUTPUT: "S:\sims\PBI\B.csv" PARAMS: ""

 

Cheers

Paul

[David44]

If you leave out the /OUTPUT: "S:\sims\PBI\B.csv" part of the command line, it should write the output to the screen. Does that work?

 

Maybe you just can't write to the path you have specified.

[3s-gtech]

All my reports output to a local disk rather than the mapped one - can you try that? That can be caused by the S: drive not being accessible to the running user.

[haci]

If you leave out the /OUTPUT: "S:\sims\PBI\B.csv" part of the command line, it should write the output to the screen. Does that work?

Maybe you just can't write to the path you have specified.

Strange thing is even with the /output flag it pulls info to the console, is that not expected?

 

I've tried various paths and I do have permissions to the drive I'm using and have tried a number of different locations.

[haci]

All my reports output to a local disk rather than the mapped one - can you try that? That can be caused by the S: drive not being accessible to the running user.

 

I have tried both the local disk on the server shared drives local disk on my workstation and my profile path and all do the same, output to the console close at completion and no output file.

[3s-gtech]

Try removing the PARAMS flag and the space before the output file path.

[David44]

Strange thing is even with the /output flag it pulls info to the console, is that not expected?

 

No, it's not. It must be ignoring /output

Try removing the PARAMS flag and the space before the output file path.

 

And this is probably why (the space before the path). It's very fussy.

[haci]

Cheers guys, I am officially an idiot

 

Removing the space worked, I can't tell you how many times I read that line looking for exactly those kind of things and missed it