Import Excel and show data on screen - Pega Infinity

General
, , , ,
1

Hi everyone,

We have a requirement wherein an user can upload an excel file (using Attachment field type). The uploaded excel needs to then be parsed into a pagelist and displayed on the next screen.

I do understand than MSOParseExcel is now replaced with pxParseExcelFile but I am not able to figure out how can be dynamically pass the path to the param FSFileName. The value at “pxRequestor.pyFileUpload” is empty but on running D_pxCaseRelatedContent I can see the attachment.

Can someone please help me with getting the attachment path?

Also, assuming we achieve this parsing, what would be the best way to present this data on UI and allow users to add more data to the list? (data reference OR embedded data OR some other)

P.S. I am using Pega Infinity 23’ community edition for this POC.

Regards,

Saurabh Gupta.

2

@SaurabhG7134 for this requirement, we have ootb flow action to implement this.

Flow action-> pxUploadcsvResults

You just need to pass class, pagename, pagelistproperty as parameter.

3

Hello @Anoop Krishna, thanks for this one, but since it’s an OOTB flow action using a section, can you please provide a one which uses “views” instead? As per my analysis of this section, I understood that the control within the section is populating the pyFileName thus, if I try calling it’s post activity directly in my flow action which is view based, I am getting this error -

Can't continue with file upload. "" is not a file. 
4

@SaurabhG7134 okay. Then I think we would like need to publish a new component to constellation server to use that filepath upload control. Not sure if we have ootb view using filepath upload control.

5

Hi @MarijeSchillern can we have an SME to answer this please?

6

@SaurabhG7134 please clarify the issue - is this specific to Constellation?

If it is for Constellation, can you post a new question specifically tagging Capability Constellation and provide examples and steps followed?

If it is not Constellation, can you confirm you’ve seen the documentation below?

Activities for integrating Cases with Excel documents

How to build uploading Excel file function

Reading Excel sheet attached to email using email listener and copy data to Clipboard for processing

How to use MSOParseExcelFile and MSOGenerateExcelFile

Handling files thru User Interface

My own research found details of the following product limitation, which has been logged as a future product enhancement .

FDBK-84346 (Need support to parse excel using AttachStream)

The activity pxParseExcelFile takes FilePath as the input and parses the excel.

In constellation, the attachments are supported using Attachments type property. This stores the attachment as instances of Data-WorkAttach-File and the attachment stream is available in pyAttachStream property.

Need OOTB support to parse the excel file using this AttachStream data

—> If this is the same as your issue please mark this as the accepted solution and you can contact your Pega AE if you need to discuss the FDBK further.

@ArunSarada and @KenshoTsuchihashi can you comment on the original question of this post?