html based trend facility

The package is a zip file containing:

All the files must be located in the "website" folder of the machine you will use as a server (either IIS server or RTES32 webhost).

OPTIONS.XML may be adited as a text file (notepad) and allows you to define the parameters for your specific installation. This file is read trendx3.htm on loading.

OPTIONS.XML Parameters
METHOD/SELECTED-METHOD You have 3 choices: FSA, ADO or IIS

FSAThe working files are in the RTES32 webhost folder.

The database is a .csv file located on you computer, or a mapped remote drive.

ADOThe working files are in the RTES32 webhost folder.

The database is an ODBC entry defined as a DSN (Data Source Name) on you computer, or a mapped remote drive.

IISThe working files are in the default folder of your IIS server.

The database is an ODBC entry defined as a DSN (Data Source Name) on the IIS server.

DSN/UID The username that you defined for the DSN. This parameter is ignored when you selected the FSA method.
DSN/PSW The password that you defined for the DSN. This parameter is ignored when you selected the FSA method.
DSN/NAME The name that you defined for the DSN. This parameter is ignored when you selected the FSA method.
TABLE-FIELDS/TABLE The name of the table you will be reading data from. This parameter is ignored when you selected the FSA method.
TABLE-FIELDS/INDEX The name of the 'index' field. This parameter is used to read the records in chronological order. This parameter is ignored when you selected the FSA method.
TABLE-FIELDS/X-AXIS The name of the field that will be used for the x axis. This maybe a date and time stamp, or a time stamp.
TREND/TIME-ASCII This parameter is used to format (or not) the x-axis data. If YES, then there is no formating, if NO, then the system attempts to make the data look like HH:MM.
TREND/WHERE This is an optional parameter used to filter the data read through ODBC. It could be any SQL 'where' clause. This parameter is ignored when you selected the FSA method.

When using the IIS method, the server must be prepared with : IIS, an ODBC Data source.and .NET Framework

IIS : Internet Information Service is part of Windows XP and is installed as an option. This link will help you set it up.

ODBC: The file where you will be recording the data (via WSQL or similar) must be set up as a DSN (Data Source Name). This page summarizes how to create a DSN:

This page summarizes how to create a DSN:

.NET may be downloaded from. Microsoft

Everything in JScript except codbc.aspx - that one is in C#, using the .NET platform that will open up a few doors into the future.

Once all the files are installed, you may run the application from any computer that has access to server - via it's IP address xxx.xxx.xxx.xxx from your browser set at: http://xxx.xxx.xxx.xxx/trendx3.htm

You may also run it from the server as http://localhost/trendx3.htm

If you are on the same LAN as the server, you may use the machine name inlieu of it's IP address (e.g: http://dataserver/trendx3.htm)