Name The name of the database to which the Surveyor information will be written. If you are using ODBC, the name is the DSN (Data Source Name) as defined in your ODBC setup. Example: SURVEYOR Name is a text field and follows the guidelines for text input values. Host The name of the machine on which the Surveyor database is stored. Example: hostpc Host is a text field and follows the guidelines for text input values. Port The port number that has been configured for the Surveyor database using ODBC. Example: 1521 Port is a numeric field and follows the guidelines for numeric input values. SID The System ID of the Surveyor database as defined in the ODBC setup. Oracle databases limit the System ID to four characters. Example: ORCL SID is a text field and follows the guidelines for text input values (subject to the field-specific limitations given above). Table Name The name of the table to be created within the Surveyor database named above. Example: surv_staging Table is a text field and follows the guidelines for text input values. Login The login name used to access the Surveyor database. It is used in conjunction with Password. Default is surveyor. Login is a text field and follows the guidelines for text input values. Password The password used to access the Surveyor database. It is used in conjunction with Login. Default is surveyor. Password is a text field and follows the guidelines for text input values.. Web Server Name The name of the Web server through which the gathered data is channeled. This name is used within the Surveyor staging table to identify the group of data gathered, and to expand the sorting and categorizing options available when the data is being analyzed. You can use the Web server machine name, or an alias that describes the type of data it collects. A common use of this field is to label data coming from various channels within your business. Example: telesales Web Server Name is a text field and follows the guidelines for text input values. Debug Flag When this option is set to true, Surveyor writes the time of each database operation to a TIMER log file. This file allows tracking of elapsed time for database transactions. Debug Flag defaults to false. Debug Flag is a true/false field and follows the guidelines for true/false input values. Initial Database Connections Sets the initial number of concurrent database connections, with the number of connections incremented until the defined maximum is reached. The valid range is 1 to 30 with a default value of 3, and the value must be less than or equal to the number of maximum connections. Initial Database Connections is a numeric field and follows the guidelines for numeric input values (subject to the field-specific limitations given above). Maximum Database Connections Sets the maximum number of concurrent database connections allowed, starting from the initial value defined and incrementing until the maximum is reached. Once the maximum number of connections is reached, no more connections are accepted until a currently open connection is closed. The valid range is 1-30 with a default value of 5, and the value must be equal to or greater than the number of initial connections. Maximum Database Connections is a numeric field and follows the guidelines for numeric input values (subject to the field-specific limitations given above). Number of Retries Sets the number of times Surveyor attempts to connect to the defined database. If the database can not be reached after the specified number of attempts, information is stored to a local file. The valid range is 0-30 with a default value of 2. If the value is set to 0, then no retries will be attempted after the first failed attempt and data will then be stored locally. Number of Retries is a numeric field and follows the guidelines for numeric input values (subject to the field-specific limitations given above). Log File Size Sets the maximum size of the info, error, and timer log files. The size is measured in bytes, with a minimum allowed value of 100000 (approximately 97 kilobytes). When the maximum file size is reached, the current log file is saved to the default directory and a new file is started. Consolidator keeps two log files at all times, the current file and the most recent file saved. Log File Size is a numeric field and follows the guidelines for numeric input values (subject to the field-specific limitations given above). Reset Clears changes made since the last save and restores previously saved input. Save Changes Commits changes made to the Consolidator configuration and writes them to the configuration file. View Displays the saved configuration file values. Help Displays this help file. About Displays Surveyor version, build, company, and legal information. Exit Exits the Administration Tool. Changes are not automatically saved on exit. To save changes, click the Save Changes button before exiting. AdminTool "Not Found" Error If you receive a "NOT FOUND" error when loading this tool, you may have a misconfigured web server name. To configure the correct name, edit index.htm in your Rainmaker Surveyor AdminTools\admin directory and correct the following line (replace "www.hostname.com" with your web server name): <FRAME scrolling=auto src="http://www.hostname.com/servlet/setconfig?task=VIEW?URL=www.hostname.com" name="result" noresize scrolling=no marginheight=3 marginwidth=1> Numeric Input Values Numeric input values are limited to the digits 0 (zero) through 9 (nine) only, with no commas or other characters allowed. Text Input Values All text input values are accepted as valid by the Administration Tool. Rainmaker Surveyor will record details in the error log if incorrect or invalid information relating to the database is entered. True/False Input Values Items requiring true/false input accept true as positive input. Any other value entered is read as false, and the feature will not be activated. Input is case-insensitive, so true, TRUE, and True are all considered valid values.