FORUM CTRLX AUTOMATION
ctrlX World Partner Apps for ctrlX AUTOMATION
09-15-2021 02:39 PM
I understood that trend variables are configured inside the Recorder Manager and the values are stored inside a sqlite database. How do I get access to the recorded data in case of the WebIQ Server is running on the ctrlX CORE or on a PC? Can I export the data into a csv-File?
Solved! Go to Solution.
09-15-2021 03:01 PM
You do not have access to the ctrlX file system so you cannot access the database directly.
We are currently evaluating a CSV export functionality as a standard feature of an WebIQ HMI app in the form of a widget.
However, if you require this feature right now we could implement this as a custom feature. If you are interested in this please send me am PM.
09-15-2021 04:44 PM
Thanks for the fast answer 👍
The realization of the application is planned for the middle of next year. If the feature would be available then, this would be sufficient.
01-26-2022 09:25 AM
It will be availabe we are working on it
Kinde regards
webiq-eg
03-02-2023 05:46 PM
Hey! Just following up on this.
You said this widget should be available now. Is this something that comes with WebIQ or is there a seperate download? I am on the latest version and cannot find this feature.
11-03-2023 02:29 PM
Hello Team,
I am also looking for the CSV download widget, could you please help how I can install in my HMI setup?
Thank you
11-03-2023 02:34 PM
You can simply add the UI-Action "trend-export" to a button - this will show a dialog to download trend data in JSON format. You can then convert this to CSV using this free tool: https://www.smart-hmi.com/user/download/deliver/xmp/Additional%20Software/webiq-trend-export-to-csv-...
11-03-2023 02:36 PM
Thank you for the reply so i understand that thsi is the only way to get the CSV file! the widget of directly exporting CSV from webIQ is not yet implemented?
11-03-2023 02:39 PM
Actually JSON data is better structured data than CSV and therefore better suited for using this in automated processes than the very old CSV format. As the tool has been written in JavaScript you should be able to write a custom UI Action that might do the job for you from the HMI.
Out of the box this is not supported by WebIQ.
11-03-2023 03:01 PM
Thank you again for the quick answer. Then could you please suggest me a tool which can be easy for the end customer to export the data from the trend as JSON and make a graphical chart available offline?
11-03-2023 03:03 PM
As mentioned before you can simply add the UI-Action "trend-export" to a button to download the JSON file.
I cannot answer the question related to software as this is outside of the scope of WebIQ.
11-06-2023 09:39 AM
Here you find a example how to create & download a CSV file, via JS.