see also, Importing into TransSECS Devices Node

Using an excel (xlxs) spreadsheet to list SECS/GEM IDs and the associated properties can help save time when setting up a SECS/GEM project. To use the excel spreadsheet, right click on the node (either VIDs, CEIDs, or ALIDs) and select “Import Excel”.

SVIDs,ECIDs, and DVIDs are imported as a “vid” sheet in the spreadsheet. The order of the columns is not important, but the column headers are:

VIDType,Name,VID,DataType,Units,LimitMin,LimitMax,InitialValue,deadband,CEID,DeviceName,and TagName. Only VIDType,Name,VID, and DataType are mandatory. DeviceName and TagName are only used with TransSECS Device (see below for more on this).

VIDType - this is either SVID,ECID, or DVID

Name - the name of the VID. This must start with a letter (not a number) and should not contain any special characters except a space or an underscore

VID - this is a number, the ID of the SVID,ECID or DVID

DataType - this is the SECS data type of the ID, for example, Boolean, List, Ascii, Unsigned Number, or Integer. This Data Type also encapsulates the data size of the numeric values, 1 byte, 2 bytes, 4 bytes, or 8 bytes. Valid values are:

Ascii (Text): String,A, or 20

List: List, L, or 0

Unsigned Integer (can have different data lengths):

• U1, Unsigned-1, 51
• U2, Unsigned-2, 52
• U4, Unsigned-4, 54
• U0, Unsigned-8, 50

Signed Integer (can have different data lengths):

• I1, Integer-1, 31
• I2, Integer-2, 32
• I4, Integer-4, 34
• I0, Integer-8, 30

Float (can have different data lengths):

• F4,Float-4,44
• F0,Float-8,40

Bo,Boolean,11

B,Binary,10

Here is a simple table showing a few examples: