Requesting CSV report from CLI

r Ryan

on August 20, 2019

What's the proper command-line syntax to request a validation report in CSV format (assuming this format is still supported in the new CLI)?

I've tried a file extension of *.csv. with the arguments "--report.type=csv" and/or "--output.format=csv" (full argument list shown below) but it always defaults to Excel in the end.

Thanks in advance for any help.

Selected log output:

2019-08-21 01:17:47 [main] INFO n.p.oce.model.input.ParseResults - Loaded parameters |

Command line: --standard=ADAM --standard.version=1.1 --config=[path]\CLI\configs\1903.1\ADaM-IG 1.1 (FDA).xml

--source.adam=[path] --cdisc.ct.adam.version=2019-03-29 --cdisc.ct.sdtm.version=2019-06-28

--report=[path]\Test report.csv --report.cutoff=1000 --report.type=csv --output.format=csv

2019-08-21 01:17:47 [main] WARN net.pinnacle21.oce.utils.Valuables - ReportType cannot be determined for value 'csv'. Return 'excel'

[snip]

2019-08-21 01:17:47 [main] INFO net.pinnacle21.oce.model.FormatType - Failed to
find format type for file 'Test report' and extension 'csv'. Trying default 'csv'
2019-08-21 01:17:47 [main] INFO net.pinnacle21.oce.model.FormatType - Output fo
rmat type is provided as 'csv'
2019-08-21 01:17:47 [main] INFO net.pinnacle21.oce.model.FormatType - Failed to
find format type for file 'Test report' and extension 'csv'. Trying default 'excel'
2019-08-21 01:17:47 [main] INFO net.pinnacle21.oce.model.FormatType - Output format type is default as 'excel'

Forums: Troubleshooting and Problems

Philipp

on August 21, 2019

P21

Re: Requesting CSV report from CLI

Hello Ryan,

Unfortunately, Community 3.0 and newer versions don't support CSV validation reports because of very low user utilization of that feature.

CLI also doesn't support it (report.type parameter that you've tried is used for data miner, not validator, and output.format is used for converter).

Excel format is the only option for validation reports.

Sorry for the inconvenience!

Thanks,

Philipp