Pega 7.2:Issue with MSOParseExcelFile, The uploaded file template could not be recognized. Please upload a valid file. Refer to template Entity_template for details.
i am trying to parse an excel file using MSOParseExcelFile OOTB activity and getting below error.
The uploaded file template could not be recognized. Please upload a valid file. Refer to template Entity_template for details.
Error log:
java.io.FileNotFoundException: file://default:/web/StaticContent/global/ServiceExport/EntityDetails.xlsx
at com.pega.pegarules.pub.util.PRInputStream.<init>(PRInputStream.java:99)
at com.pega.pegarules.pub.util.PRInputStream.<init>(PRInputStream.java:92)
But i have given Pathe like below
"file://web:/StaticContent/global/ServiceExport/EntityDetails.xlsx"
I have imported the file using Designer Studio=>Application=>Distribution=>Import
and i tried also giving file Path as "D:/test/xxx.xlsx" but no luck..
Appreciate for your reply..!
Thanks!
***Edited by Moderator Marissa to update platform capability tags**
Telecom Italia S.P.A.
IT
Hi,
With Pega 7.2.1 I have solved this problem using this path:
- LogServiceFile.pyOriginalDirectory + "/work_" + "File Listener Name"+ "/" + LogServiceFile.pyWorkFileName
Thanks,
V.