Import & export of items
Batch importing and exporting items for a given Instance
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.
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 |