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

 pooja dash (Pooja Dash) Cognizant
Cognizant
IN
Pooja Dash Member since 2015 15 posts
Cognizant
Posted: Nov 10, 2017
Last activity: Dec 27, 2017
Posted: 10 Nov 2017 7:47 EST
Last activity: 27 Dec 2017 3:35 EST
Closed
Solved

Parsing Excel Usinf File Listener

Report

We have a requirement where File Listener should parse the excel file. The excel file is present in a specific folder and having data only. How to achieve this one?

Data Integration
Posted: 5 years ago
Posted: 10 Nov 2017 8:14 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US
Report

Hi Pooja,

Had you gone through this discussion which has some useful information about parsing excel file using file listener. Hope it might help you.

Regards

Mahesh
Posted: 5 years ago
Posted: 14 Nov 2017 7:26 EST
pooja dash (Pooja Dash) Cognizant
Cognizant
IN
Report

Thanks for the link.I  am able to achieve it by using MSOParseExcelFile as stand alone.What I am trying is to parse the Excel file using MSOParseExcelFile using a File listener.I am giving service Export path in pxRequsetor.pyFileName.But it seems File Listner is not getting the File or somewhere error is there. Please find the screenshots.
Posted: 5 years ago
Posted: 14 Nov 2017 8:21 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US
Report

@Pooja, i don't see any attachments being shared.

Accepted Solution

Posted: 5 years ago
Posted: 15 Nov 2017 14:12 EST
pooja dash (Pooja Dash) Cognizant
Cognizant
IN
Report

The issue was resolved .we got the path from LogServiceFile page of the File Listener.Thank you again.

 

 

 

Aravind chindanoor
Posted: 5 years ago
Posted: 27 Dec 2017 3:35 EST
Raj Kumar Teli (Raj_kumar) Virtusa Raj Kumar Teli
Virtusa
IN
Report
Hi Pooja, We are also having same requirement but unable to get path using file listner from LogServiceFile. we are getting java.io.FileNotFoundException. Could you please share configuration details you have done for your requirement.

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