MIS Systems Thread, CommandReporter.exe in Technical; Hi
can i get command reporter dot exe to output csv to stdout?...
9th August 2012, 10:11 AM #1
can i get command reporter dot exe to output csv to stdout?
9th August 2012, 10:38 AM #2
I haven't done much with Commandreporter, but the help screen says this:
If it's outputting to console, it should be possible to pipe it further, if need be.
The OUTPUT Parameter is optional, if left out the system
will output the results in standard xml to the console.
Last edited by jinnantonnixx; 9th August 2012 at 10:40 AM.
9th August 2012, 10:39 AM #3
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.
9th August 2012, 10:41 AM #4
My error - you specifically want CSV.
9th August 2012, 10:42 AM #5
i could parse the xml, but the csv parsing code is so much simplier. and its already written!
9th August 2012, 10:47 AM #6
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.
Originally Posted by oxide54
9th August 2012, 10:50 AM #7
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.
Originally Posted by oxide54
Thanks to rpwillis from:
oxide54 (23rd October 2012)
9th August 2012, 11:06 AM #8
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!
Thanks to oxide54 from:
rpwillis (10th August 2012)
23rd October 2012, 10:34 PM #9
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.
10th December 2012, 03:14 PM #10
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
By E1uSiV3 in forum Windows
Last Post: 20th July 2013, 04:47 PM
By Tim158 in forum MIS Systems
Last Post: 12th June 2012, 04:34 PM
By tosca925 in forum Scripts
Last Post: 20th March 2010, 12:51 AM
By lee_sri in forum Windows
Last Post: 22nd March 2006, 08:43 PM
By tosca925 in forum How do you do....it?
Last Post: 12th December 2005, 10:45 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)