Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
importing_device_servers_with_a_spreadsheet [2023/02/02 18:42] wikiadmin [Importing into TransSECS Devices Node] |
importing_device_servers_with_a_spreadsheet [2023/02/02 22:34] (current) wikiadmin [Importing into TransSECS Devices Node] |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| A list of servers for a specific Device may be added by right clicking on the Device name and using **Import Excel**. Some things to keep in mind when setting up and using your spreadsheet to add device servers: | A list of servers for a specific Device may be added by right clicking on the Device name and using **Import Excel**. Some things to keep in mind when setting up and using your spreadsheet to add device servers: | ||
| - | 1. Use the minimal number of columns | + | 1. There must be a tab (" |
| - | 2. Tag names (the ServerName property) cannot start with a number and do not put spaces or other non-alphanumeric characters in this field. | + | 2. Tag names (the ServerName property) cannot start with a number and do not put spaces or other non-alphanumeric characters in this field. Do not re-use any names already used as server names for any other item in the devices node. |
| - | 3. You can define severs in more than one spreadsheet and import them separately. For example, if you want to separate your tags into servers for alarms, servers for data values, and servers for events, you can make three spreadsheets. This is not mandatory but might help with organization. | + | 3. Cells can be empty. You do not need to enter the default values. Empty cells will use the default when adding new servers or will not change values you have set manually if you re-import the spreadsheet (values will not be overwritten unless you have a non empty value in the cell). |
| + | |||
| + | 4. Use the minimal number of columns in your spreadsheet. In other words, do not add columns for parameters you are not going to use or if you only use the defaults for the parameter value. For example, all servers have a timebase and the default is 1.0 second. Do not add a column for timebase unless you plan to change the defaults on one or more of your servers. | ||
| + | |||
| + | 5. You can define severs in more than one spreadsheet and import them separately. For example, if you want to separate your tags into servers for alarms, servers for data values, and servers for events, you can make three spreadsheets. This is not mandatory but might help with organization. | ||
| + | |||
| + | 6. Re-importing the spreadsheet will override any values in the server. A blank entry in the cell will result in the default value for that property. | ||
| ====Demo Servers==== | ====Demo Servers==== | ||