Trouble downloading PowerShell Reports as Excel File in Sitecore

Fix for List-View and Out-Download Sitecore SPE reports

Sitecore administrators frequently use PowerShell scripts to streamline report generation and management. However, challenges often arise when attempting to download these reports as Excel files using the “Export to Excel” option in Sitecore PowerShell reports. Here is a list of errors you may encounter during this process:

1. An error occured while communicating with the Sitecore server:Failed to execute ‘send’ on ‘XMLHttpRequest Failed to load ‘https://yoursitecoresite.com/sitecore/shell/applications/powershell/powershelllistview.aspx?sid=70d25f80-21e7-416b-8f6f-f774d3a60a19'.

2. The page refreshed, but there were no changes or actions taken.

Get Prabhu Ranganathan’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

3. Empty error screens appear, showing no information or content, as illustrated below:

These are a few of the issues you might have encountered; there could be additional challenges as well.

Fix

Upon enabling Chrome DevTools and monitoring the console error logs, you may have observed the following error:

/login.aspx?ReturnUrl=/sitecore%20modules/PowerShell/Services/RemoteScriptCall.ashx?script=/&sc_database

If you’ve identified this error in your console, ensure that your Sitecore Content Management (CM) instance has the following settings in place:

1. Verify that the “Handle Download,” “File download,” and “Media Download” settings are enabled. If not, copy the configuration below and create a patch to enable them.
2. For Sitecore instances 9.1 or later, ensure that the “Spe.IdentityServer.config” is enabled in “App_Config/Include/SPE.” If it is not present, copy the configuration below and create the file.

3. In the worst-case scenario, confirm that you have the latest Sitecore PowerShell Extensions (SPE) module installed..

In my situation, I followed the same steps, and after implementing these changes, the export to Excel functionality started working smoothly.

I hope this helps to someone to resolve the issue!!

Disclaimer

• Sitecore PowerShell Extensions stands as a powerful tool. It is important to conduct comprehensive testing before deploying it in a production environment.
• It’s not advisable to install Sitecore PowerShell Extensions (SPE) in internet-facing scenarios or the DMZ. Avoid installing it on Content Delivery instances. Instead, adopt a strategy that grants the minimum necessary access. Secure the web server by allowing connections only to databases and preapproved web services.

For more detail, refer : https://doc.sitecorepowershell.com/

Happy learning !! Happy sharing!!