Geo SCADA Expert to eDNA Field Mapping Format
The following tables detail the eDNA field mapping of the export from Geo SCADA Expert.
Format 1
| Wonderware eDNA Field | Field Type | Geo SCADA Expert Configuration | Standard / User defined |
|---|---|---|---|
| Point Id | System Defined (Note [1]) | ||
| Long Id | String | AlarmSource | |
| Description | System Defined (Note [2]) | ||
| Units | String | Units | |
| Point Type | System Defined (Note [3]) | ||
| Report Alarm | Boolean | False | |
| Alarm Priority | Integrer | 0 | |
| Digital Alarm String | Not Used | ||
| Digital Normal String | Not Used | ||
| Invert Digital Sense | Not Used | ||
| High Out-of-Range Enabled | Not Used | ||
| High Out-of-Range Value | Not Used | ||
| High Alarm Enabled | Not Used | ||
| High Alarm Value | Not Used | ||
| High Warning Enabled | Not Used | ||
| High Warning Value | Not Used | ||
| Low Warning Enabled | Not Used | ||
| Low Warning Value | Not Used | ||
| Low Alarm Enabled | Not Used | ||
| Low Alarm Value | Not Used | ||
| Low Out-of-Range Enabled | Not Used | ||
| Low Out-of-Range Value | Not Used | ||
| Report History | Boolean | True | |
| Report Force History | Boolean | False | |
| Force Period | Not Used | ||
| Minimum Period | Not Used | ||
| History Expire Days | Constant | 9999 | |
| History Deadband | Not Used | ||
| Point Security Group | Not Used | ||
| Extended Id | String | FullName | |
| Extended Description | String | EngDescription | User Defined |
| Spare 01 | String | State 0 Description | |
| Spare 02 | String | State 1 Description | |
| Spare 03 | String | State 2 Description | |
| Spare 04 | String | State 3 Description | |
| Spare 05 | String | State 4 Description | |
| Spare 06 | String | State 5 Description | |
| Spare 07 | String | State 6 Description | |
| Spare 08 | String | State 7 Description | |
| Spare 09 | Not Used | ||
| Ref 01 | String | OperationalStatus | User Defined |
| Ref 02 | Not Used | ||
| Ref 03 | Not Used | ||
| Ref 04 | Not Used | ||
| Ref 05 | Not Used | ||
| Ref 06 | Not Used | ||
| Ref 07 | Not Used | ||
| Ref 08 | Not Used | ||
| Ref 09 | Not Used | ||
| Ref10 | Not Used | ||
Format 2
| Field | Type | Geo SCADA Expert Configuration | Standard / User defined |
|---|---|---|---|
| Point Id | System Defined (Note [1]) | ||
| Long Id | System Defined | (Note [4]) | |
| Description | System Defined | (Note [2]) | |
| Units | String | Units | |
| Point Type | System Defined (Note [3]) | ||
| Report Alarm | Boolean | False | |
| Alarm Priority | Integer | 0 | |
| Digital Alarm String | Not Used | ||
| Digital Normal String | Not Used | ||
| Invert Digital Sense | Not Used | ||
| High Out-of-Range Enabled | Not Used | ||
| High Historical Attribute Value | Not Used | ||
| High Alarm Enabled | Not Used | ||
| High Alarm Value | Not Used | ||
| High Warning Enabled | Not Used | ||
| High Warning Value | Not Used | ||
| Low Warning Enabled | Not Used | ||
| Low Warning Value | Not Used | ||
| Low Alarm Enabled | Not Used | ||
| Low Alarm Value | Not Used | ||
| Low Out-of-Range Enabled | Not Used | ||
| Low Out-of-Range Value | Not Used | ||
| Report History | Boolean | True | |
| Report Force History | Boolean | False | |
| Force Period | Not Used | ||
| Minimum Period | Not Used | ||
| History Expire Days |
Integer |
9999 | |
| History Deadband | Not Used | ||
| Point Security Group | Not Used | ||
| Extended Id | String | Name | |
| Extended Description | String | FullName | |
| Spare 01 | String | State 0 Description | |
| Spare 02 | String | State 1 Description | |
| Spare 03 | String | State 2 Description | |
| Spare 04 | String | State 3 Description | |
| Spare 05 | String | State 4 Description | |
| Spare 06 | String | State 5 Description | |
| Spare 07 | String | State 6 Description | |
| Spare 08 | String | State 7 Description | |
| Spare 09 | Not Used | ||
| Ref 01 | String | eDNARef01 | User defined |
| Ref 02 | String | eDNARef02 | User defined |
| Ref 03 | String | eDNARef03 | User defined |
| Ref 04 | Not Used | ||
| Ref 05 | Not Used | ||
| Ref 06 | Not Used | ||
| Ref 07 | Not Used | ||
| Ref 08 | Not Used | ||
| Ref 09 | Not Used | ||
| Ref 10 | Not Used | ||
The following eDNA fields require the Geo SCADA Expert values to be processed before they are exported:
eDNA Point Id only allows 8 characters to be stored. The Geo SCADA Expert Id values are processed in one of 3 ways depending on their value.
where the Geo SCADA Expert value is:
- less than or equal to 99999999, then it is encoded as an 8 character decimal number.
- greater than 99999999 and less than or equal to 268435455, then it is encoded as a 7 character hexadecimal number string prefixed with an x, for example 248563456 becomes xED0C700.
- greater than 268435455 it is converted to base64.
All three conversions produce a unique Id value.
The description is obtained from the text to the right of the rightmost period "." of the Alarm Source field. In Format 1 if there is no entry for alarm source the field will remain empty. In Format 2 this field should contain the description, however, if there is no entry in the field the object name is inserted.
eDNA Point Type receives the following:
For all analog point types, VT-R4, VT_R8 and VT_I4, the text "AI" is substituted.
For all digital point types the text "MS"
The default value is a null value.
This process is only applied in Format 2. If the Alarm Source contains a Long Id, it is included. If there is no Long Id, the Full Name is inserted.