You can define connection templates that specify how datapoint outputs are connected to datapoint inputs. A connection template, which is made up two or more rules, specifies how an update from one or more datapoints is automatically routed to one or more datapoint inputs. You define connection templates in a connection requirements (CON) file. The file is a manually-generated CSV file defining one or more connection rules for datapoints. A connection rule comprises two or more lines in the CSV file. All lines in the connection file that apply to the same connection rule will have the same Template Name. Each connection template (Template Name) specifies one or more source datapoints and one or more destination datapoints.

This section applies to smartServer 3.0-3.2.

This section consists of the following:

Overview

Each time a new CON file is added, the new rules (based on Template Name) are checked against the existing rules. A rule that is in the existing and new CON file is unchanged. Any new rule that is added, and any old rule that does not exist in the new CON file, is deleted. Therefore, in order to add, change, or delete connections, a new CON file with all the desired connections needs to be imported. To 618271, import a connection file with the header and parameter name, but without any defined connection rules. 

Both connections and datapoint properties (DLA) files have presets and localization. These files are similar to each other, but not interchangeable. For example, if you want to create a connection file that limits which datapoint values are sent to the destination using presets, you cannot use a preset defined in the datapoint properties. You must create the preset in the CON file.  

There are two kinds of connections: point-to-point and LON peer-to-peer. Point-to-point connections allow you to connect two datapoints from devices using different protocols (Modbus to LON). Peer-to-peer connections are between LON devices and only available in DMM.   

Point-to-Point connections can be used to convert data from different protocols, different datapoints types (scalar to structure, or structure to scalar) using the CON file map, or localization parameters. You can also specify that only certain values be sent to the destination datapoint by using presets (e.g., ON or OFF). Connection rules that use map, presets, or localization are point-to-point connections. 

Point-to-point connections rely on the SmartServer receiving datapoint updates. In order to get datapoint updates, you typically configure the datapoint properties for all the datapoints you use for a connection using the Datapoint Properties widget (or DLA file) and set up monitoring (polling or event-driven). Updates will also occur and can be monitored on the Datapoint Browser widget as it received updates, or any other application that does on-demand GETs.

For LON devices, if the SmartServer is configured for DMM, the SmartServer can create either peer-to-peer or point-to-point connections.  Any connection rule in which only LON devices are used and there is no map, preset, or localization specified on the source or destination will cause the SmartServer to create a peer-to-peer connection. If map, preset, or localization is specified, then the SmartServer will use point-to-point. In this case for DMM, the SmartServer will automatically create a peer-to-peer binding between the source LON device and the SmartServer, and will update the destination datapoints if any source values change. This means that you do not need to add an event or polling for the source LON devices using the Datapoint Properties widget as the event update is automatically created by the SmartServer. For IMM only point-to-point connections are created.

For peer-to-peer connections (only supported in DMM), all connection information is configured in the LON edge devices, and any change to the source datapoint will be sent automatically to the destination devices without any interaction by the SmartServer. Peer-to-peer connections are processed faster than point-to-point connections since they only involve the SmartServer to create the connection, or if the connection is routed through the SmartServer. 

Refer to the following table regarding supported datapoint connection types for various protocols:

1 = point-to-point
2 = LON peer-to-peer

Creating a Connection (CON) File

Requirements

A CON file contains the following embedded metadata tags anywhere in the file, and typically in the first line:
#filetype,con

CON files are CSV files categorized by the extension .con, .csv, or .con.csv (not case sensitive). The #filetype tag is equal to con (not case sensitive) and is identified by its file name. A CON file can be imported with any of the mentioned file extensions, and must use CSV formatting. In order to be able to double-click the file and view it in Excel, you should use the .csv or .con.csv extension. The file will be most easily identified using .con.csv.

The following examples are provided:

• Example formulas
• Example CSV files

1. Example formula – the following formula can be added to a CON file first, by opening the file in Excel, and then by pasting the file formula.
    This example formula appears in Excel such as:

{"state":{"transform":"$ ? 1 : 0"},"value":"$"} 

The corresponding CSV file format for the above formula is to double all double quotes, and add double quotes at the beginning and end of the formula. This is handled automatically if you add the formula above using Excel. If you change the CON file using notepad you will need to add the CSV format as shown below. 

If you open the file in a text editor (i.e., notepad), you will see the following:

"{""state"":{"transform"":""$ ? 1 : 0""},""value"":""$""}" 

2. Example CSV files – already show converted formulas. Just copy the CSV file data to a text editor (i.e., notepad) and save it with a .csv extension (or ..con.csv). You can then view the CON file in Excel.

Connection (CON) File Parameters

A CON file contains the following columns (not case sensitive, and parameter columns can be in any order):

Using Presets, Localization, and Map

Presets and localization can be applied to source and destinations datapoints. Leave the cell blank in the CON file for any rule not using preset, localization or map.

Map, presets and localization is typically only used if the datapoint type is different. That is, if both the source and destination datapoints are the same datapoint type, then in most cases you would not use map, preset, or localization for the connection rules.   

Map, preset and localization allow you to create a connection that translates values from one datapoint type to another (e.g., SNVT_switch to SNVT_count), or to manipulate the source or destination values. For example, if the source and destination datapoints are SNVT_count, but the source has a range of -100 to 300 and the destination only allows a range of 0 to 100, you can use use map or localization to change the allowed destination range.

The following scenarios are supported:

The order of the transformation for the source datapoint is IAP value → Localization → Presets → Map.

• If the source localization is defined, the datapoint is transformed to a localized value. 
• If the source presets is not NULL, the IAP value (or the local value) is transformed to a preset value.
• If the map is defined, the last transformation value, which could be a preset value, a local value or an IAP value, is transformed according to the map rules.

The reverse transformation order for the destinations datapoint is Presets → Localization → IAP value. Presets (if defined) are specified using the local values. The localization rule must be specified to reverse transform the preset value to the IAP value.

The map is specified in source and will be applied to the source datapoint for all destinations. Only one map per connection rule ID is supported. Map should be left empty for destinations as it is not supported. Mapping for individual destinations is defined in presets or localization.  

If the datapoint value does not map to any of the presets, then the value is not sent if the onlyPreset property is set to true. Otherwise, the native value will be sent instead. If both transformation map and presets are defined on the source datapoint, then the transformation map is ignored. Only one preset can be defined in the datapoint source. If you have more than one source that has different presets, you have to split it into different connection objects. 

The CON file has an option to specify whether to skip sending datapoint values if the presetValue is not defined or the source presetValue does not map to any of the destination presets.

Most BACnet and Modbus datapoint types are scalars values (only one number like temperature). LON datapoints can be scalar or structured datapoints. Structured datapoints have fields in which each field represents a value (e.g., SNVT_switch has a state and value fields).

For structured destination datapoints you need to specify result for all fields. That is, if you have a five field destination, then the formulas you use must specify a destination value that has all five fields.

Understanding Connection Operations

Source value → Source Transform (by source map, preset, or localization) → Connection value  → Destination Transform (by destination preset or localization) → Destination value.

1. There can be FAN INs (multiple sources) for one connection.
   1. If the source map, preset, and localization are the same for all source datapoints, then you can use one connection rule.
   2. If the source map, preset, or localization is different, then you need to specify the source in separate rules and duplicate the destination datapoints for both.
   3. If you have some source datapoints with the same map, preset, or localization, then those can be in one rule and the other source datapoints need to be in separate rules.
      
      
2. There can be FAN OUTs (multiple destination) for one connection.
   
   
3. There can be FAN INs and FAN OUTs for one connection.
   1. If the source map, preset, and localization are the same for all source datapoints, then you can use one connection rule.
   2. If the source map, preset, or localization is different, then you need to specify the source in separate rules and duplicate the destination datapoints for both.
   3. If you have some source datapoints with the same map, preset, or localization, then those can be in one rule and the other source datapoints need to be in separate rules.

Defining LON Connection Service Types

Service types for LON connections can be defined as described below:

• 1:1 connection to the SmartServer – these bindings are added to the address table with the subnet/node of the destination.
  • The default service type is acknowledged data.

  • The timeout time of the associated channel is entered as the timing parameter for the TX timer. The number of retries is taken from the associated channel parameter retryCount. The smallest value from the timeout parameter of the associated channel, or 64ms, is used as the repeat timer.
    
    

• 1:n connection (FAN OUTs) – a broadcast address table entry is used for these connections.
  • If all destinations are in the same subnet, a subnet broadcast address table entry is used. If not all destinations are in the same subnet, a domain-wide broadcast address table entry is used.
  • The default service type is unacknowledged, repeated.
  • The timeout time of the associated channel is entered as the timing parameter for the TX timer. The number of retries is taken from the associated channel parameter retryCount. The smallest value from the timeout parameter of the associated channel, or 64ms, is used as the repeat timer.

• PL repeating – a 1:1 connection to the local LON network interface of the SmartServer is set up for source data points of a binding that cannot reach destinations because the attenuation is too great. (This also includes the proxy chain back to the SmartServer if the device containing the source data point is located in a remote segment.) Network variable updates are sent by the LON network interface as domain-wide broadcast messages with the same content as the received message.
  • The default service type is unacknowledged, repeated. 
  • The timing parameter for the TX timer is 512ms, and the number of retries is three.

Formula Examples

$ represents the input of a source or destination transform and specifies the complete datapoint value. For structured datapoints, like SNVT_switch, specify $.<field name> to access a datapoint field value.

For example:

• To access the SNVT_switch state field, specify: $.state
  
• To access the SNVT_switch value field, specify: $.value

You need to use a transform function in the formula any time the formula uses multiplication, division, addition, subtraction, if-then, math formula, or math function.

Math Functions

Math functions can be applied to datapoint values, such as limiting the range of the datapoint value.

These example formulas can be copied into an Excel cell.

Example formula to limit a datapoint value to a value between 10 and 100:

{"transform":"min(max($, 0),100)"}

Source Map Formulas

Destination map is configured by using preset map or localization.  

These example formulas can be copied into an Excel cell (always leave destination map blank). For the examples below, SNVT_switch is a structured datapoint having a value with two fields (i.e., state and value). 

Presets Formulas

These example formulas can be copied into an Excel cell.

Localization Formulas

These example formulas can be copied into an Excel cell.

Connection (CON) File Examples

Using map, presets, and localization in datapoints is optional. A datapoint can have map only (Sources), presets only, localization only, have all three map, presets and localization, or neither. When both presets and localization are used, the presets map are typically configured based on the localization value. Therefore, when an update is received, the value needs to be localized first before mapping to a preset string. And, when a preset string is entered, the map value needs to be transformed using the revert transformation rule to get the native value. 

To use the example files shown below, copy the text to a text editor like notepad, then save as text, and finally change the extension to .con.csv. At this point, you can view the files using Excel.

Connection rules use a Fixed (specify Device Name) or Relative (Specify Device Type) Reference Type. 

The connection rules that specify Device Type require you to assign the device to a Context or Target Type (e.g., Floor or Room). Contexts are created and viewed using the Planning widget and devices are assigned to a context using the Device widget.

When creating connection rule for structured datapoints, you need to specify $ which means entire value, or specify the preset or transform for each field. That is, you cannot create a rule that specifies a transform for just a specific field. It is specified for either the entire value $ (which means all the fields), or you have to create separate transforms for each field.

The first example demonstrates a LON peer-to-peer connection, which is only available for LON devices (DMM mode only). All other examples show point-to-point connections ,which are used for all protocols including BACnet, Modbus, and LON connections.

Fixed versus Relative Reference Types 

The following CON file example shows a connection with the source datapoint using a fixed reference type, and two destination datapoints (one fixed and one relative reference type). For fixed reference type, the device name is specified. For relative reference type, you specify the context and device type.

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction,Map,Presets,Repeat Presets,Localization,Repeat Localization,Priority
C1,Fixed,,,,PulseGen1,,device/0/nvoCount,Source,,,,,,Normal
C1,Relative,Campus/San Francisco/Floor 2/Room 1,,,,teslaTempTester,device/0/nviCount[0],Destination,,,,"{""transform"": ""$ ""}",,
C1,Fixed,,,,PulseGen2,,device/0/nviCount,Destination,,,,"{""transform"": ""$ * 2""}",,

LON Peer-to-Peer Connection

The following CON file example (Device Name specified) shows peer-to-peer connection (source and destination devices are LON devices) the format without using map, presets, and localization.

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction
24,,,,,PulseGen1,,device/0/nvoSwitch2,Source
24,,,,,PulseGen2,,device/0/nviLamp2,Destination
25,,,,,PulseGen2,,device/0/nvoSwitch2,Source
25,,,,,PulseGen1,,device/0/nviLamp2,Destination

With Source Map

The following CON file example (Device Name Specified) shows the format for map, presets, and localization, when only map specified.

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction,Map,Presets,Repeat Presets,Localization,Repeat Localization
22,,,,,PulseGen1,,device/0/nvoPulseOut,Source,"{""state"":{""transform"":""$ ? 1 : 0""},""value"":""$""}",,,,
22,,,,,PulseGen1,,device/0/nviLamp1,Destination,,,,,
23,,,,,PulseGen2,,device/0/nvoPulseOut,Source,"{""state"":{""transform"":""$ > 0 ? 1 : 0""},""value"":""$""}",,,,
23,,,,,PulseGen1,,device/0/nviLamp2,Destination,,,,,

With Two Sources and One Destination (Different Source Mapping)

The following CON file example shows two sources that are connected to, and one destination, with each source having a different mapping transformation. In this case, you need to create multiple rules (i.e., separate rules for each mapping transformation), or specify the mapping rules in Presets column, where presets and the mapping rules are defined, similar to the following:

• create a rule for sourceA/destA
• create another rule for sourceB/destA

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction,Map 
8,,,,,NcMultiSensor112.860,,Switch/0/nvoValue,Source,"{""value"": {""transform"":""sqrt($.value)""}, ""state"": {""transform"": ""$.state ? 0 : 1""}}" 
8,,,,,NcMultiSensor112.860,,Switch/0/nviValueFb,Destination,, 
9,,,,,NcMultiSensor112.860,,Switch/0/nvoValue,Source,"{""value"": {""transform"":""3.5*($.value%25)""}, ""state"": {""transform"": ""$.state ? 1 : 0""}}" 
9,,,,,NcMultiSensor112.860,,Switch/1/nviValueFb,Destination,,

With Presets

The following CON file example shows the format for map, presets, and localization.

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction,Map,Presets,Repeat Presets,Localization,Repeat Localization
3,,,,,PulseGen1,,device/0/nvoLamp1,Source,,"{""$"": {""transform"": ""$.value == 100 && $.state == 1 ? 'ON' : $.value == 50 && $.state == 1 ? 'MID' : $.value == 0 && $.state == 0 ? 'OFF' : ' ' ""}}",,,
3,,,,,PulseGen2,,device/0/nviTemp,Destination,,"{""$"": {""enumeration"":{""source"": ""$"", ""map"": {""ON"": 100,""MID"": 50, ""OFF"": 0}}}}",,,
3,,,,,PulseGen2,,device/0/nviLamp1,Destination,,"{""$"": {""value"":{""enumeration"":{""source"": ""$"", ""map"": {""ON"": 100,""MID"": 50,""OFF"": 0}}},""state"":{""enumeration"":{""source"":""$"",""map"":{""ON"": 1,""MID"": 1,""OFF"": 0}}}},""onlyPreset"": true}",,,

With Localization

The following CON file example shows the format for map, presets, and localization.

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction,Map,Presets,Repeat Presets,Localization,Repeat Localization
3,,,,,PulseGen1,,device/0/nvoLamp1,Source,,,,,
3,,,,,PulseGen2,,device/0/nviLamp1,Destination,,,,"{""value"":{""transform"": ""$.value + 10""},""state"":{""transform"": ""$.state""}}",
4,,,,,PulseGen1,,device/0/nvoHVACTemp,Source,,,,,
4,,,,,PulseGen2,,device/0/nviTemp,Destination,,,,"{""transform"": ""$ * 1.8 + 32""}",
5,,,,,PulseGen1,,device/0/nvoCount,Source,,,,"{""transform"": ""$ * 2""}",
5,,,,,PulseGen2,,device/0/nviCount,Destination,,,,,

With Presets and Localization (One Source and Two Destinations)

The following CON file example shows the format for map, presets, and localization.

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction,Map,Presets,Repeat Presets,Localization,Repeat Localization
3,,,,,PulseGen1,,device/0/nvoLamp1,Source,,"{""$"": {""transform"": ""$.value == 100 && $.state == 1 ? 'ON' : $.value == 50 && $.state == 1 ? 'MID' : $.value == 0 && $.state == 0 ? 'OFF' : ' ' ""}}",,,
3,,,,,PulseGen2,,device/0/nviTemp,Destination,,"{""$"": {""enumeration"":{""source"": ""$"", ""map"": {""ON"": 100,""MID"": 50, ""OFF"": 0}}}}",,"{""transform"": ""$ * 2""}",
3,,,,,PulseGen2,,device/0/nviLamp1,Destination,,"{""$"": {""value"":{""enumeration"":{""source"": ""$"", ""map"": {""ON"": 90,""MID"": 50,""OFF"": 0}}},""state"":{""enumeration"":{""source"":""$"",""map"":{""ON"": 1,""MID"": 1,""OFF"": 0}}}},""onlyPreset"": true}",,"{""value"":{""transform"": ""$.value + 10""},""state"":{""transform"": ""$.state""}}",

Clear Connections

The following CON file example shows the format to clear all connections (using a connection file with no rules).

#filetype,con
Template Name,Reference Type,Contexts,Target Type,Target Name,Device Name,Device Type,Datapoint Name,Direction,Map,Presets,Repeat Presets,Localization,Repeat Localization