search cancel

SCRT Validation Error message for an export Excel file

book

Article ID: 214770

calendar_today

Updated On:

Products

COMMON SERVICES FOR Z/OS

Issue/Introduction

Upload a *.cvs file to the 'SCRT Report Management' site scrt.broadcom.com and got the Validation error message. 
  
>>>
Validation error
The report did not pass validation. File modified or missing required data. File: 
*.csv 
<<<  
 
In the SCRT Report *.csv file there were a set of  ,,,,,,,, characters in each line inserted after the " character. 

Environment

Release : 15.0

Component : SCRT REPORT MANAGEMENT APPLICATION

Resolution

The extra commas at the end of each line is a telltale sign of an export from Excel. The 'SCRT Report Management' site scrt.broadcom.com does not accept exported Excel files because that act of exporting the file alters it and thus causes it to fail validation. 
  
If the OUTPUT data set in the ISV SCRT Job is transferred directly without the extra commas to the PC then the SCRT Report can be uploaded without problem to the 'SCRT Report Management' site scrt.broadcom.com