Question

8
Replies
1444
Views
Raj_kumar Member since 2013 2 posts
Incessant
Posted: 2 years ago
Last activity: 2 years 9 months ago
Closed

Unable to parse excel using MSOParseExcelFile from folder other than service export path

In our application, we get an excel file from external system in a mapped folder.
PRPC has read/write access to this folder. We need to parse this excel file and load the data onto the workpage.
We are using MSOParseExcelFile OOTB activity for this.

However, we observed that the activity works if the file is in service export folder and not when in any other folder.

The java step in the activity logs an error when we use a folder other than service export path.

java.io.FileNotFoundException: file://default:/Pega/InBound/IA2/GDWCSV

When we pass following file name to the activity -

/Pega/InBound/IA2/GDWCSV

But in the logs, Pega prints the filename by prepending it with "file://default:"

Has anybody come across this issue? Is there a different way to pass the file name when it exists on a mapped folder?

Your help in resolving the issue is highly appreciated.

Thanks in advance.

Rajkumar

Low-Code App Development
Moderation Team has archived post
Share this page LinkedIn