Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Home
  • Knowledge base
  • Contact Us
  • Home
  • Configuration in the Web UI
  • Data

Export historical stored data

How to export historical data from items into CSV file

Written by Mads Mikkelsen

Updated at February 8th, 2021

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Installation & Technical information
    Introduction SIA Connect Standalone SIA Connect ANY-Ware Cellular & WiFi connectivity
  • Configuration in the Web UI
    Getting started with the UI Connectors Instances Items Mapping Data System Network Tools & Add-ons DigiCert IoT Trust Manager
  • Connectors
    Siemens S7 Azure IoT Ethernet/IP Mitsubishi MELSEC OPC-UA Server SQL MQTT Omron Host Link REST API Omron FINS Keyence Beckhoff TwinCAT BACnet Virtual OPC-UA Client MS SQL File M-Bus Modbus
  • Scripting & Variables
    Data formatting
  • Developers
    API documentation Shadow API
  • Tutorials & Guides
    InfluxDB AWS IoT Core - Amazon Web Services Microsoft Power BI KaaIoT Siemens S7 AVEVA Insight SIA Connect Demo Rack Grafana Azure
  • General
+ More

Articles in this section:

  • View historical stored data in graph
  • Export historical stored data
  • Enabling data logging mode

An item can be configured to store and log the data. This data can be exported in CSV format in the portal.

To export the data of items to a CSV file:

  • In the SIA portal go to  Instances
  • Go the desired  Instance where you want to view the data.
  • In the items table click the  Export to CSV button. A dialogue will open.
  • Pick a time the data needs to be between by typing in manually or clicking
  • Select the items which data you want to export.
  • To export the data in click Export


The format of the CSV file is in the following format:

Item 1;; ...
Value;Time; ...
"11";8/2/2021 15:02:39.397; ...
"10";8/2/2021 15:02:38.025; ...
...


Warning

Exporting too much data can make it stall. We recommend break it up into smaller chunks.






Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • View historical stored data in graph

0
0
Expand