Cannot read file upload
Hi, I am trying to upload an excel xlsx file to later save it in a Data Type. I am using the pxParseExcelFile activity (Image 1) but it gives me an error of (Code-Pega-List)pzUnrecognizedFileTemplate UserSheetTemplate
Does anyone have any idea what is happening?
Pegasystems Inc.
IN
@ivanj843 Hi, Can you please check if you have given the name of template without any spelling mistake? Please copy it from the rule and provide it in your activity and check ?
Rabobank
NL
@ivanj843 Have you created an instance or a rule (Rule-File-Binary) . It accepts the file if it has a template defined in (Rule-File-Binary) class.
This activity accepts the file of the format and type. once you upload in this rule form of the class Rule-File-Binary.
Wipro
US
It seems that you are facing an issue with reading an uploaded Excel file in Pega. When you try to upload the file using the pxParseExcelFile activity, you are getting an error message stating that the file template is unrecognized.
One possible reason for this error could be that the file template you are using in the activity does not match the actual format of the Excel file you are trying to upload. Another reason could be that the file is corrupted or in an unsupported format.
To resolve this issue, you can follow these steps:
It seems that you are facing an issue with reading an uploaded Excel file in Pega. When you try to upload the file using the pxParseExcelFile activity, you are getting an error message stating that the file template is unrecognized.
One possible reason for this error could be that the file template you are using in the activity does not match the actual format of the Excel file you are trying to upload. Another reason could be that the file is corrupted or in an unsupported format.
To resolve this issue, you can follow these steps:
- Check the file format: Make sure that the Excel file you are trying to upload is in a supported format. Pega supports .xls and .xlsx formats.
- Verify the file template: Check that the template name you are using in the activity matches the actual template name in the rule. It's recommended to copy the name directly from the rule to avoid any spelling mistakes.
- Check the file template configuration: Ensure that the file template you are using in the activity is properly configured in the rule. The rule should define the columns and data types that match the actual Excel file being uploaded
- Verify the file content: Double-check that the Excel file you are trying to upload is not corrupted or contains any unsupported data types or formatting.
- Test with a different file: If the issue persists, try uploading a different Excel file with a different template to see if the issue is with the specific file you are trying to upload or with the activity configuration.
Regarding the questions and comments asked/made by the others, the pxRequestor.pyUpload property is used to store the uploaded file in Pega. Checking the name of the file template and ensuring that it matches the rule is important, and creating a Rule-File-Binary instance or rule is necessary for the file to be accepted by the activity.
As for the behavior of the file upload on different platforms, Pega's file upload functionality should work the same way on any platform, including Android and iOS.
I hope this helps! Let me know if you have any further questions or concerns.