Titanium Schedule Updates

Determining Your Current Version

To determine how to update your version of Titanium Schedule, you need to know the following:

Application version
Database version

These can be determined by starting Titanium Schedule, selecting the Help menu, then choosing Version Information. Below is a sample Version Information screen with the Application version and Database version indicated by the red arrows. Please include these values when contacting Titanium support regarding a program update.

Note: Older versions of Titanium may require some values not shown in the image below, like release date and support library version. It is possible in some very old versions that no release date is displayed on the first line. In that case, the the last 8 digits of the Application version number (e.g. 200091006) is the release date in the format YYYYMMDD.

With that information, you can lookup the steps required to update Titanium Schedule in the sections below. If your current version information does not appear to match any of the sections below, please contact us for assistance.

Click or tap the text below to expand the screen and reveal the instructions.

Your application version is 10.55 or greater and database version is 150101 or greater

Your application version starts with 10 and your database version is 130401

Your application version starts with 10 and your database version is 101201

Your application version starts with 9 and the release date is after 12/15/08

Your database version should be 081201 or 101201, and your support library version should begin with 09.

Do the following:

Start Titanium Schedule
Select the Help menu
Choose Check for Updates option
From the Check for Updates screen, select the Check for Updates button
If any updates are found, select the Install Updates button

Your version 9 will be up-to-date when you select the Check for Updates button and the screen displays: "This version is up to date. There are no new files to install."

The new Titanium Schedule version 10 has been released! The user interface in Titanium Schedule 10 was intentionally kept very similar to Titanium Schedule 9, so there is no need to retrain your staff. Because Titanium Schedule is in use at hundreds of locations, and because the installation of this new version requires some limited interaction between your IT department and our support staff, we plan to update our customers in a managed fashion. We are working hard to get everyone up and running with version 10 as soon as possible. If you would like schedule your update to Titanium Schedule 10, please contact Titanium Support.

Your database version is 071001

Your support library version should begin with 09, and your release date does not matter. It is probably between 12/1/07 and 12/15/08.

Do the following:

Start Titanium Schedule
Select the Help menu
Choose Check for Updates option
From the Check for Updates screen, select the Check for Updates button
If any updates are found, select the Install Updates button

Continue the Check for Updates and Install Updates cycle until you receive a message that there is an update the cannot be installed using the Check for Updates feature. At that point, you should download the instructions and file below for the next phase of the update. This phase will require the assistance of your computer support staff, and no users in your center should be logged-in to Titanium Schedule while this update phase is being installed.

Download update instructions: Update081201.pdf

Download required update file: Update081201.zip

After those files are installed by your computer support staff, you should continue the update process by following the instructions in the section above this one.

Your database version is 040501 and your support library version starts with 09

Your release date does not matter. It is probably between 4/10/06 and 12/1/07.

This is known as the Data Forms update, and it is one of the largest updates to Titanium Schedule. For an overview of the changes and new features, read the What's New in Titanium document.

We strongly recommend that you run this update at the end of a reporting period after you produce your statistics report for that period. There are some changes to both the way the data is stored and to the statistics reports. If you run this update in the middle of a semester and then use a different Data Form for the rest of the semester, it will be very difficult to get accurate client demographics statistics for that semster.

To proceed with this update:

Start Titanium Schedule
Select the Help menu
Choose Check for Updates option
From the Check for Updates screen, select the Check for Updates button
If any updates are found, select the Install Updates button

Continue the Check for Updates and Install Updates cycle until you receive a message that there is an update the cannot be installed using the Check for Updates feature. This next phase of this update will require the assistance of your computer support staff, and no users in your center should be logged-in to Titanium while this update phase is being installed.

Please contact Titanium Support when your computer support is ready to perform this update. In your email, just say you want update to the Data Forms version of Titanium Schedule. We will respond with the instructions and files you need. The files and instructions are not posted on our website and are only available via email.

If you are using the old free version of Microsoft SQL Server called MSDE 2000 to store your Titanium data, you should update to Microsoft SQL Server 2005 or 2008 before doing this update. The free version of SQL Server has been renamed from MSDE to Microsoft SQL Server Express. Although Titanium Schedule will run on SQL Server 2000 and MSDE 2000, the MSDE 2000 version does not include a graphical user interface to perform the steps outlined in our update instructions.

After the update files are installed by your computer support staff, you should continue the update process by following the instructions in the section above this one.

Your support library version starts with 08

Your database version should be 040501. If your database version number is higher than 040501, contact us before proceeding. If your database version number is lower than 040501, you currently have an older version of Titanium Schedule, probably version 7, and you should perform the update described in the section below this one before proceeding with this upgrade. Your release date does not matter. It is probably between 12/22/04 and 4/01/06.

This is an upgrade from Version 8 to Version 9. This upgrade will update the Titanium Schedule application files and workstation support files to Version 9. It does not alter the database files that are stored in Microsoft SQL Server or MSDE.

There will be very little visible difference between the version 8 and version 9 of Titanium Schedule. The files that are being updated are the underlying support files. This will ensure Titanium Schedule is running on the latest released files from Microsoft and make it easier for us to add new features in the future.

To minimize disruption, you can perform the following steps while other users continue to use version 8 of Titanium Schedule.

Download SetupWorkstation90SP1.exe and save it into your Application Folder. (Determining Your Current Version at the top of this page explains how to find your Application Folder.)
On one workstation computer:
- Start Titanium Schedule
- Select the Help menu
- Choose Check for Updates option
- From the Check for Updates screen, select the Check for Updates button
- If any updates are found, select the Install Updates button
This will install the most recent version 8 files and the rest of the files required for version 9.
On every workstation that will be running Titanium Schedule, perform the following steps. (These steps are the same as those for setting up a new workstation and are documented in SetupWorkstation9.pdf)
- Open the application folder and create a shortcut to the file Ti9.exe on the workstation’s desktop (or start menu) to make it easy for that user to start Titanium Schedule.
  
  To create a shortcut, right click and drag the Ti9.exe file from the shared application folder to the desktop. When you release the mouse a menu will appear. Pick “Create Shortcut(s) Here” from the menu. Then rename the shortcut from “Shortcut to Ti9.exe” to “Titanium Schedule”. If you are not logged in as the normal user on that computer, you should move the shortcut to C:\Documents and Settings\All Users\Desktop so it is available to all users of that computer. If you are updating a workstation that is running version 8 of Titanium Schedule, you can edit the existing shortcut so that it points to Ti9.exe instead of Ti8.exe.
- Run SetupWorkstation90SP1.exe from the application folder.
  
  You will need to have Administrator rights on the workstation to successfully run this setup program.
- Reboot the workstation if the setup program requests it.
- Optional: Uninstall the version 8 support files. You can do this using the Control Panel and selecting Add or Remove Programs. Then select the Remove button for the entry titled Titanium Schedule Support Files 8.0 SP1.
Confirm that you are now running version 9 by starting Titanium Schedule and checking that the first digit of your Application Version is 9.
Cleanup the Titanium Schedule Application Folder. After all the workstations have been updated, you can remove the version 8 files from the application folder. We recommend that you move these files to a temporary folder, then delete them in a few weeks if everything goes well with version 9. Removing these files will also help you identify any workstations that were missed during the update process because the old version of Titanium Schedule will no longer run on those computers.

The version 8 files that can be removed from the application folder and eventually deleted are:
- SetupWorkstation80SP1.exe
- SetupWorkstation8.doc
- All the files that start with Ti8 (e.g. Ti8.exe and one or more Ti8??.APP files)
- ConfigData8.exe
- Notify8_*.exe
- You can delete the error log files XErrors.dbf and XErrors.fpt. (They will be recreated the next time someone starts Titanium Schedule.)
- You can delete any temporary files files that have the extension *.tmp

After this update is installed, you should continue the update process by following the instructions in the section above this one.

Your support library version starts with 07 and your database version is 040501

Your database version should be 040501. If your database version number is not 040501, you should perform the update described in the section below this one before proceeding with this upgrade. The release date does not matter. It is probably between older than 12/22/04.

This is an upgrade from Version 7 to Version 8. This is a significant update that must also update the workstation support files.

To upgrade from version 7 to version 8, perform the following:

Update the Shared Application Folder files
- Download SetupWorkstation80SP1.exe and save it to your Application Folder. (Determining Your Current Version at the top of this page explains how to find your Application Folder.)
- Download UpdateVer7ToVer8.zip and unzip it into your Application Folder. You can delete the file Ti8.zip after you have unzipped it.
Repeat the following steps on each workstation that will be running Titanium Schedule:
- Login to the workstation as someone with Administrator level rights.
- Run the file SetupWorkstation80SP1.exe from the application folder.
- Create new shortcut to Ti8.exe in the application folder. (Or you can edit the exiting shortcut for Ti7.exe.)
- Optional: Uninstall the version 7 support files. You can do this using the Control Panel and Add or Remove Programs. The entry for the version 7.0 support files will be Titanium Schedule Support Files 7.0 SP1.
After all workstations have been updated, you can remove the version 7 files from the application folder. We recommend that you move these files to a temporary folder, then delete them in a few weeks if everything goes well with version 8. Removing these files will also help you identify any workstations that were missed during the update, because those users will no longer be able to run version 7.

The version 7 files are:
- SetupWorkstation70SP1.exe
- All the files that start with Ti7 (e.g. Ti7.exe and one or more Ti7??.APP files)
Start Titanium Schedule and select the Help menu, then Check for Updates to see if there is anything else you need to do.

If you are prompted to run the Update Data 10/31/04, you should click here for more information.

After this update is installed, you should continue the update process by following the instructions in the section above this one.

Your support library version starts with 07 and your database version is 030101

Your database version should be 030101. The release date does not matter. It is probably between 1/1/03 and 12/22/04.

This is the final update for Titanium Schedule version 7. This patch will update any previous version of Titanium Schedule to the 12/22/04 version.

Updates to Titanium Schedule are performed using an Update Wizard. This process normally takes 10 to 20 minutes. Perform the following steps:

Create a temporary folder on your computer.
Download TiFullPatch.zip and save it to the temporary folder.
Unzip the file you downloaded into a temporary folder. Do not unzip it into the Titanium Schedule application folder.
Run the file UpdateTitanium.exe from the temporary folder. To run this program, you will need a computer configured to run Titanium Schedule. (If you want to run this update from a computer that is not setup for Titanium Schedule, download and install SetupWorkstation70SP1.exe first.)
The Update Wizard will prompt you for the Titanium Schedule application folder. If you are not sure where the Titanium Schedule application folder is located, start Titanium Schedule, and from the menu select Help, then Version Information. This will open a dialog window and the second line will display the Application Folder location.
Follow the Wizard prompts. What happens next depends on the your current version of Titanium Schedule. You will encounter one of the two scenarios below.
Scenario 1: The update can be applied while others are using Titanium Schedule.
- The Wizard will prompt you with a message indicating that Titanium Schedule can be updated while others are in the system. When you select Next, the update will be applied.
Scenario 2: The update requires everyone to be out of Titanium Schedule before it can be applied.
- The Wizard will prompt you with a message indicating that all users must be out of Titanium Schedule before the update can be applied. It will also indicate you need Database Owner access to the Titanium Schedule database. This type of patch is usually applied after normal work hours and may be done by your computer support staff. If you decide to proceed, the Wizard will attempt to confirm that no one is currently using Titanium Schedule, then lock users out of Titanium Schedule for the duration of the update.
- The Wizard will then prompt you for your SQL Server login information. You must login with Database Owner or higher privileges to apply the update.
- You will be given the opportunity to backup the Titanium Schedule database before proceeding with the update.
Confirm the Update was applied successfully:
- Start Titanium Schedule to see if there are any error messages. (There is an automatic basic system integrity check every time Titanium Schedule is started.) You can also manually check the Titanium Schedule version information by starting Titanium Schedule and, from the main menu, select Help, then Version Information.
  
  The expected version values are:
  Application Version: 12/22/2004
  Database Version: Current: 040501 Required: 040501
- Start Titanium Schedule and select Help, then Check for Updates to see if there is anything else you need to do.
  
  If you are prompted to run the Update Data 10/31/04, you should click here for more information.

Troubleshooting: If you have any problems applying the update, please contact us for assistance. If you can start the Wizard, but it will not complete, please also email us the file UpdateTitanium.log from the temporary folder. That log file contains diagnostic information from the Update Wizard.

After this update is installed, you should continue the update process by following the instructions in the section above this one.

Determining Web Component Version

To determine what version of the Web Component you currently have, open the ConnTest.aspx web page of the Titanium Web Component web site running at your location. You can do this by going to any computer that currently is running the Web Component and, from the start page, change just the last part of the address (WCMenu.aspx) to ConnTest.aspx.

On the third line down from the top of the ConnTest page, under the titles Titanium Web Component and Connection Test, will be your version date. If you do not see this line, you have a very old version, and you definitely need to update your Web Component. If your version date is earlier than the date shown in step 2 below, there is a more recent version you can install.

The browser on your Web Component computer should initially show an address ending with WCMenu.aspx

Change the last part of the address to ConnTest.aspx

The version date of your Web Component is displayed on the third line on the ConnTest screen. Compare that date with the one in step 1 below to determine if you have the latest version. If you do not see this date, you have an old version, and you definitely need to update your Web Component.

Updating an Existing Installation of the Web Component

The latest version is 2020-01-16. If your current version is earlier than the one shown here, contact Titanium Support for a zip file containing the Web Component update.
Every step below is important and must be done in the specified order. This will reduce the number of issues related to things like UAC (User Account Control) blocking files from being modified.
Backup the existing Web Component folder, which is located on your IIS web server. By default, this is C:\Inetpub\wwwroot\Titanium_Web. If you encounter a problem during the update, you can copy your old Web Component files back to this folder to return to the previous version. You will also need your SQL Server connection information from the old web.config file.
Unzip the file you receive from Titanium Support into a temporary folder. Make sure you preserve the folder structure in the zip file so that you have subfolders like bin and Logs.
Copy the SQL Connection string from you old web.config file to the new web.config file in the temporary folder. You can do this by opening the new web.config in the temporary folder and finding the section named <connectionStrings> as shown below. Note only the highlighted line below contains connection information. The rest of the lines are just comments.

Find the same <connectionStrings> section in your old web.config file (from the backup copy of that folder you made earlier). Then, replace the hightlighted line above in the new web.config file with the similar line from your old web.config file.
The steps below will temporarily shut down the Web Component web site and should be done at a time when it is not being used.
In the existing Web Component folder, delete ONLY the bin folder. Do NOT delete the Logs folder. It has specific rights assigned to it. If you delete it, those rights will have to be reassigned, or the application will not be able to write to the error log in that folder.
Copy the new files in the temporary folder to the your existing Web Component folder and overwrite (i.e. Copy and Replace) all the existing files and folders.
Run the ConnTest.aspx page in the Web Component web site and run the first 3 test buttons to see if it is working correctly. If it passes all 3 tests, then ask the center to confirm the Web Component is up and running again.
If the Web Component will not run, contact Titanium technical support. If you need the Web Component to work immediately, then copy the backup you made earlier to the Web Component folder.

Encrypt Communication between the Servers

DO NOT PROCEED with these steps until you have successfully tested the Web Component.

On the web server, open a command prompt window that has “Run as Administrator”
In the command window, change directory to C:\Windows\Microsoft.NET\Framework\v4.0.30319
For the command "aspnet_regiis" below, the path of configuration file is the physical path (not virtual) of the directory/folder where web.config resides. Do not include the name of the file in path. For example, if your web.config path is at C:\TitaniumWeb\web.config, then while encrypting, use the following:

aspnet_regiis –pef “connectionStrings” “C:\TitaniumWeb” –prov “DataProtectionConfigurationProvider”

Enter the command above with the appropriate path to your Web Component web.config in the command window and hit Enter on your keyboard.
Open the file web.config with NotePad or another text editor.
Search for the section titled <connectionStrings>
Now, <connectionStrings> should be immediately followed by <EncryptedData>.

If you need to reverse the encryption, like when moving the Web Component to a new server, use the physical path to your web.config without the file name as explained in Step 3 above. The decryption command is:

aspnet_regiis –pdf “connectionStrings” “C:\TitaniumWeb”