cancel
Showing results for 
Search instead for 
Did you mean: 
SOLVED

WebIQ: How do I get out data from recorder manager / trend?

WebIQ: How do I get out data from recorder manager / trend?

LunatiX
New Contributor

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?

11 REPLIES 11

webiq-sk
Frequent Contributor

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.

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.

webiq-eg
Long-established Member

It will be availabe we are working on it

Kinde regards

webiq-eg

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.

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

webiq-sk
Frequent Contributor

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-...

 

Tasty_Tech
Established Member

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?

webiq-sk
Frequent Contributor

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.

Tasty_Tech
Established Member

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?

webiq-sk
Frequent Contributor

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.

HmiGuide
Community Moderator
Community Moderator

Here you find a example how to create & download a CSV file, via JS.

Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist