TITANIUM
SCHEDULE
Program Updates

Most updates to Titanium Schedule can be installed by a designated center staff member using the Check for Updates feature on the Help menu of your current version of Titanium Schedule. If there is an update that cannot be installed by center staff, the Check for Updates feature will notify you to come to this page for instructions. These updates usually require the brief assistance of your computer support staff, and all users will need to be out of Titanium Schedule while the update is applied.

If you receive the message update files available that cannot be installed automatically while performing Check For Updates, you must update your database schema. This requires a script to be run against your Titanium Schedule database. Please contact Titanium Support to get the database update script and instructions. Use the instructions below to determine your version and include that information in your e-mail.

Determining Your Current Version

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

  1. Application version
  2. 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 is 071001
Your database version is 040501 and your support library version starts with 09
Your support library version starts with 08
Your support library version starts with 07 and your database version is 040501
Your support library version starts with 07 and your database version is 030101
Web Component Updates

The Web Component is an optional Titanium Schedule feature. The Web Component runs on an IIS web server and is updated separately from the main Titanium Schedule program.

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 Database 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
  1. The latest version is 2017-02-13. If your current version is earlier than the one shown here, contact Titanium Support for a zip file containing the Web Component update.

  2. 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.

  3. 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.

  4. 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 Images.

  5. 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.

  6. 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.

  7. In the existing Web Component folder, delete ONLY the bin folder. Do NOT delete the Images 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.

  8. 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.

  9. 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.

  10. 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.

Decrypting Your Connection String
  1. On the web server, open a command prompt window that has “Run as Administrator”
  2. In the command window, change directory to C:\Windows\Microsoft.NET\Framework\v2.0.50727
  3. Copy and paste the following command into the command window, and hit enter on your keyboard: aspnet_regiis –pd “connectionStrings” –app “/TitaniumWeb”
  4. Open the file \inetpub\wwwroot\TitaniumWeb\web.config file with NotePad or another text editor
  5. Search for the section titled <connectionStrings>