Downloading Excel Template option is not working
SummaryWhen user downloads an Excel template from a binary file (Rule-File-Binary) and after populating the excel sheet with required data, an error is thrown while uploading and parsing the excel file within Pega.
Error MessagesError Messages:
Errors: ** The uploaded file template could not be recognized. Please upload a valid file. Refer to template ExcelFileTemplate for details.
Steps to Reproduce
- Create a Binary File and upload an xlsx file format template.
- Download the Empty Template in the Work Flow.
- Update the data in the Excel file.
- Try to upload the updated excel file using FilePath Control. Error Message appears on processing of the assignment.
Root CauseAn issue in the custom application code or rules: Pega removes any pre and post white spaces of the column name in template file.
ResolutionPerform the following local-change:
Update template column names to ensure there is no white space appended or pre-pended.
Published January 30, 2017 - Updated February 13, 2017