Personal Web Site Option

Web Site Option

Overview

EnvidasFW systems using the Windows 2000 or XP Professional Operating System can install Microsoft Internet Information Server (IIS) to support a Web Site. The site called EnvidasWeb uses Microsoft Active Server Pages (ASP) technology. The purpose of the site is to expose current and historical monitoring system status to authorized support personnel using only a browser program. The site can be configured through database tables contained in the EnvidasFW database. This database is implemented in Microsoft’s MSDE which is functionally equivalent to the industrial strength MS SQL Server 2000.

The site supports presentation of current readings, calibrations and alarms. Tabular and graphical presentations are available. Ad hoc requests for examination of data histories are supported. It is also possible to check the status of any XML data transfers that have been scheduled for automatic execution.

Configuration of the EnvidasWeb Site is accomplished through a VB.Net Web Application called EFWWebConfig developed by DR DAS. Like the EnvidasWeb site itself, the user need only connect to the site with a browser program to set up the table entries that define the EnvidasWeb Site content.

The EnvidasFW system also supports IP enabled data transfers. Three modes of operation are available:

XML DATA Pushes
XML documents may be automatically transmitted to one or more receiving servers whenever new data is available or on a scheduled basis.
XML Queries
Users may make Ad Hoc or scheduled queries for data in XML format using a http SQL request from a browser or from program code. This provides an open protocol method for data access over any IP enabled path including a dialup networking connection.
Sockets
EnvidasFW loggers respond directly to data tranfers requests over a sockets communication program. DR DAS provides the CommServ program for this purpose. Telnet is also commonly used especially for pass through commincation to devices connected serially to the logger at the site.

Support for the automatic transmission mode is via the DR DAS application, XML Pusher. This optional application is a VB.Net program that is installed either separately or with the EnvidasFW data logger program. XML Pusher requires the EFWWebConfig application. The EnvidasWeb is also included with XML Pusher but it is not a prerequisite. Configuration of XML Pusher is accomplished through EFWWebConfig.

Support for on request XML data query is natively supported in the MSDE environment used in the EnvidasFW system. Contact DR DAS for technical information on utilizing XML for SQL requests.

Support for sockets communications is natively supported by the EnvidasFW program. The XMP Pusher application when used separately also supports a sockets connection, In this case the connection is used with programs like Telnet to communicate directlly to serial devices connected to the XML Puher host PC in the station.

Security

The EnvidasWeb and the EFWWebConfig files are installed in virtual directories, a requirement of ASP and .Net applications. Virtual directories are created and administered using the Internet Information Services Applet found under Control Panel, Administrative Tools.

For security purposes the site security should require that only Users included in the station's EnvidasFW logger or host PC’s Integrated Windows Security be allowed to access the site. Figure 1 below indicates the proper settings. Anonymous access should be disabled and basic and authenticated security enabled. If the logon of the machine being used to access the site has user rights on the EnvidasFW machine access is granted. If not a logon window is presented. Thus, support personnel can securely access the site from any location.

Access to the site may be further restricted by requiring a local web site login that identifies the specific user and can be used to control access to various parts of the site. Figure 2 includes this second level of security.

Figure 1 – Web Site Security Setup in IIS

Site Description

When the EnvidasWeb site is accessed, the default initial page is displayed. This page is usually customized by the user organization to have agency identification, access restriction information, and station specific graphics. An example of the default page default.asp, a report selection page and example report are shown below.

Figure 2 – Default Page

To access the site and use features allowed for your User Name, enter a User Name and password. Then click Log In. The Main Page will appear.

Figure 3

Select Summary to view current values and alarms. The following page will appear:

Figure 4

Click on any Point name to see a graph of the most recent 60 values.

Select Graphs to obtain graphs for any point or combination of point. Use the Ctrl and Shift keys in the normal manner to select more than one point. Line, 3D Line, Bar and 3D Bar graphs are supported. An example appears below.

Figure 5

Select Create Reports to obtain tabular and graphical reports for multiple points.

A tabular report is shown below:

Figure 6

At the end of the report a legend is included to explain the data status codes.

Figure 7

Site Configuration

Configuration of the site is table driven. To enter the configuration information the EnvidasFW unit host a Microsoft.Net web application called EFWWebConfig This application is accessed using a browser allowing the site to be configured remotely.

The Site Configuration Tables consist of 10 Tables as listed below:

Table	Description	Fields
TB_WEB_LOGIN	User records.	LOG_ID – system assigned index UserName – alphanumeric, case sensitive Password – alphanumeric, case sensitive UserGroup – access privileges to site areas are controlled by a User’s Group membership. Group are defined as 0 (default), 1,2,3 in ascending order of access rights
TB_MONITOR_TYPE_NEW	Monitor Names that can be assigned to EnvidasFW Monitors	MOT_MonitorTypeCode – system assigned index MOT_MonitorName – 9 characters max MOT_MonitorFullName – 50 characters max
TB_UNITS	Units names that can be assigned to EnvidasFW Monitors	UNI_UnitsCode – system assigned Index UNI_UnitsName – 6 characters max
TB_STATION	Station records	STA_StationCode – integer: typically 1. STA_SerialCode – integer: Select from list. Codes 1- 3 corresponding to the three averaging periods possible with the EnvidasFW unit. 1 is 1 minute 2 is the selectable average (typically 5,6 or 15 minute) 3 is 60 minute STA_TimeBase – integer: – select from list ( 1,5,6,15,60) Value selected also sets Serial Code STA_ComState - Boolean indication whether station is active. Example Uncheck box of Station with STA_SerialCode = 1 if 1 minute data is not being computed or if it should not be available on the web site. STA_Offset – integer: minutes to delay before presenting new data. STA_StationName – alphanumeric: 40 characters max. STA_MonNumber – integer: number of monitors configured in EnvidasFW STA_Location – alphanumeric: 40 characters max. Address STA_City – alphanumeric: 25 characters max. City, State, Zip STA_Owner – alphanumeric: 50 characters max. Owner name STA_Group – alphanumeric: 25 characters max. Group or Region Name STA_Latitude – alphanumeric: 10 characters max STA_Longitude – alphanumeric: 10 characters max STA_Target – alphanumeric: 35 characters max Used to indicate purpose of station. i.e. SLAMS STA_SupervisorCode – alphanumeric: 50 characters max. Name of supervisor for station. STA_ResponsibleCode – alphanumeric: 50 characters max. Name of responsible technician for station. STA_DateOfEstablish – datetime: date station established STA_Notes – alphanumeric: 255 characters max. Descriptive material. STA_TelephoneNumber – alphanumeric: 15 characters max. Telephone # or IP address
TB_MONITOR_NEW	Monitor records	MON_Station_Code – integer: key to STA_StationCode Select station name from list. MON_MonitorChanel – integer: channel number 1- 64 MON_Monitor_Type – integer: key to select name from list MON_MonitorState – Boolean: indication whether monitor is in use. Check box if in use. MON_MonitorLowRange – real: used to set low end of values for graphs MON_MonitorHighRange – real: used to set high end of values for graphs MON_Units – integer: key to UNI_UnitsCode. Select units name from list MON_Numeric_Format – integer: number of decimals
TB_WEB_PAGEDEFS	Web Page Definition specifies the number of rows and columns to use in presenting monitor values on a web page such as the Summary page. More than one page definition is allowed. Each page has a Title	WPD_PageID – integer ID for Page WPD_Cols – Integer: number of columns WPD_Rows – Integer: number of rows WPD_Title – alphanumeric: 50 character max. This Title appears at top of page
TB_WEB_PAGEITEMS	Page Items Define the station and Monitor for each Web Page Definition	WPI_ID – integer: ID for Item. Automatically assigned. WPI_PageID – integer: key for Web Page Defs Select from list of Web Page Definitions WPI_Col – integer: Select from list showing integers from 1 to Number of Columns for this PageID WPI_Row – integer: Select from list showing integers from 1 to Number of Rows for this PageID WPI_StationCode – integer: Select from list of stations. WPI_MonitorCode – integer: Select from list of monitors Note: WPI_PageID must be entered before WPI_Col and WPI_Row.
TB_WEB_REPORTCONFIGS	Report Configs identify a set of Stations and Monitors to e included in a data listing or graphical report. Multiple reports may be defined	RC_Report_ID – integer: ID for Report Config. RC_ReportName – alphanumeric: 50 characters max. Used to identify report in a selection list on the Reports web page. RC_Interval – integer: used to display the time interval (minutes) for data values in the report. RC_File_Save_PathName – alphanumeric – 50 characters max. Used to specify a temporary file name and location for the html document containing the report. This allows the browser user to Save the report to the browser client drive. RC_OrderOnPage – integer: specifies the order of the report in the list displayed on the Report Web Page. RC_Title1 – alphanumeric: 50 characters max. This is the first line of the Report Title. RC_Title2 – alphanumeric: 50 characters max. This is the second line of the Report Title. RC_Title3 – alphanumeric: 50 characters max. This is the third line of the Report Title.
TB_WEB_COLUMN_DEFS	Identifies Stations and Monitors for each column in a report configuration.	ColumnID - integer: ID assigned automatically. ReportID – integer: key to ReportConfig. Select from Report Config list. OrderInReport – integer: column number from left to right in report table. Station – integer: key to STA_SerialCode. Select Station Name from list. Monitor – integer: key to MON_MonitorChanel. Select Monitor Name from list.