How to export pagelist from Clipboard tool to excel/csv?
Hi,
do you have any suggestions or do we have any reusable stuff to export pagelist, displayed within Clipboard tool, to an excel/csv file?
Thanks in advance,
Giuseppe
Message was edited by: Vidyaranjan Av | Included category
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
PEG
PL
Below is the answer given in the above link shared by Haritha Damarla
----------------------------------------------------------------------------------------------------------------------------------------
i created my own activity in which i cam calling pxConvertResultsToCSV activity by giving step page of type code-pega-list. Then passing pxResults as parameter for list property for this activity.
On button click,I am refreshing the section by calling my own activity.
Below is the answer given in the above link shared by Haritha Damarla
----------------------------------------------------------------------------------------------------------------------------------------
i created my own activity in which i cam calling pxConvertResultsToCSV activity by giving step page of type code-pega-list. Then passing pxResults as parameter for list property for this activity.
On button click,I am refreshing the section by calling my own activity.
Pegasystems Inc.
IN
Accepted Solution
PEG
PL
Below is the answer given in the above link shared by Haritha Damarla
----------------------------------------------------------------------------------------------------------------------------------------
i created my own activity in which i cam calling pxConvertResultsToCSV activity by giving step page of type code-pega-list. Then passing pxResults as parameter for list property for this activity.
On button click,I am refreshing the section by calling my own activity.
Below is the answer given in the above link shared by Haritha Damarla
----------------------------------------------------------------------------------------------------------------------------------------
i created my own activity in which i cam calling pxConvertResultsToCSV activity by giving step page of type code-pega-list. Then passing pxResults as parameter for list property for this activity.
On button click,I am refreshing the section by calling my own activity.
Personal
IN
Hello,
By Using the way you suggested i am getting only the page properties in excel file,i am not able to get the pageList propeties how to achieve that any suggestions?
Thanks
Aakash Talreja
Pegasystems Inc.
IN
Ernst & Young LLP
IN
call MSOGenerateExcelFile on a button.
In Param 'FSFileName' give name of the generated file for eg. "Test.xlsx".
In Param 'TemplateRFB' give name of a binary file for eg. "Excel!Test!xlsx".
In this binary file upload a excel sheet which contains property references for its columns like {.pageListName().PropertyName input} .
Then click the button on the UI.
LTI
IN
Hi,
I have followed your mentioned approach for generating the Excel file from Page List. But, i am getting an Error saying "No Stream to display". What could be the reason.
Please find the attached Screen print:
any help would be appreciated.
Thanks,
KSR Prasad
Virtusa Corp.
US
I tried this approach for a simple Code-Pega-List and it worked fine. Now my question is if I want to export multiple cases and each case has nested lists would this work? For example inside the case apart from case properties I have a list of items.In this scenario generated file was empty. I'm not sure if the method I did it was wrong or that this approach won't fit into that scenario where you have nested lists. Please let me know
Mastercard
IN
Hi,
Did you find a way to export multiple cases and each case has nested lists? would this work? If yes can you please share the steps or syntax?