Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rashmitha Madireddy (RashmithaM)
WillisTowerWatson
Rashmitha Madireddy
WillisTowerWatson
US
RashmithaM Member since 2014 14 posts
WillisTowerWatson
Posted: Jul 14, 2020
Last activity: Aug 7, 2023
Posted: 14 Jul 2020 12:41 EDT
Last activity: 7 Aug 2023 10:35 EDT
Closed

pxparseexcelfile-not-parsing-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.

Could some one help me on this issue.

***Edited by Moderator: Pallavi to change content type from Discussion to Question***  

To see attachments, please log in.
Pega Platform 8.3.1
System Administration
Updates
Other Industry
Senior System Architect

Posted: 4 years ago
Updated: 4 years ago
Posted: 4 Aug 2020 17:43 EDT
Updated: 5 Aug 2020 8:11 EDT
Rob Jago (Rob_Jago)
Serialized Solutions Inc
Pega Certified Senior System Architect
Serialized Solutions Inc
CA

Hi RashmithaM

Does anything show up in the PegaRules.log?

How many header rows does the spreadsheet have?  what parameters are you calling pxParseExcelFile with?

Does the trace provide any indication/odd data elements?  do any errors within the pxParseExcelFile activity call show up?

 

thanks,

 

Rob

To see attachments, please log in.
Posted: 4 years ago
Updated: 4 years ago
Posted: 28 Aug 2020 14:31 EDT
Updated: 28 Aug 2020 14:32 EDT
Madan Kumar Prakash Murthy (Madan Kumar P)
HCL Technologies B.V.
Senior Technical Lead
HCL Technologies B.V.
NL

Hi Rob,

PFA docs for all the questions asked, quicker remediation is much appreciated.

 

Excel has 4 tabs and all 4 tabs have single header

To see attachments, please log in.
Posted: 4 years ago
Posted: 28 Aug 2020 15:18 EDT
KrishnaChaitanya Gaddipati (KrishnaChaitanyaG16918484)
Lantiqx
Lead System Architect
Lantiqx
GB

Hi Madan,

We got the same error message when there are some invalid references in excel. I would suggest try with one sheet first or just one column and one row, then you can keep on adding columns and sheet.

I know this is tedious process, unfortunately I could not think of any better way as of now. May other will come with smart way.

Thanks

Krishna

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice