Question
Northwest Missouri State University
US
Last activity: 10 Oct 2019 6:28 EDT
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
Pegasystems Inc.
US
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
Northwest Missouri State University
US
Hi,
I have tried this approach even then i face the same issue.
Pegasystems Inc.
US
Hi
Can you try the approach suggested in this SA?
https://community.pega.com/support/support-articles/custom-export-excel-button-only-works-once
Barclays
IN
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.
Tekclan Software Solutions
IN
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.