[sims] CommandReporter.exe

[oxide54]

Hi

 

can i get command reporter dot exe to output csv to stdout?

[jinnantonnixx]

I haven't done much with Commandreporter, but the help screen says this:

 

The OUTPUT Parameter is optional, if left out the system

will output the results in standard xml to the console.

 

If it's outputting to console, it should be possible to pipe it further, if need be.

Edited August 9, 2012 by jinnantonnixx

[oxide54]

yeh i've seen that, it seems i can export xml to stdout or csv if i specify a file. i was rather hoping csv to stdout as i'm calling it from another program so i was just trying to avoid ever generating a temporary file given it has kids names + dobs in.

[jinnantonnixx]

My error - you specifically want CSV.

[oxide54]

i could parse the xml, but the csv parsing code is so much simplier. and its already written!

[rpwillis]

Hi

 

can i get command reporter dot exe to output csv to stdout?

 

No, csv output is only to file. You might be able to find a utility which can take xml input on stdin and convert to csv though.

[rpwillis]

i could parse the xml, but the csv parsing code is so much simplier. and its already written!

Personally I think working with xml is much easier. Amost every language has apis for xml documents which tell you if it's well formed and valid. CSV parsing is always dodgy due to the number of different formats it comes in. Especially when you start getting separators (,"') embedded in the data values.

[oxide54]

i do agree, but we where only put on this earth for a certain number of years!

 

on a serious note though, we are a happy customer of yours Richard!

[oxide54]

definitely coming round to your way of thinking richard, the program has evolved from a basic one time tool to something with a decent gui that will be used time and time again, and the next step is definitely to change the SIMS reports to XML.

 

Having said that I don't regret starting with CSV.

[bantonia]

Hi,

 

I know this thread may be a bit old but I've written some software which enables reports to be run remotely. It uses a Glassfish server on a SIMS workstation or server and provides a WSDL file which can be imported into your software to create the artifacts required for the communication. The only problems so far encountered is the speed reports are run and if the size of the results generated by the report is very large.

 

Software can be downloaded from: http://www.beaconhillcott.net

 

Regards