Use a Property Translation Table to Configure Automatically Created Points

Rather than configuring common properties manually on the points that Geo SCADA Expert is to create automatically, you can use a Property Translation Table to specify the settings that are required.

To use a Property Translation Table to populate the configuration properties of automatically created points:

1. Create the content for each Property Translation Table outside of Geo SCADA Expert. The content has to take the form of a TSV file (see Create the Content for a Property Translation Table).

2. Create an MQTT Sparkplug™ B Property Translation Table item in the database for each Property Translation Table file that you want to store and use in Geo SCADA Expert (see Configure an MQTT Sparkplug™ B Property Translation Table).

3. Use the Import Property Translation Table pick action on each MQTT Sparkplug B Property Translation Table to import the relevant Property Translation Table files into the database. (You can store one file per MQTT Sparkplug B Property Translation Table item in the database.)

4. Use the Last Import Status attribute to check whether the TSV file has been imported successfully into the database.

5. Address any issues if the attempt to import the file did not succeed and then reattempt the import (see Create the Content for a Property Translation Table).

6. Edit the configuration Form of each MQTT Sparkplug B EoN Node or MQTT Sparkplug B Device for which Geo SCADA Expert is to automatically create a suite of points. Populate the Property Translation Table field on each Form with the name of the MQTT Sparkplug B Property Translation Table that is being used to store the relevant Property Translation Table file for that EoN Node or Sparkplug B Device. (For more information, see Configure the Properties on the EoN Node Tab, and see Configure the Properties on the Device Tab.)

7. Use the Create Points from Birth Metrics pick action on each MQTT Sparkplug B EoN Node or MQTT Sparkplug B Device to trigger Geo SCADA Expert to automatically create the suite of database points for the EoN Node or Sparkplug B Device. Geo SCADA Expert will take into account the settings that are specified in the relevant Property Translation Table when creating the points in the database.

8. Check that the automatically set properties on the newly created points are configured as expected.

9. Adjust the configuration of any newly created points that are to be output points (Geo SCADA Expert creates all of the points as input points).

10. Check the Event Journal and, if applicable, the Alarms List, for entries about any issues that Geo SCADA Expert detected when it attempted to create the points and populate them with the required values. The entries will be assigned the Sparkplug B Configuration Error category.

    Be aware that alarms might be suppressed for such entries on your system. This can be specified using the Suppress Alarms When Creating Points From Birth Metrics check box on the configuration form of each MQTT Sparkplug B EoN Node and MQTT Sparkplug B Device. For more information, see Configure the Properties on the EoN Node Tab, and see Configure the Properties on the Device Tab.

11. Edit the configuration of the newly created points as required. A message area at the bottom of each point's configuration Form will display messages relating to any invalid, incomplete, or conflicting configuration that requires addressing. For more information, see Mandatory Configuration and Invalid Configuration Messages in the Geo SCADA Expert Guide to Core Configuration, and see the point configuration topics in this driver guide.