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
Pegasystems Inc.
IN
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
Virtusa
IN
Hi , Thanks for quick response.
Activity (MSOParseExcelFile ) works fine if the file is in service export folder and not when in any other folder.
Only issue when placing file at other location.
As per our application requirement we have to read this file from shared location and parse it
Pegasystems Inc.
IN
Hi Raj,
My point here is the OOTB MSOParseExcelFile is intended to parse from ServiceExport directory only. Hence I recommend you not using this for other directories. Instead you can use a file listener.
Pegasystems Inc.
IN
Hi Raj,
Probably, what you can do copy the file from the shared path to this ServiceExport directly and then use it accordingly. May be the below post can help you out.
https://pdn.pega.com/community/product-support/question/copy-directory-one-location-another-location
Virtusa
IN
In case of file listner how can i pass file path(FSFileName) to MSOParseExcelFile activity.
Virtusa
IN
Hi kakul,
I have tried with file listner and getting same error.
The java step in the activity logs an error
java.io.FileNotFoundException: file://default:/Pega/InBound/IA2/GDWCSV
I have used below folder location for listner and OOTB activity.
Source location in file listner :- /Pega/InBound/IA2/GDWCSV
And same path provided for FSFileName (/Pega/InBound/IA2/GDWCSV) while calling MSOParseExcel Activity.
Please help in resolving this issue.
Virtusa
IN
Anyone who can help me in this issue ?or is there any other way to access Sub directory using MSOParseExcelFile activity?
Virtusa
IN
We are still unable to get file path while calling MSOgenerateExcelFile using file listner.
We have changed requirement and now we are uploading file using browse and that is working, but unable to do with file listner.