Question
Infosys
IN
Last activity: 20 Dec 2019 0:37 EST
MSOParseExcel not working
We have a requirement to import an excel file data from portal screen and then save it to a data table.We used MSOParseexcel activity for the same but its throwing error while executing.
Code-Pega-List)pzUnrecognizedFileTemplate DebitorTemplate this is the error we are getting.
the filepath given is pxProcess.pxServiceExportPath+@whatComesAfterLast(Param.hiddenFilePath,'\\')
if give pxRequestor.pyFileUpload then it will works sometimes but the file may not be present at this location and its being present in the path provided above only but its not working..
kindly help in resolving this
***Edited by Moderator: Lochan to update platform capability tags***
Accepted Solution
Infosys
IN
Hi all the issue got resolved using the control pzFilePathWithForm
Pegasystems Inc.
IN
Check this link:https://collaborate.pega.com/question/uploaded-file-template-could-not-be-recognized-please-upload-valid-file
Pegasystems Inc.
IN
Hi,
Which version of PRPC you are using. Also what is the format of excel file, is it xlsx or xls.?
Please send us the exact error trace.
Thank you,
Geeda.
Infosys
IN
We are using Pega 7.4 version
the excel file format is xlsx
DebitorTemplate.xlsx
attaching the tracer error also
Kindly help in fixing this error.the path name given is pxRequestor.pyFileupload but the file is not present at run time.it will be present if i follow the path
Designer-->application-->distribution--->import but its not the ideal way we have to upload the excel from screen itself.
CommonWealth Bank of Australia
IN
Hi,
Could you please confirm whether you have uploaded the template as binary file and whether it is present in the path, since the error message states that the template is unrecognized?
Thanks,
Infosys
IN
that is the issue we have uploaded the template as binary file but its not in the Path provided "pxProcess.pxServiceExportPath" and in pxrequestor.pyFileupload also but if i manually try to import using designer-->application---.distribution--->import then the file will be in pxrequestor.pyFileupload but at run time the file is not there in any of the paths
Pegasystems Inc.
IN
Hi,
In MSOParceExcel activity you are passing the parameter for template file as binary file right?Please try uploading the template file by changing the column values and check the scenario.
Pegasystems Inc.
IN
Hi,
If you are uploading the excel file using AttachFile control then providing the path as "pxRequestor.pyFileUpload" works properly.
Try implementing AttachFile control and provide the above property as path.It works.
Infosys
IN
Hi Thaks for the reply,
could you please elaborate on the steps for implementing this control because when i tried with the same still i am getting the same error i am attaching the screens for my configuration kindly valuate that and provide your comments as this requirement is very much important for us