Question
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
This activity MSOParseExcelFile is called when user clicks "Import" to import an excel file. Also called from "Attach Project Sizing to Application" of Sizing Wizard.
Wonder if you can use some filelistener instead.
A Rule-Service-File and listener will get the file into your application, but can't easily parse XLS (Excel 2003) or XLSX (Excel 2007) files.
The easiest Excel format to parse is CSV files:
http://pdn.pega.com/DevNet/PRPCv5/KB/25485.asp