Can we import ExcelReader.jar package ( java based PRPC utility to upload large excel files) into our application.
This is required for our BULK Excel Upload implementation.
Please find below for our Environment details:
PRPC 718 - CRM - HCIF - CRMHC.
***Edited by Moderator Marissa to update SR Details***
We are looking into the import function like this! This will be way cool and seems to be out of the box functionality for pega. (Excel processing code has been written in java and packaged in jar file with name “ExcelReader.jar”.
PFA for the Bulk Upload Utility for multiple excel files details in the above mentioned guide.
To clarify, Pradeep is looking into using the ExcelReader.jar package in a Pega CRM / HCIF / CRM for Healthcare stack. However, this code is an external JAR component of the Pega Underwriting for Insurance (PUI) application and may still be unable to be retrofitted in this manner. Perhaps an enhancement request would be in order to broaden this component's use outside the specific pega application which currently utilizes it.
Hey Pradeep- We own this code. We use Apache POI API to process large excel sheets using dynamic column mapping instead of static template based import. The is specific to PUI but the core java classes written to process excel sheet are generic.
Let me know your use case once so i can guide you using it properly.
On a side note we were actually planning to remove the PUI flavor from it and trying to make it a generic component and publish
Yes, that can be re-used into your app. Along with the java changes there are some pega side changes to be implemented. If you have access to any latest PUI application, you can follow the implemenatation guide for the full details.
I can't tell the ETA cause we are working on PUI 7.4 now and need to find some time to get this time. Need to talk to @Phil Monahan and @Karthikeyan Ramachandran
However @Babar Neeraj have the same requirement for one of their apps too. WIll try to allot some time today and provide you the jar file. Also there is a doc which has the technical implementation details of bulk upload. will share that should help you.
Please note the attached doc is not full it helps you to get to start with the utility