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.
⋅ 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
⋅ 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
⋅ September 15, 2021
Hello,
We are wondering if our recent fix helped with the export issue.
Looking forward to your feedback.
Kind regards,
Illia
⋅ September 17, 2021
Yes, all resolved with the update, thank you!
⋅ May 11, 2022
Hello Illia,
Long time no speak, hope you are well. Just checking if you have any instruction to help us install this on an Apple M1 machine (ARM)?
Appreciate your help,
Scott
⋅ May 11, 2022
Here is the log file from the attempted installation with Node V14.9.2 (as it is ARM compatible).
⋅ May 12, 2022
Hello, Scott!
Thank you for reaching out to us.
At a moment, our team is not aware of any specific ARM-related issues while using the pivot-puppeteer project. However, we suggest trying the following steps to solve the issue:
puppeeteer library.npm cache clean --force
Hope you will find this information helpful.
Best Regards,
Maksym
⋅ May 24, 2022
Hello, Scott!
Our team is wondering whether you solved the issue with running our pivot-puppeteer project on your machine.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ June 2, 2022
Hey Maksym,
Yes, upgrading puppeteer to the latest version fixed the issue. Thank you for your suggestion.