ABB Totalflow: Array-Register Templates and EFM Periodic Mapping CSV formats

Array-Register Templates

INI Backed Array-Register Templates

ple INI-backed_ArrayRegisterTemplates.csv file is an example of s

Free Form Array-Register Templates

The Free-Form_ArrayRegisterTemplates.csv file is a

EFM Periodic Mapping Files

The periodic mapping files are used for building up EFM Periodic and Daily History Records.

Each row of such file maps specific field of LOG_PERIOD or DAILY records to a database column name. It also allows user to turn a database column off. In other words if column is disabled, respective filed will not be 'recordized'.

These mappings are CSV files with the following values:

• Array Number
  • Array number (i.e. 250 for the LOG_PERIOD_RECORD and 251 for DAILY_RECORD)
• Application Enumeration
  • List of application enumerations this mapping entry should be applied. If empty, the mapping entry is applicable to any application.  
• Record Field Offset
  • Field offset within the record
• Data Type
  • Field data type
• Description
  • Field description
• Column Name
  • Column name to use
• Enabled
  • A flag that turns this field 'on/off'. In other words it defines if this field should be recordized. 

Below is a mapping example for the LOG_PERIOD_RECORD:

# arrayNum, appEnum, offset, data type, description, column name, enabled
250,4|20,6,FLOAT,Average Differential Pressure,dp_avg,enabled
250,5|21,6,FLOAT,Pulse Counts,pulses,enabled
250,,10,FLOAT,Average Static Pressure,sp_avg,enabled
250,,14,FLOAT,Average Temperature,temp_avg,enabled
250,5|21,18,FLOAT,Uncorrected Volume,raw_vol,enabled
250,,22,FLOAT,Volume,volume,enabled
250,,26,FLOAT,Heating Value,heating_value,enabled
250,,30,UINT16,Flow Time,flo,enabled
250,,32,UINT16,Period Time,flo_rate,enabled