2. Defining the Device(s) and Tag(s)

the purpose of the sheet tags is to define the device names as well as the tag names note the sequence of steps shown in this guide is a recommendation, as it felt the most natural for the author but users are free to follow their own preferred sequence define the device name the name of a device is configured in the column labeled device name important do not leave blank rows between entries or at the start a blank row will be seen as the end of the configuration and the configurator will not process any entry past the blank row the configurator will verify the device name for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used the configurator also validates the length of the string invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red as spaces are not a visible character, they can't be marked in red, so the user can make use of the comment added to the cell as well invalid string length to allow for the most efficient storage of the configuration as well as practicality when using a device name in a query, the maximum length of a device name can not exceed 50 characters if a device name is longer 50 characters, the user will be prompted note names of devices which exceed the 50 character limit, will by default be trimmed to 50 characters if no action is taken by the user duplicate tags check similar to the behavior users are familiar from litmus edge, which requires tag name uniqueness on a device level base, the configurator will check, if tag names have already be defined, if the same tag name exists more than once per device name the duplicate tag will have a " $ " added as prefix this allows the user to find the duplicate tag and correct it tip if device names are added first while a very common way of filling in spreadsheet style lists is to do it row by row, it has been observed that it can be beneficial to fill in all device names first, especially if more than one tag is to be defined per device this can be achieved through the use of copy & paste cell content as well as make use of the ms excel autocomplete feature, where it does try to recognize what the user may want to enter as a repeat making use of these fast forms of duplication, can make it very quick to fill in all the names for the devices as many time as it is needed filling in the example below was done in less than 20 seconds tip if tag names have been added first if the user has defined the tag names first and if each device has the same tags, it is very easy to duplicate the device name to the respective tags for example a users defines the device of the first tag for this device then they simply duplicate the device to all the other tags for this device in the picture below, the user has copied the value of row 3 shown by the interrupted green cell border and then selected rows 5, 7 and 9 making use of ctrl+left click the user then simply pasted the value into the selected rows a second option is to make use of the ms excel autocomplete feature, where it does try to recognize what the user may want to enter as a repeat define the tag name the name of a tag is configured in the column labeled tag name important do not leave blank rows between entries or at the start a blank row will be seen as the end of the configuration and the configurator will not process any entry past the blank row the configurator will verify the tag name for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used the configurator also validates the length of the string invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red as spaces are not a visible character, they can't be marked in red, so the user can make use of the comment added to the cell as well invalid string length to allow for the most efficient storage of the configuration as well as practicality when using a tag name in a query, the maximum length of a level name can not exceed 50 characters if a tag name is longer 50 characters, the user will be prompted note names of tags which exceed the 50 character limit, will by default be trimmed to 50 characters if no action is taken by the user duplicate tags check similar to the behavior users are familiar from litmus edge, which requires tag name uniqueness on a device level base, the configurator will check, if tag names have already be defined, if the same tag name exists more than once per device name the duplicate tag will have a " $ " added as prefix this allows the user to find the duplicate tag and correct it tip if device names have been added first if the user has defined the device names first and if each device has the same tags, it is very easy to duplicate the values from the first device to other devices for example a users defines the tags for the first device then they simply duplicate the tags to all the other devices in the picture below, the user has copied the value of row 3 6 shown by the interrupted green cell border and then selected rows 7 10 the user then simply pasted the value into the selected rows a second option is to make use of the ms excel autocomplete feature, where it does try to recognize what the user may want to enter as a repeat tip if tag names are added first while a very common way of filling in spreadsheet style lists is to do it row by row, it has been observed that it can be beneficial to fill in all device names first, especially if more than one tag is to be defined per device this can be achieved through the use of copy & paste cell content as well as make use of the ms excel autocomplete feature, where it does try to recognize what the user may want to enter as a repeat making use of these fast forms of duplication, can make it very quick to fill in all the names for the devices as many time as it is needed filling in the example below was done in less than 20 seconds no tags defined a tag configuration does require a tag and the device therefore, if the user does not define a tag and/or device in the sheet tags , the user will be prompted reading back a single tags configuration if a user wants to modify an existing tag defined already on litmus production record database, they are able to modify this tag using the configurator this is supported by the ability, to readback a tag configuration from litmus production record database into the configurator, and making them available in the respective sheets this does require, that an active connection between the configurator and sql server exists and that the database le productionrecord is defined with the desired data model inside to read back a tag configuration, enter the device name and tag name into the cells labeled device name a nd tag name at the right side of the sheet press the button read tag configuration the user can be prompted multiple times to provide the sql authenticated login user name and password the progress will be shown by a progress bar after retrieving the tag configuration, the values are written into the respective sheets example for the sheet tags after reading back a data model example for the sheet items after reading back a data model note initial values can not be read back, as they are not part of the configuration of the tag itself but have been stored as actual values