Get Free Trial

Headless Export Excel Issue

Answered
Scott Oliver asked on August 30, 2021

Hello,
 
On the 23rd of August at roughly 11:30 CET we started to experience issues with the headless export of flex reports using your solution with puppeteer.
 
Reports which had previously been producing fine would either fail to open (corrupt file) or open in a broken format, depending on your spreadsheet client. No update or changes to the flex or puppeteer versions/source were made on our end.
 
The attached pivot javascript file produces an example of this. Could you please help us identify why this is now broken and how to resolve? Through our own investigation it appears that removing the slice fixes the issue, but as you can understand we need the report to display as is.
 
Not all reports are experiencing this issue. There are other reports with different data sources (still JSON), but different mapping, grid, formats and slices that are experiencing the same problem.
 
An urgent response and solution would be greatly appreciated.

Attachments:
pivot.js

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster August 30, 2021

Hello, Scott,

Thank you for reporting this issue.
We want to explain that this is a known problem with Excel export, which will be fixed in the nearest minor ETA Sept 7.
As a temporary workaround, we recommend downgrading your Flexmonster version to 2.9.5 until the fix is introduced. It is achievable by specifying the desired version in the script tag and component folder placed within the HTML file:

<script src="https://cdn.flexmonster.com/2.9.5/flexmonster.js"></script>
...
componentFolder: "https://cdn.flexmonster.com/2.9.5/",
...

 
Please note that you will also need to specify the license key explicitly since older versions do not provide a trial key by default.
 
We will notify you as soon as the issue is fixed.
 
Best regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster September 7, 2021

Hello,
 
We are glad to inform you that the issue with exporting data with “/” symbols to Excel was fixed.
This is provided in the 2.9.7 version of Flexmonster: https://www.flexmonster.com/release-notes/.
 
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Feel free to write to us in case of questions.
 
Best regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 1 day ago

Hello,
 
We are wondering if our recent fix helped with the export issue.
 
Looking forward to your feedback.
 
Kind regards,
Illia

Please login or Register to Submit Answer