2. Defining the Event and Trigger condition

the purpose of the sheet event and trigger definition is to define the event as well as the trigger condition to be monitored 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 important this guide is written under the assumption, that the configurator is used in online mode this allows the configurator to download both existing data model as well as tag configurations and make them available for users to select them without the need of typing and minimizing the risk of spelling mistakes select the data model to which the event applies events defined inside production record database are defined on a data model basis this does prevent that wrong data are able to be stored in the wrong data model and corrupting the production event a data model has to be setup beforehand inside litmus production record database for example using the litmus solution litmus production record data model configurator the name of the data model for which the event is created is configured in the column labeled production record data model node name in online mode, users select one of the available data models from the drop down menu in the column labeled production record data model node name note only values available through the drop down menu can be selected 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 tip 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 data model mode names first, especially if more than one event is to be defined per data model 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 in offline mode in offline mode, the user will have to insert the name of the data model manually as the configurator can not download which data models are defined on the sql server and can not create the drop down menu available in online mode note if the data model name is wrongly spelled for example or the data model doesn't exists, the configuration will fail to be setup inside litmus production record database the configurator will verify the data model node 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 data model node name in a query, the maximum length of a data model node name can not exceed 50 characters if a data model node name is longer 50 characters, the user will be prompted note names of data models which exceed the 50 character limit, will by default be trimmed to 50 characters if no action is taken by the user define the event name the name of an event is configured in the column labeled event 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 event 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 am event name in a query, the maximum length of an event name can not exceed 50 characters if an event name is longer 50 characters, the user will be prompted note names of events which exceed the 50 character limit, will by default be trimmed to 50 characters if no action is taken by the user modify an existing event to modify an already existing event, by for example adding a new trigger, changing a trigger condition or adding a new item through the sheet event item definition , users can select the event from the drop down menu in the column labeled event name note this is only possible for events which have been previously configured on litmus production record database important this does require to be in online mode adding an event description (optional) users are able to provide a description for an event to provide some context for colleagues about the purpose of the event and what it is used for the configurator will verify the event description 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 invalid string length to allow for the most efficient storage the maximum length of an event description can not exceed 256 characters if an event description is longer 256 characters, the user will be prompted note descriptions for events which exceed the 256 character limit, will by default be trimmed to 256 characters if no action is taken by the user define the trigger condition name the name of a trigger is configured in the column labeled trigger condition 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 trigger condition 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 trigger condition name in a query, the maximum length of a level name can not exceed 50 characters if a trigger condition name is longer 50 characters, the user will be prompted note names of trigger conditions which exceed the 50 character limit, will by default be trimmed to 50 characters if no action is taken by the user duplicate node event trigger combination check while it is possible to reuse a trigger condition name for different events a specific trigger condition name has to be unique in its combination with a specific event name and data model node name if the configurator does detect, that a specific combination has already be used, the user is prompted the duplicate row will have the three columns production record data model node name , event name and trigger condition name be marked in red this allows the user to find the duplicate entry and correct it modify an existing trigger condition name to modify an already existing trigger condition, users can select the trigger condition name from the drop down menu in the column labeled trigger condition name note this is only possible for events which have been previously configured on litmus production record database important this does require to be in online mode this will also autocomplete the following columns, as the configurator can import the existing configuration define the trigger tag to be able to monitor a trigger for an event, litmus production record database requires the tag which to monitor for the event a tag used in the column labeled trigger tag , has to be defined inside litmus production record database beforehand, for example using the litmus solution litmus production record tag configurator the tag used for the trigger to monitor is configured in the column labeled trigger tag in online mode, users select the tag from the drop down menu in the column labeled trigger tag the trigger tag is a pipe symbol " | " separated string composed of first position = device name used when setting up the tag in litmus production record database plc rc1 ccs | htr htg temp pv | value second position = tag name used when setting up the tag in litmus production record database plc rc1 ccs | htr htg temp pv | value third position = item name used when setting up the tag in litmus production record database plc rc1 ccs | htr htg temp pv | value note only values available through the drop down menu can be selected 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 in offline mode in offline mode, the user will have to insert the pipe symbol "|" separated string manually as the configurator can not download which tags are defined on the sql server and can not create the drop down menu available in online mode note if the tag string incudes a wrongly spelled device, tag or item or the device, tag or item doesn't exists, the configuration will fail to be setup inside litmus production record database in offline mode, the configurator will verify the trigger tag string for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used 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 define the trigger condition to be able to monitor a tag for an event, litmus production record database does require a trigger condition litmus production record database supports six different conditions trigger condition what is monitored onchange litmus production record database will monitor the tag for any change to the value of the item set as trigger tag greaterthan litmus production record database will monitor the value of the item set as trigger tag if it is greater then the value set smallerthan litmus production record database will monitor the value of the item set as trigger tag if it is smaller then the value set euqalto litmus production record database will monitor the value of the item set as trigger tag if it is equal to the value set greaterequaltthan litmus production record database will monitor the value of the item set as trigger tag if it is greater then or equal to the value set smallerequalthan litmus production record database will monitor the value of the item set as trigger tag if it is smaller then or equal to the value set the user sets the trigger condition by selecting it from the drop down menu in the column labeled trigger condition this will add the selected string into the cell note only values available through the drop down menu can be selected define the condition value this is the value used by litmus production record database in combination with the trigger condition when monitoring the trigger tag note this column does not need to be filled in, if the cell itself is greyed out to define the condition value, the user enters the value into the cell of the column labeled condition value the configurator will verify the condition value 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 this will impact mainly values which are alphanumerical invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red invalid string length t he maximum length of a condition value can not exceed 256 characters if a conditional value is longer 256 characters, the user will be prompted note conditional values which exceed the 256 character limit, will by default be trimmed to 256 characters if no action is taken by the user