How to parse data from an excel file attached to a work object in Pega 7.4
I have a requirement using Pega 7.4 to parse data from an excel attachment,which is attached to a work object and map the data to clipboard property values, which is then displayed in a section
The first thing, i would like to do is to get the location of the file attachment, so i tried searching the for the property used to store the File Path ,unfortunately could not find the pxRequestor.pyFileUpload in version 7.4.
The activity MSOParseExcelFile is also not there in Pega 7.4, which would have been of great help.
Has anyone tried and succeeded to parse csv data in 7.4?
MSOParseExcelFile is still available in 7.4. It is marked as internal though so you will need to modify your operator preferences to search for it. Click on your operator image, select Preferences, and check the 'Enable diagnostic features' option.
MSOParseExcelFile will handle uploaded files from a control that are in the service export directory. It is very easy to modify that activity to take a work attachment as the source instead. In my example below, I savedas to an activity called MSOParseExcelFromAttachment and modified the java in step 3 (see added lines 20-22) to source from a work attachment.
What should be pass as parameter values for xlStreamPage and pyAttachStream. Tried using the java code but it is throwing NullPointerException when executing the MSOParseExcelFile activity. Using Pega 8.1 version to test.