Setting up TMW Operations for TruETA

First available in: TMW Operations 2019.4

Requirements:

You must have system administrator permissions to install and set up TMW Operations.

Before dispatchers can use TruETA, you must set up TMW Operations.

  1. Edit the TMWOperations.exe.config file.

  2. Edit TTS50 file(s).

  3. Run the required SQL scripts.

  4. Configure boards and windows to display TruETA data.

This part of the setup assumes that you have already downloaded the required files, installed, and set up both SystemsLink and WorkCycle. If you have not already done this, you must do it before you edit configuration files and apply SQL scripts. Follow the steps in these topics:

Updating the TMWOperations.exe.config file

  1. Use File Explorer to open the location where you installed TMW Operations.

    image1

  2. Open the TMWOperations.exe.config file in a text editor, such as Notepad++.

  3. Search for the <Client> section.

  4. Find the following endpoints and make changes as needed:

    Field definitions
    Endpoint service Value

    VersionService.svc

    Replace the default URL (such as http://localhost/SystemsLink-OppSprint/) with the URL to your company’s SystemsLink installation where the VersionService.svc file is located.

    Example string:

    The part in blue is an example of what you would need to change. Do not change anything else in this endpoint.

    <endpoint address="http://MAY-DOC-APP01/SystemsLinkTruETA.MiddleTierServices/VersionService.svc" binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IVersionService" contract="VersionService.IVersionService" name="BasicHttpBinding_IVersionService" />`

    HosService.svc

    Replace the default URL (such as http://localhost/SystemsLink-OppSprint/) with the URL to your company’s SystemsLink installation where the HosService.svc file is located.

    Example string:

    The part in blue is an example of what you would need to change. Do not change anything else in this endpoint.

    <endpoint address="http://MAY-DOC-APP01/SystemsLinkTruETA.TMW/Wrapper/HosService.svc" binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IVersionService" contract="VersionService.IVersionService" name="BasicHttpBinding_IVersionService" />

    TruEtaServiceInternal.svc

    Replace the default URL (such as http://localhost/SystemsLink-OppSprint/) with the URL to your company’s SystemsLink installation where the TruEtaServiceInternal.svc file is located.

    Example string:

    The part in blue is an example of what you would need to change. Do not change anything else in this endpoint.

    <endpoint address="http://MAY-DOC-APP01/SystemsLinkTruETA.TMW/Wrapper/TruEtaServiceInternal.svc" binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IVersionService" contract="VersionService.IVersionService" name="BasicHttpBinding_IVersionService" />

  5. Search for the <appSettings> section.

  6. Set the SystemsLinkEnabled setting to Y. This setting enables TMW Operations to connect to SystemsLink.

  7. Save your changes.

  8. Back up this file so you do not have to make these changes after future upgrades.

Updating the TTS50 file or files

You must update your TTS50 file or files before using TruETA.

  1. If your company uses a different TTS50 for SystemsLink than for TMW Operations, you must make these changes in both TTS50 files.

  2. If your company installed TMW Operations on local machines, you must update all instances of the TTS50 files.

  3. If your TTS50 file or files are missing the [TruETA] section or any setting, add them before specifying a value.

To update the TTS50 file(s):

  1. Use File Explorer and open the location of your TTS50 file(s).

    image1

  2. Open the tts50.ini file in a text editor, such as Notepad++.

  3. Update these settings in the [TruETA] section.

  4. Make changes to other TruETA INI settings as needed.

  5. In the [Environment] section, verify that SystemOwner=TMW. If it does not, make changes as needed.

  6. Save your changes.

  7. Back up this file so you do not have to make these changes after future upgrades.

Running the required SQL scripts

  1. Open Microsoft® SQL Server™ and connect to the server that hosts your TMWSuite database.

  2. Use File Explorer and open the location where you installed SystemsLink.

    image2

  3. Double-click on the SQL_20XX folder.

    image3

  4. Run the following scripts against your TMWSuite database:

    • ETSDBMods.sql

    • WebEnterpriseDBMods.sql

Working with the TruETAPrePlanning column in the Planning Worksheet

Dispatchers can use the TruETAPrePlan column in the Planning Worksheet to pre-plan a driver’s trip. This column is active by default. You can move the column as needed. For details on rearranging columns, see Reordering columns.

TruETA tries to determine if a driver would be early, on time, or late for a trip by performing a series of TruETA calculations. This column displays the driver’s name in three colors based on those calculations.

When the driver’s name is:

  • Green
    The driver would be on time.

  • Red
    The driver would be late.

  • Yellow
    The driver is at risk of being late.

This illustration shows an example of what the column looks like for dispatchers.

image4

To deactivate this column:

  1. Use File Explorer and open the location of your TTS50 file(s).

  2. Open the tts50.ini file in a text editor, such as Notepad++.

  3. In the [.NetOperations] section, set PlanningWorksheetTruETAPrePlanEnabled to N.

  4. Re-open TMW Operations.

Setting up Chaining Trips

For information on Chaining Trips, see Chaining trips together.

You must have the following for Chaining Trips to function as expected: