Contents:

• M2006042101 - Scheduled training attendance report shows students with canceled reservations.
  Students with canceled reservations were appearing on the Scheduled Training Attendance report. This has been corrected.
• M2006051701 - Date range not enforced in the "Scheduled Training Attendance Report".
  If a date range was selected when running the "Scheduled Training Attendance Report" and "All" course sections were reported on then the report included sections outside of the selected date range. This has been corrected. The report will no longer show course or lesson sections outside the the selected date range.
• M2006053101 - Date selector won't select June on May 31.
  On days near or on the end of the month the date selector would not allow the user to select a month which contained fewer days than the current date. For example, since June has only 30 days, on May 31 a date in June could not be specified. This has been corrected. 
• M2006053102 - core_vendor truncated to 98 characters under oracle oledb connection with oracle 9.
  A compatibility problem between some places in the web-server application and LONG VARCHAR columns when running under the Oracle OleDB Provider (required for the Oracle 9.x client software) was causing some data elements to be truncated. Specifically, places in the application where a SQL join resulted in more than one LONG column to be included in the column list of a SELECT statement resulted in all long columns in the list to be truncated to 98 characters. This affected the core_vendor field in the "Enter/Edit Results" function and several fields in the communications interface for the Offline Student Module.
  A script has been provide to convert the affected data columns to from LONG VARCHAR to CLOB. In the next release of WBT Manager all LONG VARCHAR columns will be converted to CLOB or NCLOB. 
• M2006060601 - SQL error in Training Schedule (by Date) report.
  A SQL error of "ORA-00933: SQL command not properly ended" was encountered when running the "Training Schedule (by Date)" report. This has been corrected

Installation:

First unzip the patch files to a temporary directory. Copy the web_module directory to the web-server where WBT Manager is installed.

Web-Module:

On the web-server where the WBT Manager Web-Server Application is installed:

Note the NTFS permissions on the WBT Manager DLLs (see "Replaced Files" list below) in the Windows/System32 directory.

If you have a translated version of WBT Manager or have customized the string table (strings.txt ) make a backup copy of strings.txt and update it as described in string table changes  below.

Stop IIS web services (skipping this step may cause a system re-boot to be required after installing the patch).

Run the setup.exe program found in the patch's web_module directory. When prompted for the installation directory select the directory where the WBT Manager web-module is installed.

When the installation is complete re-start IIS. Run the reload.asp script in a browser to verify the installation. If any errors occur verify that the NTFS permissions on the WBT Manager DLLs have not changed. Correct if necessary and re-run reload.asp.

NOTE: If patch190_2 has already been installed then the above installation procedure can be avoided by copying files (there are no DLL changes in patch190_3). Copy the following files from the patch into the indicated directory on the web-server installation:

Copy	To
web_module\standard_files\asp\r_adm7.asp	ASP directory
web_module\standard_files\asp\r_adm9.asp	""      ""
web_module\standard_files\asp\dtpickjs.asp	""      ""
web_module\standard_files\xsl\dtpick.xsl	XSL directory
\web_module\standard_files\xsl\dtpickns4.xsl	""      ""

 

Student import module (not necessary if patch190_2 has already been installed): 

On each system where the student import utilities are installed:

Shut down any instances of the student import utility, status import utility, or any custom programs which use the student import component.

Run the setup.exe program found in the patch's student_import_tools directory. When prompted for the installation directory select the directory where the student import utilities were originally installed.

String Table Changes

This patch will replace the string table (strings.txt ) used by the web module. If you have a translated version of WBT Manager you will need to obtain a new version from your reseller or add the new strings to your existing file.

To update the file yourself:

1. Make a copy of your existing strings.txt file.
2. Translate and change the following entries in the file.
   146021,To change your password enter your current password, the password you would like (2 times), and click "Update" below.  
3. Install the patch.
4. Replace the patch's strings.txt file with your updated one.

Replaced files

Web-Module
Destination	File	Version	Date
\winnt\system32\	wbtman6a.dll	1.9.0.1	2006/01/30  4:10 PM
	wbtman6b.dll	1.9.0.1	2006/01/30  4:10 PM
	wbtman6c.dll	1.9.0.1	2006/01/30  4:10 PM
	wbtman6d.dll	1.9.0.1	2006/01/30  4:10 PM
	wbtman6f.dll	1.9.0.2	2006/01/30  4:11 PM
	wbtman6g.dll	1.9.0.2	2006/01/30  4:11 PM
	wbtman6h.dll	1.9.0.1	2006/01/30  4:11 PM
	wbtman6m.dll	1.9.0.1	2006/01/30  4:11 PM
<web-dir>	strings.txt		2006/01/10  2:54 PM
	global.asa		2005/12/19 10:47 AM
	reload.asp		2005/12/19 10:49 AM
<web-dir>/asp	ahredit2.asp		2005/08/03 10:45 AM
	aicc_int.asp		2005/12/21  1:46 PM
	aicc_int_c1.asp		2005/12/21  1:36 PM
	amenu.asp		2005/08/02  1:51 PM
	asgncls3.asp		2006/01/27 10:38 AM
	asgncls4.asp		2006/01/27 10:39 AM
	auditcodes.inc		2006/01/26 11:38 AM
	cat1c.asp		2006/01/05  7:23 AM
	dtpickjs.asp		2006/05/31  3:11 PM
	enrollcertstud.asp		2006/01/26  1:08 PM
	enrollstud.asp		2006/01/26  1:08 PM
	iltcedit1.asp		2005/08/02  9:51 AM
	iltinstr3.asp		2005/12/08  3:21 PM
	login2.asp		2005/09/13 11:01 AM
	login2a.inc		2005/12/02  9:18 AM
	r_adm2.asp		2005/12/29  1:18 PM
	r_adm4.asp		2006/02/02  3:19 PM
	r_adm7.asp		2006/05/24 10:34 AM
	r_adm8.asp		2006/02/15  3:22 PM
	r_adm9.asp		2006/06/06  3:14 PM
	r_crspr.inc		2006/02/23  8:30 AM
	r_stu5.asp		2006/02/15  3:25 PM
	regstud.asp		2005/12/07  9:56 AM
	reportah.asp		2005/08/03 11:56 AM
	reportah.inc		2006/02/27  9:56 AM
	slfdrop.asp		2006/01/26 11:41 AM
	slfenrol.asp		2006/01/26  1:34 PM
	slfenrollcert.asp		2006/01/26  1:34 PM
	slfresilt.asp		2006/01/26  1:34 PM
	sprofile.asp		2006/01/24  4:11 PM
	wbtconst.inc		2005/08/25  1:36 PM
<web-dir>/xsl	admin2.xsl		2006/02/13 11:27 AM
	ahredit.xsl		2005/08/03 12:00 PM
	amenu.xsl		2005/08/02  2:03 PM
	assign5.xsl		2005/09/02 10:42 AM
	crssel1.xsl		2005/09/06  3:55 PM
	crssel1a.xsl		2005/09/06  4:06 PM
	crssel3.xsl		2005/09/06  3:56 PM
	dtpick.xsl		2006/05/31  2:57 PM
	dtpickns4.xsl		2006/05/31  3:45 PM
	login_a.xsl		2005/08/04 11:54 AM
	login_s.xsl		2005/08/04 11:54 AM
	pw_a.xsl		2006/02/13 11:28 AM
	pw_s.xsl		2006/02/13 11:29 AM
	studnt2.xsl		2006/02/13 11:29 AM

Version 1.9 Patches

Patch 1 - Bug fixes.

• M2005111701 - max_normal check counts lessons in all courses when shared status enabled .
  On a system converted for shared lesson status. If a course had a restriction on the number of lessons allowed in an incomplete state ("Max concurrent lessons" on the "Startup" tab). And if other courses were assigned to the same student. Then the system would count all of the student's incomplete lessons (regardless of which course they belonged to) against the "Max concurrent lessons" limit. This has been corrected. 
• M2006010501 - Flag to hide Certificate Program tree in course catalog does not hide the programs.  
  There is a flag variable in cat1a.inc which can be set to "false" if a client does not use Certificate Programs and does not want the "Certificate Programs" heading to appear on the course catalog page. This flag was having no effect. This has been corrected.  
• M2005092901 - "password" is spelled "passward" in strings.txt #146021.
  Instructions on the user "Edit Profile" page had incorrect spelling of the word "password". This has been corrected. 
• M2006011301 - SQL error in self-reg routine under Oracle.
  A SQL error displayed in the regstud.asp script under Oracle when an attempt was made to self-register a student. This has been corrected.
• M2005082402 - Course results report ignores course category selection.
  When a Course Category was selected as a criteria to the Course Results report all courses were included in the report instead of only courses in the selected category. This has been corrected. 
• M2005122901 - SQL error in Course Progress report for long reports.
  Running a long Course Progress report under SQLServer results in "SQL Server does not exist or access denied". This has been corrected. 
• M2005122101 - Browser information set incorrectly when login expires during an API lesson.
  If a student is in a lesson which uses the SCORM API and their login session times out then they experienced strange behavior after they returned from the lesson unless they closed and re-opened the browser. Typical symptoms were changes to the navigation bar color and button spacing. This has been corrected.

Patch 2 - Bug fixes.

• M2006011701 - Local administrators cannot edit other admins that are selected using the admin selector search function.
  If a local administrator attempted to find and edit an administrator using the administrator selector search function an error was displayed. The desired administrator could be edited if selected by navigating to their assigned hierarchy element using the navigation tree. This has been corrected.
• M2006011702 - Error adding local administrator under Access
  If a local administrator was added through the web-based local administrator interface under the Access DBMS an error ("invalid use of null") occured. This has been corrected.
• M2005121501 - Cannot set page delay to 0 for student account maintenance page.
  If a value of "0" was set in the pagesettings.ini [pagedelay] group for the "smaint" page, a javascript error occured on that page instead of jumping immediately to the student menu. This has been corrected.
• M2006012501 - Add/Edit student in web module complains that Reference ID is duplicated even though local administrators cannot edit Reference ID.
  When a student was added by a local administrator the system displays a message indicating that the student's Rference ID had to be modified to make it unique even though no Reference ID was entered because the local administrator did not have rights to enter one. This has been corrected.
• M2006020201 - SQL error in Course Results report for long reports
  For reports on large populations of students the "Course Results" report displayed an "unable to connect or SQL Server not found" error message under SQL Server. The report has been modified to correct this.
• M2006021301 - Language dropdown on profile edit page displays HTML-encoded value for language names.
  When a language was added whose name contained non-ASCII characters (such as "Français"), the language name displays the HTML encoding for that name ("Français"). This has been corrected.
• M2006021501 - ILT calendar report shows some dates in mm/dd format even when system date format is dd/mm
  (Eur format).
  The ILT Calendar report includes dates in month/day format to indicate the starting date of a week. On systems where UK date format (dd/mm/yyyy) is used the week starting dates were still displayed as mm/dd instead of dd/mm. This has been corrected.
• M2006022701 - Adhoc reports show incorrect TOTTIME
  The Ad-Hoc report generator formats the "total time in lesson" field as hhhh:mm:ss. The formatting code was converting the value from the database incorrectly (the value is in seconds in the database). When a value's remaining seconds was greater than 30, the minute value was increased and the second value decreased. For example: if the value were 150 seconds the report would display 0000:02:30 but 151 seconds displayed as 0000:03:29 instead of 0000:02:31. This has been corrected.
• M2006011801 - Student import returns "Entry modified by another user." if a field in the student's database record contains trailing blanks.
  When updating student records by importing data with the student import utility, if a student record in the database contained leading or trailing blanks in any of its character-type columns, the update was rejected with an "Entry modified by another user" error. This has been corrected. NOTE: this condition was very rare and usually associated with direct manipulation of the student record in the database outside of the WBT Manager application and utilities.

*end of file*