CTS (CUSTOM TRACK SERVICE) V5.5 UPDATES Caterpillar

CTS (CUSTOM TRACK SERVICE) V5.5 UPDATES

An updated CD-Rom for CTS version 5.5 was recently shipped to subscribers of media number JMRC7100.  This CD is for new installations and for updating previous versions of CTS 5.5.  One CD was shipped to each subscribing dealer.

To purchase a new CTS subscription, order literature number JMRC7100.  Use literature number JERC7102 to order additional copies of the CD.

Updates*

• Many updates performed to models, Undercarriage Codes, and part numbers
• Various enhancements and bug fixes throughout the program
• Unit of measures displayed according to preferences in all text reports
• Four Track Assurance Certificates were updated
• Four filters used in the Track in Field check were updated
• Installation options were added to support remote installs by information technology personnel
• Calculation of Original undercarriage cost was corrected
• An update of the Undercarriage Selector (UCS) software to add the D3, D4, and D8 models
• Part prices, effective January 28, 2007, were updated
• The February 2007 electronic version of the Parts Sales Kit (PSK)
• D6K XL, D6K LGP models were added

*Please reference Attachment 1 for more details on the updates.

Installation Test

After updating, when the question mark icon  in CTS is pressed, the ?CTS Version? should be 5.5.3 and the ?Date Last Updated? should be 2/14/2007.

Updating central dealer CTS database

With each CTS release there is a database update utility that has to be executed against the central dealer database if one exists.  This ensures the central database is structurally consistent with the current CTS release as well as applies any database corrections that may have occurred since the previous release.  See attachment 2 for details on completing.  Depending on the size of the dealer?s central CTS database this process can take several hours and should be performed during ?off hours? when PSSRs are not attempting to update to it.

Support

To find out if your dealership is registered for the subscription, or for assistance with the program, contact the Custom Track Service Helpdesk.  Hotline hours are from 6:00AM to 7:00PM Central Standard Time.  The Helpdesk can be reached as follows:

?         US and Canada  (888) 826-5585

?         Other Countries  (309) 266-1036

?         Fax                     (309) 263-0127

?         E-mail                 CTS@CatSupport.com

Summary

This important sales application is designed to make the process of managing undercarriage efficient and flexible.  Updates to this version make it easier than ever to demonstrate the value of Cat^? undercarriage and to minimize cost per hour.

Mark E. Hill                                                                  Allyson M. Pete                              

Undercarriage Marketing                                           Technical Marketing Intern         

Marketing & Product Support Division                     Marketing & Product Support Division

CV4111- Tel (309) 675-7878                                    Email: Pete_Allyson@cat.com

Email: Hill_Mark_E@cat.com

Attachment 1

Key features of this update to CTS 5.5

• Database

o          Part Master table- approximately 1,000 part numbers had their Business Economics Commodity Code added.

o          Undercarriage Code Table- access restrictions preventing editing or deleting of Nexus undercarriage codes were implemented.  Also, when adding dealer defined undercarriage codes, Nexus codes are available for selection.

o          Parts for the D6K model were added.

• Reports

o          Inspection History report- Track sag is displayed in the unit of measure configured in Preferences.  Previously it was always in inches.

o          Inspection Text reports- the unit of measure defined in Preferences is used to display inspection measurements in all text reports. 

o          Four English version Track Assurance certificates were updated, specifically Undercarriage Assurance, Undercarriage Assurance Gold, SystemOne^? Leakage & Breakage, and SystemOne Wear Life.

• Installation

o          ?Silent? install capabilities have been added so IT personnel can remotely install CTS.  Reference the Readme file contained on the installation CD for detailed instructions.

• UCS Module

o          When CTS part prices are updated using a CTSExportedParts.zip file the user is prompted to update UCS related prices the next time UCS is invoked from CTS.  This functionality was available previously for manually entered or updated part numbers.

o          To increase the usefulness of the Undercarriage Selector in creating cost per hour comparisons several models were added.  The base models that were added are D3G, D3C, D4G, D4C, D8N, D8R, and D8T.

Attachment 2

Applying the database update utility to the central dealer CTS database

Description:  This procedure identifies the steps required to apply the database update utility to a centralized CTS dealer database.  This is necessary to ensure the central database is structurally consistent with the current CTS release as well as ensures any database corrections that may have occurred since the previous release are applied.

Pre-requisites:  The utility should be run at a time when no dealer personnel are accessing the central CTS database.  The size of the central dealer database is a factor in the amount of time required to complete.  The larger the database the longer this process requires.  For rough estimates:  a 30-80 megabyte database took 6-12 minutes to run the update against.

Step 1:  Backup the central dealer database.

1.      Copy the current central dealer CTS database and store in safe location.  Depending on dealership network drive access privileges, assistance may be needed from dealer IT staff to complete the back up of the database.

Step 2:  Run database update utility against the central dealer CTS database.

1.      The database update utility is in the Programs subdirectory under the default CTS install directory (i.e. C:\Program Files\Caterpillar\Custom Track Service v5.5).

2.      Double click on the program named CTS55DataUpdate (complete filename if file extensions shown -> CTS55DataUpdate.exe).  The window below is shown:

3.      In the Database field either type the path including the database file name to the central dealer CTS database.  Another option, click the browse button at the end of the field and use the ?Open? window to find and select the central dealer CTS database.

4.      After selecting the current dealer CTS database, click the Update button.  You will then be prompted whether you want to update prices.  Click ?Yes? button if you want the most current suggested consumer list prices to be updated in CTS.

While the update is running the ?Overall Process? and ?Current Process? meters will be updated to reflect the status of the update.