These are the Release Notes for the 2007 DST Change Patch (revision 1) for NetResults ProblemTracker version 5.5 (5.5, 5.5.1, 5.5.2, 5.5.3, and 5.5.4). This is the version on our web site. It was most recently updated on March 03, 2007. To make the process of applying the patch as smooth as possible, please review the information below and contact NetResults Technical Support with any questions you have before applying the patch.
For 2007 (and beyond), DST in the following time zones starts the second Sunday in March (instead of the first Sunday in April) and ends on the first Sunday in November (instead of the last Sunday in October).
This patch updates your ProblemTracker installation to use the new DST change dates for 2007 (and beyond) for the time zones listed above.
If your installation does not use any of these time zones, then you do not need to immediately install this patch. However, we still recommend that you install the patch now so that if one of your users does change their personal Time Zone preference to one of the affected time zones, the times that they enter into the system will be stored correctly. If you do not apply this patch and one of your users does select one of the affected time zones, date/time values which are displayed to or entered by them may be off by one hour.
The patch files are included in a zip archive named PT_55_DST_Changes_rev1.zip. The patch has two components: a file with the new time zone information (PTTimeZone.inc) and a file with software to update any dates in your database that may have been incorrectly stored (pt_dst_changes_rev1.asp). It also includes a copy of this readme file (pt_55_dst_changes_readme_rev1.htm).
ProblemTracker stores all date/time information in the database in a single common time zone (UTC). When storing or displaying dates, it automatically converts from the user's time zone to UTC (or vice versa). With the new time zone information file (PTTimeZone.inc) installed, date/time values entered by (displayed to) a user in one of affected time zones will properly take into account the new DST change dates. The update software (pt_dst_changes_rev1.asp) is provided to correct (if necessary) dates between the old and new DST change dates (for instance, between March 11, 2007 and April 1, 2007) that may have already been entered by a user in one of the affected time zones. The update software will scan your database for any such dates. Where possible, it will automatically adjust them (subtract by 1 hour). Otherwise, it will provide a list of potentially affected Records, Alerts, Saved Queries and/or Saved Charts. If none of the affected time zones are in use by any of your users, no dates will be changed. If none of the dates in your database fall between the old and new DST change dates (for instance, if users never enter "future" dates), no dates will be changed. The Record History (audit trail) and Discussion (thread/message) dates will not be modified because they are never entered (and can not be modified) by an end user. They are always retrieved from the web server operating system (Windows) and stored in the database in UTC. They are only converted for display.
Prior to installing this patch, you must do the following.
1. Apply the Windows Operating System DST Patch
Prior to updating ProblemTracker, you must update the Windows operating system on the web server machine on which ProblemTracker is installed. Information on how to update your Windows operating system to handle the new DST change dates is available from Microsoft. Some of the relevant articles from Microsoft Support are listed below.
2. Backup your ProblemTracker Installation
Details on how to backup your installation are available in the following ProblemTracker Knowledge Base article.
After you have followed the instructions in the 'Prior to Installing the Patch' section (above), follow the instructions below to apply this patch to your ProblemTracker installation.
On the web server machine where ProblemTracker is installed, login to Windows as local Administrator (or an user in the local Administrators group).
Login to Workgroup Management System (WMS) as ptadmin in a new browser.
Click on Admin icon in the tool bar. Select the option (View Common Parameters used by WMS) and click the Continue button.
In the 'View Global Information' page, write down the value for Web Directory. You will need this value later in this process. By default, it will be C:\Inetpub\wwwroot\ProblemTracker. It may be a value other than the default, if the default was overridden during the original installation.
Block all your workgroups. To block all workgroups, do the following:
You have blocked user access to all your workgroups.
Unzip the PT_55_DST_Changes_rev1.zip file into a temporary directory (for example, C:\temp). The patch should contain the following files:
Copy the file: PTTimeZone.inc into the following directory:
Copy the file: pt_dst_changes_rev1.asp into the following directory:
If you have created a custom login page (modified logintop.inc or loginbottom.inc files) for any of your workgroups, make certain you have saved a copy of the modified logintop.inc and/or loginbottom.inc files before performing the next step (step 10 - repair workgroups). Then, after performing step 10, copy the saved logintop.inc and/or loginbottom.inc files back into each workgroup. See the Customizing the Login Page section of the Administration Guide for further information. To find the disk location of each workgroup, click the Home icon in the WMS and note the path in the Location column on the Home page.
Repair each of your workgroups. To repair each workgroup, do the following:
This repair operation copies the patch files to each workgroup. Perform steps 10-a to 10-d (above) for each of your workgroups.
Open a new web browser, and browse to:
http://<Web Server Name>/<Workgroup>/pt_dst_changes_rev1.asp
where <Web Server Name> is the web server where ProblemTracker is installed and <Workgroup> is the name of the workgroup.
Follow the instructions on the pt_dst_changes_rev1.asp page and complete updating the workgroup database with the DST changes and then close the web browser.
After successfully updating the workgroup database, delete the pt_dst_changes_rev1.asp file from the workgroup directory.
Perform steps 9 to 13 (above) for each of your workgroups.
Unblock all your workgroups. To unblock all workgroups, do the following:
You have unblocked user access to all your workgroups.
Logoff Workgroup Management System (WMS) and close your web browser.
Delete the pt_dst_changes_rev1.asp file from the following directory: <Web Directory>\pttemplate, where <Web Directory> is the directory you looked up in step 4.
If you have any questions regarding this patch, please contact NetResults Technical Support.