Patch 4 - Bug fixes
Date: Feb 23, 2007
Version affected: v1.90.
Notes:
-
This is a
NOT cumulative patch. You should install patch 3 before installing this update.
This patch updates
the web-module string table (strings.txt). If you are using a translated version of WBT Manager you will
need to obtain a translated version from your reseller or translate and add
the new strings to your existing table. If you have modified the standard
version of strings.txt you should make a backup copy before installing the
patch. After installtion restore your customized version and update it with
the changes in this patch. See string table changes for more
information. -
This patch changes the
mechanism which formats the email messages for "forgotten password" emails.
If you have email enabled and have customised the
messages see customizing "forgotten password" messages
below.
Contents:
- M2007020901 -
Overflow error in aicc interface
If a lesson sent a large number
of interactions in a HACP PutInteractions request (more than 32K bytes of
interaction data) the lesson interface experienced an integer overflow error
and the interaction data was not stored. This has been corrected.
- M2006061401 - Adhoc reports cannot be run by
owner without being shared with other admins.
Local administrators who owned adhoc
report definitions could not see those reports when trying to run reports
unless the report was shared with other local administrators. This has
been corrected.
- M2006091501 - System Admin course results reports show
"incomplete" when status is "not attempted".
Course results
reports were originally designed to show "incomplete" as a status for all
courses which were not "completed". This has caused some confusion for
clients and has been changed. Reports will not show "not attempted" for
courses which the student has not yet entered.
- C2006092101 - Report selectors for org hierarchy always show all
hierarchy elements.
The selectors for each level of
student hierarchy elements on the report criteria form was
originally built to display all hierarchy elements at the level being selected
even if a selection had been made at a higher level
which should narrow the selection at lower levels. This has
been changed. When a higher-level hierarchy element has been selected the
selector will only show descendants of that element when
selecting lower-level hierarchy elements.
- M2006110601 - Date selector changes Oct 31 to Oct
1.
When a user attempts to select a day of month that is greater
than the highest day number valid in the current month then the date selector
returns the wrong date (this was a side effect of changes in patch 3 for
"M2006053101 - Date selector won't select June on May 31"). This has
been corrected.
- M2006120401 -
Encrypted passwords accept upper case characters.
The system
administrator module allowed users to enter uppercase characters in the
password field of student and administrator records when password format
was set to "encrypted". Since the web-module login function does not
accept uppercase characters (they are forced to lower-case) those
users were unable to log on. This has been corrected. The system administrator
module will now force passwords to lower-case before encrypting
them.
- M2006113001 -
EMAILPW does not decrypt encrypted passwords.
The original lost
password email function did not decrypt the passwords on systems where
password format was set to "encrypted". This has been corrected.
- M2006070701 -
API applet displays "Press SPACEBAR or ENTER to activate and use this control"
after XP update.
An update to Microsoft Internet Explorer
(required due to a patent dispute settlement) causes IE to require that a user
click on an ActiveX control or Java applet, or hit the spacebar or
enter to activate the user interface of the component. IE displays a
message to that effect for WBT Manager's SCORM API adapter applet. This
does not affect the operation of the API but can cause confusion since the
applet itself is in a hidden frame when the message displays. The course menu
has been modified to prevent the display of the warning
message.
- M2007022001 -
Training schedule report does not restrict the selectable training
categories
The Training Schedule (by Course), Training
Schedule (by Date), Training Calendar, and Scheduled Training Attendance
reports either did not restrict the courses and training categories on their
criteria selection forms to the ones which the user has access to or did not
restrict the courses and training categories actually included in the report
when "All" was selected on the criteria form. This has been corrected. The
reports and their selectors will only show reports and training categories for
which the user's student hierarchy element has enrollment
access.
- M2006112801 - Scripting interface message files do
not support multiple languages.
The files in the msgtemplates directory
which generate success and error pages had text hard-coded into them with
no provision for multiple language support. New files have been provided.
NOTE: these new files will not be installed automatically. See the
installation procedure below.
Installation:
First unzip the patch files to a
temporary directory. Copy the web_module directory to the web-server where WBT
Manager is installed.
System Administrator
Module:
On each system where the WBT Manager System Administrator Module is
installed.
Copy the contents of the administrator_module
folder to the directory where the System Administrator module
was installed (default installation folder is "C:\Program Files\Integrity
eLearning\WBT Manager 1.9").
Web-Module:
On the web-server where the WBT Manager
Web-Server Application is installed:
Copy the web_module folder from the
patch to a convenient temporary location on the web-server.
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.
If you are using the "forgotten password" email link
found on the user login forms you will need to modify some XSL files to
match your email format from emailpw.inc see customizing
"forgotten password" messages below for information about what you will need
to change.
If you are using the External Script Interface scripts
and have modified the files in the msgtemplates directory see Updating the
msgtemplate files.
Shut down IIS services from a
console prompt (execute "NET STOP IISADMIN").
Execute the setup.exe program found
in the web_module directory.
When prompted for an installation
directory browse to the location where the WBT Manager Web-Server Application
is installed.
After installation is completed
check the NTFS permissions on the new versions of the WBT Manager DLLS. Make
any necessary changes to the permissions.
Restore the modified backup copy of
the strings.txt file (as mentioned above) if necessary.
Copy modified versions of emailpw_a.xsl and
emailpw_s.xsl (see customizing "forgotten password"
messages)to the xsl directory.
Copy
modified versions of the msgtemplates
directory files into the msgtemplates directory if necessary.
Set the return email address for forgotten password
email messages if you have not already done so.
Re-Start IIS ("IISRESET" at a
console prompt).
Run the reload.asp script in the
browser to refresh the string table for changes made in this patch.
Verify access to the WBT Manager
Web-Server Application and perform any other desired checks.
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:
- Make a copy of your existing strings.txt
file.
- Translate and change the entries in the file
web_module\string_changes.txt
- Copy the new strings into your backup copy
of strings.txt in the appropriate places (numeric order).
- Install the patch.
- Replace the patch's strings.txt file with
your updated one.
Customizing "forgotten password" messages
As part of the correction for "M2006113001 - EMAILPW
does not decrypt encrypted passwords." the actual generation of the email
messages for forgotten passwords had to be moved inside of
a DLL to allow the password to be decrypted. This means that the emailpw.asp script
can no longer just include the file emailpw.inc to format and send the message. The
mechanism has been changed to and XML/XSL transformation similar
to that used to generate the WBT Manager user interface. The xsl
files used for the transform are emailpw_a.xsl and emailpw_s.xsl.
The standard versions of those files will generate an email
identical to that which the standard version of emailpw.inc did prior to this
patch. If that format is satisfactory then you will not need to modify the XSL
files but you will need to put the "from:" address in the appsettings.ini file
(it used to be in the emailpw.inc file). Add the following keywords in the
"[misc]" group in appsettings.ini. Then change the address and save the
file.
;emailpwreturnadmin and emailpwreturnstud specify the
"from" address to be used in
;"forgotten password" emails (for
administrators and students respectively).
emailpwreturnadmin=null@addressneeded.com
emailpwreturnstud=null@addressneeded.com
To change the actual format of the email you will need
to modify the XSL files noted above. To do so in advance, make copies from
web_module\standard_files\xsl in the patch set. Use a text editor to make any
desired changes. See the WBT Manager Installation and Customization Guide topic
Customizing WBT Manager/Customization-page level changes/Modifying page
layouts with XSL for an overview of how the XML/XSL transform takes
place and for some basics of XSL.
Updating the msgtemplate files
If you have been using the WBT
Manager External Script Interface and need to support multiple languages then
you will need to update the files in the msgtemplates directory with the
versions in this patch. These files will not be installed automatically by
the patch installer. If you have not modified the standard versions of the files
then just copy the versions from the patch directory
web-module\msgtemplates directory. The text which was in the
original files is now in the strings.txt file.
If you need to customize the files
then you can add custom strings to a file called custom-strings.txt using string
ids in the range 980000-990000. Create a custom-strings.txt file for each
language using the same naming convention as for the strings.txt files for each
language. Run reload.asp to load the new string tables. The custom strings can
then be referenced in the msgtemplate files using the same syntax as for
standard strings:
<%=StringItems.LookupValue(g_nLangOffs+980000)%>
After installing the patch to the
web-module copy the modified files into the msgtemplates
directory.
Note: if you are not using the
External Script Interface for anything it is probably a good idea to copy the
new standard versions of the msgtemplates files to your system so that you will
have the standard versions to start with if you require them in the
future.
Replaced files
| System Administrator Module |
| Destination |
File |
Version |
Date |
| Program Files\Integrity eLearning\WBT Manager 1.9 |
wbtman.exe |
1.9.0.1 |
2006/12/04 10:33 AM |
| Program Files\Integrity eLearning\WBT Manager 1.9\reports |
stulst2.rpt |
|
2006/11/24 2:12 PM |
| |
stulst3.rpt |
|
2006/11/24 2:29 PM |
| |
stures1.rpt |
|
2006/09/15 10:00 AM |
| |
stures2.rpt |
|
2006/09/15 10:01 AM |
| |
stures3.rpt |
|
2006/09/15 1:52 PM |
| |
stures4.rpt |
|
2006/09/15 1:49 PM |
| |
|
|
|
| Web-Module |
| Destination |
File |
Version |
Date |
| \winnt\system32\ |
wbtman6g.dll |
1.9.0.5 |
2007/02/09 10:39 AM |
| |
wbtman6t.dll |
1.9.0.2 |
2007/02/23 2:17 PM |
| <web-dir> |
strings.txt |
|
2006/12/06 1:44 PM |
| |
global.asa |
|
2007/02/23 2:02 PM |
| |
reload.asp |
|
2007/02/23 2:02 PM |
| <web-dir>/asp |
crsmenu.asp |
|
2006/06/08 11:55 AM |
| |
crsmenu2.asp |
|
2006/07/20 11:21 AM |
| |
menu.asp |
|
2006/06/30 2:18 PM |
| |
menu.inc |
|
2007/02/28 3:08 PM |
| |
dtpickjs.asp |
|
2006/11/06 2:13 PM |
| |
emailpw.asp |
|
2006/12/12 2:13 PM |
| |
emailpw.inc |
|
2006/12/08 3:13 PM |
| |
r_adm7.asp |
|
2007/02/22 9:11 AM |
| |
r_adm8.asp |
|
2007/02/21 4:05 PM |
| |
r_adm9.asp |
|
2007/02/21 3:40 PM |
| |
r_stu1.asp |
|
2007/02/21 4:19 PM |
| |
report2.asp |
|
2006/06/14 3:56 PM |
| |
selectreporg.asp |
|
2006/09/21 1:47 PM |
| <web-dir>/jar |
docwrite.js |
|
2006/07/07 8:08 AM |
| <web-dir>/xsl |
emailpw_a.xsl |
|
2007/02/23 2:08 PM |
|
emailpw_s.xsl |
|
2007/02/23 2:09 PM |
|
report2_a.xsl |
|
2006/09/21 1:34 PM |
| <web-dir>/msgtemplates |
emailpwer.asp |
|
2006/11/29 2:26 PM |
|
emailpwnf.asp |
|
2006/11/29 2:30 PM |
|
emailpwok.asp |
|
2006/11/29 2:26 PM |
|
enrollcertstudenrolled.asp |
|
2006/11/29 2:26 PM |
|
enrollcertstudfailed.asp |
|
2006/11/29 2:26 PM |
|
enrollcertstudnoprog.asp |
|
2006/11/29 2:26 PM |
|
enrollcertstudnostud.asp |
|
2006/11/29 2:26 PM |
|
enrollcertstudsuccess.asp |
|
2006/11/29 2:26 PM |
|
enrollcertstudsuccessp.asp |
|
2006/11/29 2:25 PM |
|
enrollstudenrolled.asp |
|
2006/11/29 2:29 PM |
|
enrollstudfailed.asp |
|
2006/11/29 2:29 PM |
|
enrollstudnocrs.asp |
|
2006/11/29 2:29 PM |
|
enrollstudnostud.asp |
|
2006/11/29 2:29 PM |
|
enrollstudsuccess.asp |
|
2006/11/29 2:28 PM |
|
regstuddupemail.asp |
|
2006/11/29 2:28 PM |
|
regstudduplogin.asp |
|
2006/11/29 2:28 PM |
|
regstudduprefid.asp |
|
2006/11/29 2:28 PM |
|
regstudfailed.asp |
|
2006/11/29 2:28 PM |
|
regstudmodlogin.asp |
|
2006/11/29 2:24 PM |
|
regstudsuccess.asp |
|
2006/11/29 2:28 PM |
|
verstuderror.asp |
|
2006/11/29 2:28 PM |
|
verstudfound.asp |
|
2006/11/29 2:28 PM |
|
verstudmissing.asp |
|
2006/11/29 2:27 PM |
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.
Patch 3 - Bug
fixes.
-
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
*end of
file*