Question
Srinsoft Technologies
IN
Last activity: 30 Dec 2019 18:35 EST
pxParseExcelFile not parsing the file
I'm trying to replace MSOParseExcelFile with pxParseExcelFile (Pega 8.2).Though it executes without error, I couldn't find any data after parsing the excel (with one sheet).
FSFileName and TemplateRFB are passed as I did for MSOParseExcelFile rule.
Anyone tried this? Anything I'm missing here or its a bug in the activity?
-
Like (0)
VINEETH KICHILU -
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Coforge Limited
US
I am also running into this issue. The FSFileName is provided as pxRequestor.pyFilePath after uploading an Excel document through the FilePath control (PegaGadgets:8-01-01) with .pyFilePath listed as the target property of the control, and the TemplateRFB being passed in is present in the application. Both follow the same formats previously needed for the MSOParseExcelFile activity.
After running this activity with the above inputs and performing an Obj-Save on the page it was run on as well as the page provided for output (outputPageName), there is no data present. These pages are both of the same class. My tracer displays no warnings, errors, or fails when it is run during this process.
Where exactly on the clipboard would the parsed data be written to if not the outputPage or the page the activity was run on?
Srinsoft Technologies
IN
I'm not sure if anybody tried it yet. It would be good if Pega can confirm if its a bug or not.
Tech Mahindra Ltd
IN
Hi ,
The pxParseExcelFile seems to be working fine. To answer to your question to where on clipboard we can see the parsed data -- We can see that under pyWorkPage-->pySheets.
Tech Mahindra Ltd
IN
Also, attached is a sample document for making a simple pxParseExcelFile .
Thanks
-
Raghavender Reddy Lankapothu Nivedha Kennedy Nagender Ponugoti Lasika Liyanage Rajesh Mulakalapalli and 2 More
Updated: 22 Aug 2019 22:18 EDT
Tech Mahindra Ltd
IN
Please mark the answer as Helpful as the related SR is now closed for the same.
Thanks
Srinsoft Technologies
IN
SR resolved by showcasing how it works. Below is what I observed.
In MSOParseExcelFile, we pass the Template RFB parameter within quotes.
But for pxParseExcelFile, we shouldn't be using quotes for that parameter. It started working after quotes has been removed.
If we parse by sheets, the output will be under PageName->pySheets->List. If we dont use sheet name to parse, it will be PageName->List (Similar to MSOParseExcelFile)
Hope this helps.
Tech Mahindra Ltd
IN
Thanks for the confirmation Saravanan.
StateFarm
US
when i try to run the parseexcel utilty i am getting the following message in error
Could not get clipboard property for reference Sheet1. Reason is 0
what does it mean. Why the values are not getting populated from the Excel to clipboard. Will this only work on the case context and not as a separate harness?
MSOParseExcel is not this strict when it comes to templates or parsing.