Trying to read excel file from email listener. Getting an error pzUnrecoqnizedFile error

[Anoop_Krishna]

This is because system is not able to find the file. First store the file in service export directory, then use pxParseExcelFile activity to parse the file.

Import Excel data to case (and show them in Constellation UI)

This knowledge sharing article shows step-by-step configurations of how to upload an Excel file, parse the Excel data, and display them in a table using Constellation UI. Pega platform version used: 24.2.2 Configurations Step 1 - Create a data model. We created an Employee data object and the related fields. [10.png] Step 2 - Create an Excel template file (.xlsx) and the corresponding Binary File rule. Notice the .pxResults() notation to import more than one record and the keyword “input”…

In this post you will see the file being pushed to service export directory using pxCreateFile and then parsed.