Journyx Timesheet v5.6m3 Upgrade This package will upgrade Journyx Timesheet 5.6 or 5.6m1 or 5.6m2 to version 5.6m3. WARNING! The Timesheet upgrade program must restart the IIS web server for the upgrade to take effect. When IIS is restarted, any other web sites or web applications running on IIS will temporarily unavailable for only a few seconds. The upgrade program will warn you that it needs to restart IIS before it performs the upgrade. You can press Cancel on that dialog box if you do not wish to restart IIS at that time. (The upgrade will also be cancelled.) Simply rerun the upgrade when you are ready to restart IIS. It is essential for recovery purposes that you backup your database before applying these patches. Please be sure to use the backupdb command as described in the instructions below. Be sure to follow the instructions carefully. If you encounter an error message while performing the upgrade process, please copy the error message and send it and any other pertinent information (such as which OS and database you are using) to the Journyx support team at support@journyx.com. Upgrade Process for Windows NT, 2000 and XP This section assumes that the Journyx Timesheet product was installed in the default location - on the C drive in the "Program Files\Journyx" directory. If this is not the case, substitute the actual install location for C:\Program Files\Journyx\ in the instructions below. These instructions, as well as the install script and patches, are delivered in the JournyxTimesheet_56m3_Windows_Patch.zip archive. Unzip this file in the c:\Program Files\Journyx\jwt\bin\ directory. If you use WinZip to extract the zip file, Make sure you enable the unzip to use folder names and extract all the files to the bin directory. This process will create a new folder, 5.6m3_win32_patch, on the hard drive of the Timesheet host machine. Open a Dos Command Prompt shell and navigate to this newly created patch directory and run the install.bat file as outlined below. You will need to run 2 things: the backupdb command to make a backup of your database, and the install command to install the patch. 1) The backupdb command is executed in the c:\Program Files\Journyx\jwt\bin\ directory by typing: backupdb -v c:\[NewFileName] where [NewFileName] is the name of the backup file that you are creating. Do not include the brackets [] in the file name. In our examples we name the backup file backup.jx. You may need to put the entire path to the backup file in double-quotes. Keep a copy of this backup file in a safe location so that it will be available in the unlikely event of an error with the upgrade process. 2) The install command is executed in the c:\Program Files\Journyx\jwt\bin\5.6m3_win32_patch\ directory by typing: install with no qualifiers. *** WARNING -- Some virus scanners have been known to strip out .bat *** (DOS batch file) files from email attachments. In case this *** happens, simply copy the provided install.bak file to install.bat *** and run that. To copy a file, type this in a DOS command *** prompt window: *** *** copy install.bak install.bat *** *** Then type 'install' as above to run the patch upgrade. This is an excerpt of the entire DOS prompt session where both of these commands were executed. C:\>cd "Program Files\Journyx" C:\Program Files\Journyx>cd jwt C:\Program Files\Journyx\jwt>cd bin C:\Program Files\Journyx\jwt\bin>backupdb -v "c:\Program Files\Journyx\backup.jx" Writing file header...Done. ------------------------------------------------------------ Calculating large table backup. This could take some time... ------------------------------------------------------------ TABLENAME READ WRITE --------- ---- ----- trec: 0 of 5981 records [Ok] [Ok] trec: 1006 of 5981 records [Ok] [Ok] trec: 2051 of 5981 records [Ok] [Ok] trec: 3074 of 5981 records [Ok] [Ok] trec: 4159 of 5981 records [Ok] [Ok] ---------------------------------------------------------------- TABLENAME READ WRITE --------- ---- ----- trec2 [Ok] [Ok] [ ... tables cut for brevity ... ] msp_jx [Ok] [Ok] msp_resources [Ok] [Ok] Backup successful. Journyx Timesheet is ready. C:\Program Files\Journyx\jwt\bin>cd *patch C:\Program Files\Journyx\jwt\bin\5.6m3_win32_patch>install Journyx Timesheet Upgrade Utility This program will upgrade your version of Journyx Timesheet to version 5.6m3. Press to Continue... Verifying Prerequisites... Stopping Server... Sleeping (10)... Upgrading scripts Complete Upgrading pyc Complete Upgrading cgi Complete Upgrading htdocs Complete Upgrading lib Complete Upgrading wtlib Complete Starting Server... Scheduling Emailed Reminders. Scheduling Disconnected Client cron actions. The upgrade has completed successfully! Thank you for using Journyx Timesheet Press to Continue... C:\Program Files\Journyx\jwt\bin\5.6m3_win32_patch> The maintenance patches will be installed. Journyx Support Department