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
importing_device_servers_with_a_spreadsheet [2023/02/02 18:54]
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 5: Line 5:
 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. 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.+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). 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).
Line 13: Line 13:
 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. 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 change property values to the values in the spreadsheet.The only exception to this is if the cell in the spreadsheet is empty, then changes you have made manually in your project for this server and this property will not be changed.+6. Re-importing the spreadsheet will override any values in the serverA blank entry in the cell will result in the default value for that property.
  
 ====Demo Servers==== ====Demo Servers====
  • importing_device_servers_with_a_spreadsheet.1675385681.txt.gz
  • Last modified: 2023/02/02 18:54
  • by wikiadmin