importing_device_servers_with_a_spreadsheet

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
importing_device_servers_with_a_spreadsheet [2023/02/02 18:36]
wikiadmin [Parameters specific to Modbus Array and Modbus String Array] 		importing_device_servers_with_a_spreadsheet [2023/02/02 22:34] (current)
wikiadmin [Importing into TransSECS Devices Node]
Line 1: Line 1:
 =====Importing into TransSECS Devices Node===== =====Importing into TransSECS Devices Node=====
  
-A list of servers for a specific Device may be added by right clicking on the Device name and using **Import Excel**.+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. There must be a tab ("sheet") called "devices" in your spreadsheet. The **Import Excel** operation will only read from this sheet with this name. 
 + 
 +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. 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====
Line 110: Line 122:
 </code> </code>
  
-** //Advise on using arrays// **+** //Advice on defining arrays in the spreadsheet// **
  
 Since arrays add extra columns to the spreadsheet not used by regular modbus register types such as Word, Floats, and Double Words, it is recommended that you make a separate  spreadsheet with a devices sheet (tab) to set up just arrays or if not too many arrays are used in your project you can add these manually to the project. The purpose of this recommendation is to keep the regular register rows cleaner without the extra sparely populated parameters only used for arrays. Since arrays add extra columns to the spreadsheet not used by regular modbus register types such as Word, Floats, and Double Words, it is recommended that you make a separate  spreadsheet with a devices sheet (tab) to set up just arrays or if not too many arrays are used in your project you can add these manually to the project. The purpose of this recommendation is to keep the regular register rows cleaner without the extra sparely populated parameters only used for arrays.
  • importing_device_servers_with_a_spreadsheet.1675384614.txt.gz
  • Last modified: 2023/02/02 18:36
  • by wikiadmin