I have anEasyChart being used in a trending Window and the ‘Save…’ Button with the disk on it does not work, it only outs an incomplete XML file. I would like to fire a custom event handler script to handle our custom needs better…is this possible to make a custom handler for this button?
Hi @lrhyrne - Are you still seeing this issue?
If so, can you let us know what version you are using and what the XML file is?
Yes, still prevelant issue. Ignition verison 7.9.8. The ‘Save’ button is supposed to create an MS Excel file with tabular raw table data contained in the originating easy chart… I may have made an error saying xml by mistake. After testing just now, it is actuallly a XLS file. The saved file ends up being 2kb and gives several file validity errors when trying to open…ultimately fails.
When pressing the Save button, is the Client/Designer generating any errors in the console?
No messages at all in the console (I cleared it fresh before even opening the window with the chart on it.
After it exports the file, there are two errors when attempting to open it in Excel:
Then after I select ‘Yes’ to open it anyway, I get this:
I hear this issue is fixed in Ignition 7.9.9? Is this true?
Hi. Im having the exact same problem.
I try it with Ignition 7.9.8 (b2018060714) and Excel 2013, same problem using Ignition 7.9.10 and 7.9.12.
We have another client with Ignition 7.9.10 and office 365 and it works fine. So im guessing it has to do with Excel. Have you found something else?. We wanted to recomend our client upgrading to the next Ignition Version. But probably its gonna have the same issue as long as the client is using Excel 2013.
I am using MS Office 2016 and Ignition 7.9.12. No solution found yet.
Unfortunately, a direct solution was not found. But, we were able to use existing Reporting module to export and email the data to the person who regularly desires it.
I did this workaround and it worked for me, on excel 2013. I had to add a new button on top of the old one with this scripting.
chart = event.source.parent.getComponent(‘Easy Chart’)
datasets = chart.exportDatasets()
component = datasets
spreadsheet = system.dataset.dataSetToExcel(1, [component])
filePath = system.file.saveFile(“Name”+system.tag.read(“today_string_date”).value, “xls”," Excel Worksheet(97-2003)")