Aller au contenu principal
Version: v3.6 (Non supportée)

Dynamic Importation Filters

Appendix

Code Language Country Code Language Country ar-sa Arabic Saudi Arabia fr-be French Belgium ar-iq Arabic Iraq fr-ca French Canada ar-eg Arabic Egypt fr-ch French Switzerland ar-lt Arabic Libya fr-lu French Luxembourg ar-dz Arabic Algeria fr-mc French Monaco ar-ma Arabic Morocco he-il Hebrew Israe ar-tn Arabic Tunisia hu-hu Hungarian Hungary ar-om Arabic Oman is-is Icelandic Iceland ar-ye Arabic Yemen it-it Italian Italy ar-sy Arabic Syria it-ch Italian Switzerland ar-jo Arabic Jordan ja-jp Japanese Japan ar-lb Arabic Lebanon ko-kr Korean Korea ar-kw Arabic Kuwait nl-nl Dutch Netherlands ar-ae Arabic U.A.E. nl-be Dutch Belgium ar-bh Arabic Bahrain no-no Norwegian Norway ar-qa Arabic Qatar pl-pl Polish Poland bg-bg Bulgarian Bulgaria pt-br Portuguese Brazil ca-es Catalan Spain pt-pt Portuguese Portugal zh-tw Chinese Taiwan ro-ro Romanian Romania zh-cn Chinese PRC ru-ru Russian Russia zh-sg Chinese Singapore hr-hr Croatian Croatia cs-cz Czech Czech Republic hr-hr Croatian Croatia da-dk Danish Denmark sk-sk Slovak Slovakia de-de German Germany sq-al Albanian Albania de-ch German Switzerland sv-se Swedish Sweden de-at German Austria sv-fi Swedish Finland de-lu German Luxembourg th-th Thai Thailand de-li German Liechtenstein tr-tr Turkish Turkey el-gr Greek Greece ur-pk Urdu Pakistan en-us English United States id-id Indonesian Indonesia en-gb English United Kingdom uk-ua Ukrainian Ukraine en-au English Australia be-by Belarusian Belarus en-ca English Canada sl-si Slovenian Slovenia en-nz English New Zealand et-ee Estonian Estonia en-ie English Ireland lv-lv Latvian Latvia en-za English South Africa lt-lt Lithuanian Lithuania en-jm English Jamaica fa-ir Farsi/Persian Iran en-cb English Caribbean vi-vn Vietnamese Vietnam en-bz English Belize hy-am Armenian Armenia en-tt English Trinidad az-az Azeri Azerbaijan en-zw English Zimbabwe eu-es Basque Spain en-ph English Philippines mk-mk Macedonian Macedonia es-es Spanish Spain af-za Afrikaans South Africa es-mx Spanish Mexico ka-ge Georgian Georgia es-gt Spanish Guatemala fo-fo Faroese Faeroe Islands es-cr Spanish Costa Rica hi-in Hindi India es-pa Spanish Panama ms-my Malay Malaysia es-do Spanish Dominican Republic ms-bn Malay Brunei Darussalam es-ve Spanish Venezuela kk-kz Kazakh Kazakhstan es-co Spanish Colombia sw-ke Swahili Kenya es-pe Spanish Peru uz-uz Uzbek Uzbekistan es-ar Spanish Argentina tt-ru Tatar Tatarstan es-ec Spanish Ecuador bn-bd Bengali India es-cl Spanish Chile pa-in Punjabi India es-uy Spanish Uruguay gu-in Gujarati India es-py Spanish Paraguay or-in Oriya India es-bo Spanish Bolivia ta-in Tamil India es-sv Spanish El Salvador te-in Telugu India es-hn Spanish Honduras kn-in Kannada India es-ni Spanish Nicaragua ml-in Malayalam India es-pr Spanish Puerto Rico as-in Assamese India fi-fi Finnish Finland mr-in Marathi India fr-fr French France sa-in Sanskrit India Alphanumeric language coding

The dynamic importation filters allow alarm supervision conditions to be defined in Alert without having prior to define a list of variables to supervise. This feature considerably reduces the work required to configure the software and also authorizes a dynamic self - configuration of the supervision when the supervised system evolves. The configuration of the dynamic importation consists to define a list of importation filters, each filter defining criterions to dynamically create a specific category of alarms. The main task to realize is a preliminary work to specify importation criterions of every alarm to process in order to define the properties of these alarms (identifier, messages, group classification, priority, groups to call ...) in function of basic properties attached to data to supervise (type, category, labels, priority, localization ...). The basic properties attached to supervision data depends on the importation context :

  • In the case of Message Processor, they are variables defined as "filter" variables that will be updated by the script before calling the filter processing function (PROCESSEVENT).
  • In the case of OPC AE, they are properties transmitted with the event notifications.
  • In the case of mediators, they are properties that are specific to the supervision environment processed by the mediator. The properties of created alarms as well as possible associated conditions are defined by arithmetic and logical expressions of basic properties of supervised data. To make expressions more clear and optimize the filter evaluation, macro-expressions can be defined. These macro expressions can be used in every filter and are computed only one time just before each processing of the list of filters. For an usage example of filters, see the configuration of Message Processor (§ 8.16.2.2 "Dynamic importation filters").

The properties and conditions designated in a filter are defined by an arithmetic or logical expression that is evaluated when processing the filter. This expression can be directly typed in the edit field of the property or condition . One can also use the expression editor by clicking on the adjacent button ( ). The field " Expression" displays the defined expression . The wished expression can be directly typed in this field or built by using the tools proposed by the expression editor to insert variables, constants, operators and functions (see below). The expression displayed in the field "Expression" can be syntactically tested by clicking on the button "Test". If a syntax error is detected (unknown variable, parenthesis ...), the error is signaled by selecting the part considered as incorrect in the expression. If the expression is correct, a message "OK" is displayed . The same test is performed when exiting of the dialog box by clicking on the button "OK".

Appendix

  1. Variables The variables are designated by a name (key word ). Only the names that are displayed in the list "Variables" can be used as variables To add a variable to the expression, one can directly type its name or select this name in the list then click on the adjacent button Add, or double-click on the name of the variable in the list.
  2. Constants Constants are numerical or alphanumerical values used as it is. The constants must be directly typed in the expression field. Alphanumeric va lues must be written with quotation marks (ʺ). Some variables, when selected in the variable list, can propose a list of predefined values in the dropdown list "Value". So one can select the wished value in the list then click on the adjacent button Add to insert the constant in the expression.
  3. Operators The operators proposed in the group "Operators" can be used in the defined expression. To add an operator to the expression, type it directly or click on the button corresponding to the wished operator.

Remark:

  • The comparison operators ("=", "<>", "<", <=", ">=", ">") compare either two numeric values, or two alphanumeric values . If a value is numerical and the other no, the non numeric value is converted to a numeric value . The result is always a boolean.
  • The operator "+" adds either two numeric values, or two alphanumeric values (string concatenation). If the first value is alphanumerical and the other no ,

the second value is converted t o an alphanumeric value . If the first value is numerical and the other no, the second value is converted to a nu meric value.

  • The operator s " -", "*", "/", "%" (modulo) and "ˆ" (exponentiation) only accept numerical values.
  • The logical operators "AND" and "OR" can be used with two boolean values (logical " AND" or "OR", Boolean result ) or numeric values (bitwise "AND" or "OR", unsigned integer result)
  • The operator XOR can only be used with numeric values, unsigned integer result.
  • The parenthesis "(" and ")" can be used to force the operator priorities.
  1. Functions The functions proposed in the dropdown list "Function" can be used in the defined expression.

The following functions can be used:

a) Mathematical functions:

  • NOT(x): returns the complement value of the boolean or numeric value x.
  • ABS(x): returns the absolute value of the value x.
  • EXP(x): returns the square of the value x.
  • SQRT(x): returns the square root of the value x.
  • LOG(x): returns the decimal logarithm (log base 10) of the value x.
  • LN(x): returns the natural logarithm (log base e) of the value x.
  • ROUND(x): returns the rounded value to the closest integer value of the value x.
  • CEIL(x): returns the rounded value to the closest higher integer value of the value x.
  • FLOOR(x): returns the rounded value to the closest lower integer value of the value x. b) Trigonometric functions:
  • SIN(x): returns the sinus of the value x.
  • COS(x): returns the cosine of the value x.
  • TAN(x): returns the tangent of the value x.
  • ASIN(x): returns the arc sinus of the value x.
  • ACOS(x): returns the arc cosine of the value x.
  • ATAN(x): returns the arc tangent of the value x. c) Conversion functions:
  • STR(x): converts the numeric value x to a character string.
  • VAL(x): converts the character string x to a numeric value.
  • BCDTODEC(x): converts the value x from BCD to decimal.
  • DECTOBCD(x): converts the value x from decimal to BCD.
  • BOOL(x, mask, valtrue): returns a boolean to TRUE if the bitwise AND of the value x with the value mask is either non null if the optional parameter

Appendix

<valtrue> is omitted, or equal to the value of <valtrue> if this parameter is specified. d) String processing functions:

  • LEN(x): returns the length of the character string x.
  • MID(string, start, length): extracts the character substring of <length> characters beginning to the <start> position from the string <string>; the positions start from 0; if the optional parameter <length> is omitted, the end of the string <string> from the position <start> is returned.
  • INSTR(start, str1, str2): searches for the first occurrence of the string <str2> in the string <str1> from the <start> position and returns the position of this string in <strs1> if it is found, else the value -1; the positions start from 0; the parameter <start> is optional (0 by default). Remark: this function can be used to check if a string str2 belongs to a list of strings written as a string list in str1 (strings separated by a c omma for example).
  • INFILE(file, str): searches for the first occurrence of the string <str> in the file <file> and returns the position of this string in the file if it is found, else the value -1. Remark: this function can be used to check if a string bel ongs to a list of strings written as a list in a file. e) Miscellaneous functions:
  • RAND: returns a numeric random value.

The importation function of a text file allows a list of variables to supervise or operators to call to be imp orted in Alert from a text file provided by an external application or a database. The format of the text file is free , provided that data to import can be identified in the file under the form of columns separated by a specific separator (tabulation, comma, semicolon ...). The correspondence between information contained in the file and the properties of variables or operators to import is described by a mapping table fully configurable in the importation dialog box. The importation command can be performed from the main menu (File/Import...) or from the root of the tree view or a station node (Import...) for the variable or user files , from a node of the "Variables" branch (Import > text file) for the variables files or from a node of the "On-Call Management" branch (Import...) for the user files.

The dropdown list Profile specifies the type of importation to perform ("Tag List Configuration" or "User List Configuration"). According with the origin of the command, this selection can be modified or not. The field "File to import " designates the name of the text file to import . Cli ck on the button on the right of this field to browse and select the wished file . The number of lines contained in the file is

...