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
  • Items

Import & export of items

Batch importing and exporting items for a given Instance

Written by Ioannis Panteleakis

Updated at January 18th, 2022

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:

  • Add Items
  • Item parameters
  • Edit items
  • Import & export of items

Items can be exported and imported for each instance as comma separated CSV. This can be used for backups and bulk inserting of items.

To access the item import and export tool for a given instance navigate the SIA Connect portal‍ as follows:

  • Navigate to Instances
  • Find the desired instance
  • Click on Bulk items and a popup will show up providing the following options:
    • Template: fetch the item structure for the specific instance
    • Export: export items to CSV
    • Import: import items from CSV


Exporting items as CSV

Items for an instance can be exported by clicking on the Export option on the instance page. The exported file is in CSV format, where the columns/fields are semicolon separated. The export format is the same as used for importing items.


Importing items from CSV

Items can be imported from a CSV file by clicking on the Import option. To ensure compatibility with the specific instance, the CSV file needs to follow the same item structure given by the Template option.

Delete

The items in the CSV file are added as new if they don't already exist in the Instance, otherwise the item values from the CSV file are updated into SIA. 
Each item is matched by the item UID first and then the item name.


Template for importing & exporting

The template for the import & export item structure can be downloaded as CSV by using the Template option.

The CSV file format is semicolon separated and the first row contains the list of all the fields related to that item. For example: name; description; uid; read interval; plugin related fields and so on. These fields, being the same as in Item parameters‍.

Values for fields corresponding to drop down menus are enumerated starting from 0.

As an example, for the Mode drop down parameter:

Option CSV value
Device default 0
Gateway 1
Logging 2



items export import csv

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Item parameters
  • Add Items
  • Edit items

0
0
Expand