Importation of a Text File

Appendix

The group "Secondary separator" defines an additional parsing level in some columns . Select the concerned column in the dropdown list "Column", and then select the wished separator. By default there is no secondary parsing (choice "None"). The first list displays the content of the selected file with the column parsing corresponding to the selected separators. Select in this list the lines one wishes to import then click on the button "Import" to launch the importation of selected lines. The button "All select" allows the entire file to be selected, with the exception of the lines above the importation line defined in the field "Start importation from line ". The line "1" corresponds to the first line of the file. The importation is performed in function of the mapping defined in the second list. The first column of this list contains the list of tag or user properties that will be affected by the importation. The second column displays the mapping that is defined for the corresponding property under the form of an arithmetic expression of variables (column identifiers: C1, C2 ...) and of numeric or alphanumeric constants (character strings in quotation marks). To create a new mapping for a property , select the wished property in the dropdown list "Property" then define the mapping expression in the adjacent field, by using one of the following methods:

• Typing the expression in the edit field,
• Selection among the proposed values in the dropdown list (following the property),
• Selection of a column in the importation list, by clicking on the header of the wished column,
• Calling of the expression editor (see remark 1) or specific editor of the property ( see remark 2) by clicking on the button on the right of the field. Do not forget to valid the defined expression by clicking on the button "Apply". This action results in the updating of the mapping list. To modify the mapping of a property , select the corresponding li ne in the mapping list . The associated property is automatically selected in the dropdown list "Property" and the defined mapping expression is dis played in the adjacent edit fiel d. Modify the mapping expression by using one of the methods indicated above then validate by clicking on the button "Apply". Remark 1: the expression editor is the same one used in the definition of dynamic (see § 8.5.2 "Definition of an expression"). The variables proposed for the edition of the expression are the columns of importation list under the form C1, C2 ... Remark 2: when configuring the mapping for user importation , the property "Dial number" can be defined several times to define each number of an operator. The format of the expression is specific , under the form of 4 fields separated by a semicolon: <number ID> ; <dial number> ; <number type> ; <number validation> The filed <number ID > defines the number identifier (non null integer) The field <dial number > defines the dial number by the reference to the column containing the wished number (C1, C2 ...) The field <number type > designates the driver selected for the number (ʺVocalʺ, ʺFaxʺ, ʺEmailʺ ...) The field <number validation> defines the validation status of the number (0 or 1).

Use the dial number editor (by clicking on the button on the right of the field ) to define the mapping expression of the dial number. The button Options is only validated for the tag configuration . It gives access to the configuration of some importation options. The configurable properties are defined by the following tables. Tag list configuration

Station Station of the tag (1) Identifier External reference of the alarm tag OPC (0/1) OPC tag, boolean value (0 or 1) Type Tag type (2) Pulsed (0/1) Transitory variable, boolean value (0 or 1) Long message Long alarm message Short message Short alarm message On-call group Group to call on alarm (3) Alarm group Tag group (4) Priority Alarm priority Condition Event condition (5) Condition value Reference value for the defined condition Instruction file Name of the attached instruction file Ack identifier External reference of the acknowledgment tag Ack condition Acknowledgment condition (5) Ack value Reference value for the acknowledgment condition Reset long message Long reset message Reset short message Short reset message Reset on-call group Group to call on reset (3) Reset instruction file Name of the attached instruction file for reset Ack long message Long acknowledgment message Ack short message Short acknowledgment message Ack on-call group Group to call on acknowledgment (3) Ack instruction file Name of the attached instruction file for acknowledgment

(1) The station can be selected among the exist ing stations . If the defined or referred (column) name of station is empty, the station is the local station. (2) The tag type is a numerical code that can be selected in the dropdown list: 0 = variable, 1 = event, 2 = alarm. (3) The on-call group can be selected among the existing groups. If the defined group did not exist, it is created or not according to the chosen option (Options button). A list of groups to call can be defined by using the separator defined in option between each name of group ("/" by default). (4) The tag group can be selected among the existing groups . If the specified group does not exist, it is automatically created. (2) The event condition is a numeric code that can be selected in the dropdown list.

Appendix

User list configuration

Station Station of the user (1) User name Name of the operator User first name First name of the operator Virtual operator Virtual operator, boolean value (0 or 1) Identification code (ID) Numeric identifier code of the operator User password Password of the operator User profile User profile attached to the operator (2) User language Language of the operator (3) User access level Access level of the operator (1, 2 or 3) Dial number Dial number to call the operator (see remark 2 above)

(1) The station can be selected among the existing stations. The choice "(all)" means the user is attached to all stations. If the defined or referred (column) name of station is empty, the station is the local station. (2) The user profile can be selected among the existing profiles. (3) The user language can be selected among the languages proposed in the list.

To avoid having to use 2 different modems for the remote surveillance and maintenance of a supervision station, Alert gives the possibility to share a communication port with remote control software (pcAnyWhere32 versions 7.5 and subsequent, Carbon Copy). The port shared with the remote control software must be declared in Alert (see § 7.1"General options "). This port will be automatically transferred to the remote control software, either at the software launching if the remote control software is already launched at that moment and have reserved the port, or on an explicit de mand of a remote operator. If the remote control software is not active, it is possible to automatically start a remote control session from a remote station.

The procedure to apply is the following:

1. Call Alert from a telephonic handset. After having en tered your ID, you will have to type 2 times on the key "9" of the telephonic keypad. If the command is accepted (authorized user), an acknowledgment message is emitted. If the command is denied, a message as "command denied" is emitted. Hang up! When the line is available, Alert releases the communication port that was used then launches the remote control software. This last have before to be setup to run as "Host PC" on a modem connection using the modem in question.
2. Wait some seconds, then, from the remote control software of the remote PC, call Alert at the same dial number. The remote control session start normally.
3. At the end of the session, close the remote control software on the remote. Alert automatically detects the end of session, closes t he remote control software on the host PC, then retrieves the communication port. If an alarm is detected during a remote control session that requires the usage of the communication port affected to the remote control, the remote operator is warned by a screen message. If the option "Priority to alarms" is validated (see § 7.1"General options"), the message displays the delay remaining before closure of the session. If after this delay, the session is not closed by the user himself, Alert automatically closes the session to retrieve the port and trig the required call. During a remote control session, it is possible to close Alert (from the remote PC), then to launch it again before clos ing the remote control session (after uploading a new version for example). At the end of the session, Alert automatically closes the remote control software then it retrieves its communication port, as the same manner as it has not been closed.

Appendix

Alert can be run as a Windows service. Although this option offers new functionalities , its setup must be done carefully.

Service installation

To activate this functionality, check the box "Application running as Windows service ", in the Alert starting parameters. (See § 7.1.1 "Advanced parameters")

Choose the executing user

As Alert can be run without Windows login, you need to set the Alert executing user. To do this, use the Dcomcnfg tool. (Windows "Start" menu, command "Run", enter "Dcomcnfg" then validate).

In the displayed window, open the DCOM applications list.

(Example with Windows XP)

Click with the mouse right button on the "Alert" icon, the select the "Property" command in the contextual menu. On the displayed dialog box, select the "Identity" tab.

Enter the name and password of the Alert executing user (In the previous example, it is the Administrator).

CAUTION: The choice of the user restricts the OPC server use. As a matter of fact, in normal mode (not as service) the Alert OPC server can only be used by the Alert running user. In such a case you can alw ays use the OPC client if the OPC server is deactivated. (See § 7.2 "Supervision options", button OPC setup: uncheck the box OPC server activated). When running as service, the OPC server is fully operating!

Before starting service: Alert configuration

When Alert is started as service, its user graphic interface is not visible. You can only use the AlertClient interface to connect to Alert. As Alertclient does not offer a full configuration interface (you can setup on -call management and supervision, but neither the communication ports, nor the vocal server, nor general options ...), you should do your Alert configuration before starting it as a service.

Appendix

This driver, built-in with the basic Alert software, allows writing commands to an external application or outputs to be initiated during a call cycle, to signal, for example, the call procedure failure or to request for a relief external call system. The list of available commands can be configured either by accessing to the Command driver setup (see § 5.19 "Communication drivers"), or directly when invoking the Command driver in a user or group property sheet, by clicking on the button on the right of the corresponding Number or Command field. The displayed dialog box shows the list of the defined commands (see § 5.16.1 "Command list").

This driver is a generic driver which is used to call a beeper, receiver system that is only capable of alerting an operator by emitting a beep or a vibration, with optional display of a numeric message. What is characteristic of this type o f paging system is the possibility to use a simple telephonic keyboard to "beep" an operator and to transmit him a numeric message. The interface with the beep manager system is a DTMF interface, with or without vocal server, that interprets DTMF codes se nt by the telephonic keyboard to identify the recipient operator (operator address) and to get the numeric message to transmit. The Beep driver simulat

...