Question
MSOGenerateExcel not downloading from On click of Button, but it works from backend activity
Hi All,
We have a requirement, where we need to download the results from a clipboard Page to an excel on click of a button.
Current approach, I have configured a button click and on click calling an activity which is running MSOGenerateFile method. Now, when i click on the button and trace it, it runs correctly however no excel gets downloaded.
But, if i directly run the activity on the case from backedn it downloads the excel correctly.
Can you please assist. I have also attached a in detail document with all the screenshots.
Also, if there is any other approach please suggest
Hi
Can you try the approach suggested in this SA?
https://community.pega.com/support/support-articles/custom-export-excel-button-only-works-once
What Actions have you configured on button click?
Is it only "Run activity" or "Refresh-This Section" and passed the activity name to download the excel?
P.S. - MSOGenerateExcel is now depricated, you can use pxGenerateExcelFile instead.
On Button click configure event "Open URL In Window" , In that call your activity "MSOGenerateExcel" or the activity contains "MSOGenerateExcel".
Verify Once whether all required parameters for MSOGenerateExcel are passed.
I attached screenshot for your reference.
Regards,
Bharathan.
Hi,
From your screenshots I see that you have a message -
This activity can only be called from another activity because the "Allow direct invocation from the client or a service" is disabled on the security tab.
So if you try checking the following checkbox from "Security" tab of the activity and retest to see if that works