QUESTION:
Is it possible to export Command Manager results to CSV or Excel when executing scripts in Windows command line for Strategy Analytics Command Manager 9.4.1?
ANSWER:
When executing Command Manager scripts via Command Manager GUI, users have the option to save the outputs to CSV or Excel file format. In some business scenarios, users may require to export Command Manager results to CSV or Excel when executing script via Windows command line.
However, currently Excel is not a supported file format for the Command Manager execution output in command line mode. An enhancement request has been logged for the feature and the request was confirmed to be in Strategy 9.5.1. However it is possible for users to export Command Manager results to CSV file format when executing through Windows command line.
The sample code can be as below where the ResultsFile that follows "or" parameter is a file in .CSV format.
cmdmgr -n "Strategy Analytics Modules" -u "UserName" -p "Password" -f "ScriptName.scp" -csv "ResultsFile.csv"
