====Importing VIDs, CEIDs, and ALIDs into TransSECS==== 

see also, [[Importing Device Servers with a Spreadsheet]]

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".

===Setting up the Spreadsheet ===

===VIDs===

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:

^ VIDType  ^ Name           ^   VID   ^  DataType    ^
| SVID    | Temperature     |  1512   |  44          |
| SVID    | Pressure        |  1620   |  Float-4     |
| ECID    | Setpoint        |  2000   |  U4          |




===CEIDs===

===ALIDs===