Exporting the Bert device information from the Bert Connect Gateway - Metasys - LIT-12013511 - Bert plug integration - Bert Plug Load Control - 10.1

Bert Plug Load Control and Metasys Integration Guide
Product
Integrations > Bert Plug Integrations > Bert Plug Load Control
Document type
Integration Guide
Document number
LIT-12013511
Version
10.1
Revision date
21/02/2020

Two necessary pieces of information are needed from the Bert Connect Gateway: the names of the Bert devices and their respective BACnet instance IDs. Conveniently, you can export this information from the database on the Bert Connect Gateway and use it to populate the RAC schedule.

  1. There is a SQL database client on the Bert Connect Gateway called SQLyog. Open this client and connect into the database using the already-populated values.
  2. From the tree view, expand the Bert_bacnet_server and click on Bert.
  3. From the main menu bar, go to Table > Export / Import > Export Table Data > As CSV
  4. Save the CSV file. This file contains several columns, but the main ones you need are the names in column D and the BACnet instance numbers in column M. The instance numbers in column M are in hexadecimal format and must be converted to decimal. This can be done in Excel using the Hex2Dec() function.