Installing SystemsLink

These instructions represent a typical installation for all variants of SystemsLink.

Deviations from these installation instructions may result in unexpected results.

The instructions in this guide are for use with SystemsLink versions 2016.3 and later.

Prerequisites and requirements

You must have system administration rights on the target machine(s) to install and configure the required software.

Hardware

  • Processor: Quad core processor, 2.4 GHz or faster with 16GB RAM

  • Internal server storage: 250GB Serial ATA (SATA) drive

  • External server storage: minimum of four 146GB hard drives (using the RAID configuration, for backups)

Software

  • Microsoft Windows 2008 R2 Server or later

  • Internet Information Services (IIS) version 7 or later

  • Microsoft .NET Framework 4.7.2

  • Verify the .NET Framework 4.5 WCF HTTP Activation feature is turned on:

    1. Open Server Manager.

    2. On the Dashboard, select Add roles and features.
      The Add Roles and Features Wizard window opens.

    3. In the navigation pane, select Server Selection.

    4. In the navigation pane, select Features.

    5. Go to .NET Framework 4.5 Features > WCF Services.

    6. Verify that the HTTP Activation checkbox is selected.

      image1

Internal server

  • SQL connectivity for the database

  • SystemsLink license

  • Mileage interface software for order-mileage calculation. For a list of supported software, contact Trimble Transportation Support.

  • TMWSuite 2016.15_07.0311 or newer, including the corresponding TMWSuite database

  • TMWSuite user account with access to the TMWSuite Dispatch application. You can set this up in TMWSuite System Administration.

    image2

  • Ttslocal.ini file pointing to the TMWSuite Dispatch server and database

  • Tts50.ini file pointing to the appropriate Ttslocal.ini file. Ensure the following settings are in the [Misc] section:

    • GlobalLogon=No

    • UserWindowsAuthentication=N

External server

  • Public domain name with dynamic IP address

  • Public static IP address, with or without a public domain name

Download the SystemsLink installation files from Trimble ClientCenter.

  1. Use the Line of Business, Product, and Build fields on the Downloads page to locate the TMW Web Products build that you want to download. SystemsLink is contained within the installer.

  2. Select the build you want and click View Details.
    The Software Delivery Files page opens. The top of the page displays notes about the selected build.

  3. Review the notes and select the I have reviewed the notes above provided by Trimble for this download checkbox.
    The middle section of the page shows a Download link appears next to each file in the list.

  4. Click the Download link for the files you want.

  5. Save them in an appropriate location.

For more information about downloading files from ClientCenter, see Downloading product updates in the ClientCenter online help.

Setup methods

These methods are valid for all variants of SystemsLink. Deviations from the given methods may result in unexpected behavior.

Multi-server setup

Trimble’s recommended setup is to install SystemsLink internal and external modules on separate servers, with the external module connected to the Internet. In this configuration, shown in the illustration below, SystemsLink can accept secured requests from authorized outside sources while remaining protected by a firewall.

image3

Before installing the external module in the recommended setup, ensure the external server can communicate with the internal server and the licensing server.

To perform the recommended setup, follow the instructions in these topics in this order:

Internal-module-only setup

SystemsLink does not require the external module. The illustration below shows a setup using only the internal module, allowing customer programs to communicate with SystemsLink directly.

image4

To perform the internal-module-only setup, follow the instructions in Installing the SystemsLink internal module.

Single-server setup

If necessary, you can install both the internal and external modules of SystemsLink on the same server.

For this setup, first follow the instructions in Installing the SystemsLink internal module. Then, perform the following steps.

  1. Follow steps 1-3 of Modifying an existing SystemsLink installation.

  2. Follow steps 5-9 of Installing the SystemsLink external module.

  3. Verify that the Install Type in the Installation Review window is Modify.

  4. Click Begin Installation to begin the modification process.

  5. If the installation was successful, click Finish to exit.

If an error or failure occurred, check the log file. If you cannot resolve the error or failure, provide a description of the problem and a copy of the log file to Trimble Transportation Support.

Installing the SystemsLink internal module

Before you begin, review the prerequisites and requirements.

  1. Extract the installer to the target machine. Repeat this step for each machine.
    Note: Keep a copy of the installer in case you need to upgrade, repair, or delete SystemsLink.

  2. As an administrator, run the installer.

  3. Click Install Trimble Transportation Products.
    Note: The About Trimble Transportation Products and Resources links do not contain information relevant to installing SystemsLink.

  4. In the License Information window, enter:

    • Your ClientCenter credentials

    • The environment in which you are installing SystemsLink

  5. Click Login.

    image5

    If the login fails after multiple attempts or you do not have a valid license for SystemsLink, contact Trimble Transportation Support.

  6. After successfully logging in, click Next.

  7. In the Installation Type window, select New Installation.

  8. Set the Available Instances field value at 01 for a first time install.

  9. Give a name for the instance and press TAB.
    Note: You will need the instance name later in the installation process.

    image6

  10. Click Next.

  11. In the Products window, select the following products:

    • Licensing

    • SystemsLink

    • WebProducts

    image7

  12. Change the installation path if needed, then click Next.

  13. In the Setup window, select the following services:

    • Licensing API

    • WCF Services

    • Imaging Services

    • Web Framework WCF Services

  14. If you do not have an existing web framework database to use, select Web Framework under the SQL Installations section. Otherwise, continue to the next step.

  15. Select SystemsLink Core API.

    Warning: You cannot install non-Fuel and Fuel services in the same instance. If both non-Fuel and Fuel services are selected in the Setup window, the Next button will be disabled until your selections are corrected.

  16. Click Next.

  17. Confirm whether requirements are met in the Requirements window.

    image9

    Click Next if at least one of the following is true:

    • All requirements are met

    • One or both browser requirements are not met, but all other requirements are met

    Click Cancel if one or both of the following are true:

    • The IIS and/or ASP.NET requirement is not met

    • The SQL server requirement is not met and you are installing a version of SystemsLink that is earlier than 2017.3

      As of version 2017.3, the minimum SQL Server requirement is 2008 R2. If your machine does not have this version installed, and you are installing version 2017.3 or higher, you will be prompted to install the SQL Server 2008 R2 CLR Types and Shared Management Objects (SMO). They are included with the installer.

  18. In the IIS Setup window, make entries in the following fields for each service that you are installing.

    Field Definition

    Auto Warmup Sites

    For SystemsLink installation, be sure that this checkbox is cleared.

    Web Site

    The root-level web site in IIS Manager defaults to Default Web Site. Select the name of your web site.

    Virtual Directory Name

    The virtual directory receives queries and directs each query to the appropriate data source.

    The default name for the services virtual directory appears in the field. If you want, enter another name for the virtual directory.

    Is SSL?

    First available in TMW Web Products 2018.2

    Select this option if the service is using Secure Socket Layer (SSL).

    Ext. Host

    First available in TMW Web Products 2018.2

    Select this option if the URL for the service will be called externally.

    Application Pool Name

    In IIS 7.0 and later, you group your web applications and services by assigning each to an application pool. Applications that call similar processes could be in the same application pool.

    The default name for the application pool appears in the field. If you want, enter another name for the application pool.

  19. Click Next.

  20. In the SQL Setup window, specify the location and login credentials for the Web Framework database.
    If you need to create the framework database, click image11 Create New Database. Then, enter a unique database name in the text box that appears in the Database column.

    Note: For the recommended multi-server setup, create the framework database on the external web application server.

  21. Specify the location and login credentials for the TMW Operations database.

    image12

    Field Definition

    Server

    Select the server from the list. If you are installing version 2016.4 or above, you can manually enter the name of the server.

    Username

    Enter a user name used to connect to the server.

    The user must have system administrator privileges for the server.

    Password

    Enter the password used to connect to the server.

    Database

    Select the TMWSuite database.

  22. Click Test Connections. A successful test will display two checkmarks.image13

  23. If the test was successful and all other information is correct, click Next.

  24. In the TTS Setup window, enter the locations and names of the Tts50.ini and Ttslocal.ini files.

  25. Enter the username and password for the TMWSuite user account with access to the TMWSuite Dispatch application as specified in Internal server, then press TAB.

    image14

  26. Check for any errors, indicated by a red highlight surrounding a field, then do one of the following:

    • If there are no errors, click Next.

    • If there are errors, you must correct the information in those fields before continuing.

    Once any errors are corrected, press TAB, then click Next.

  27. In the SystemsLink Setup window, configure settings based on their descriptions in the table below.

    image15

    Note: This illustration and table represents some settings used by SystemsLink. Others may require configuration depending on your setup. Contact Trimble Transportation Support if you need to use or enable any of these optional settings:

    • First Stop Default Event

    • Last Stop Default Event

    • Customer Unique OrderRefType

    • Customer Unique Order Required

    • Suppress Order Warning Messages

    Field Details

    Message Mode

    The Detail option is selected by default. Select Friendly.

    Date/Time Reset Mode

    Specify how the system will calculate or recalculate travel times and adjust the dates/times for stops.

    • If you select Manual, the system does not update dates/times automatically.

    • To update arrival/departure times automatically using the travel times stored in the mileage database, select TMWSuite.

    Prevent DB Update on Validation Errors

    Select the checkbox to prevent changes in the database when a validation error occurs.

    Clear Mileage Cache

    Select the checkbox to delete previous mileage amounts from the system’s mileage cache.

    Application Insights

    Records performance and usage metrics. Valid values are:

    • Basic (default)

    • Exceptions

    • None

    CustomerName

    Enter a unique name to represent this instance of SystemsLink. With it, Trimble can capture data that can be used in troubleshooting.

    Username

    Enter the WebProducts Framework Service username.

    Password

    Enter the password for the WebProducts Framework Service username.

  1. Verify that all settings have been filled out correctly, and then click Next.

  2. On the Installation Review window, click Begin Installation.

  3. Check the Success column to see the result of the installation. The icon indicates whether the installation is successful. If successful, click Launch to open the SystemsLink test-connection page.

    Icon Definition

    image18

    The installation was not successful. Contact your Trimble Transportation Support representative. Be prepared to provide a copy the log file, which will reside on the machine’s desktop. You can view the file by clicking image19 Open Log.

    image20

    The installation was successful but one or more post-installation processes failed. Position your cursor over the icon to view a ToolTip describing the issue. Contact your Trimble Transportation Support representative. Be prepared to provide the information in the ToolTip as well as a copy of the log file.

    image21

    The installation was successful. Click image22 Launch to open the SystemsLink test-connection page. Then, click Finish to close the installer.

  4. Click Test Connection in the opened browser window containing the SystemsLink test-connection page. If the connection is successful, information appears that describes your system setup and licenses.

  5. In the installer, click Finish.

Applying SQL scripts to your database

Typically, when configuring your installation, the first step is to apply the appropriate SQL database modification script to your database. These scripts are located in the installation directory inside a folder named SQL_ followed by the version number of your installation. For instance, if installing SystemsLink 2021.2.1.30, the folder would be called SQL_2021_2_1_30.

If your version of SystemsLink is 2021.3.x or later:

  1. Apply RunFirstToValidateSqlScriptVersions-OPS.sql to your database.

  2. When the script completes, a message appears indicating your database version status.

    • If your database version is equal to or later than your SystemsLink version, you do not have to apply ETSDBMods.sql to your database. Continue to Step 4.

    • If your database version is no more than six versions older than your SystemsLink version, you must apply ETSDBMods.sql to your database. Continue to Step 3.

    • If your database version is more than six versions older than your SystemsLink version, we strongly recommend that you do not apply any other SQL scripts. Contact Trimble Support for assistance.

  3. Apply ETSDBMods.sql to your database.

  4. Apply RunLastToSetSqlScriptVersion-SL-OPS.sql to your database.

If your version of SystemsLink is 2021.2.x or earlier, apply ETSDBMods.sql to your database.

Continuing configuration and testing

After you have updated your database, continue configuring and testing your installation as indicated below.

  1. Restart IIS.
    Note: The TTS50.ini, TTSLocal.ini, and Web.config files are cached in memory to improve performance. After configuring your application or changing a setting, you must restart IIS to clear the cache and allow the new settings to take effect.

  2. To test the installation, go to the SystemsLink virtual directory in IIS and click Content View at the bottom of the window.

  3. Right-click on the APIWCFServices.svc file and select Browse in the shortcut menu.
    A browser page displays, verifying that you have created a service.

    image24

  4. In IIS, go to the .TMW virtual directory.
    This directory is named after the virtual directory specified for SystemsLink Core, with the addition of .TMW at the end. For example, the default name for this directory would be SystemsLink.TMW.

  5. Right-click on the SystemsLinkTestConnection.aspx file, select Browse in the shortcut menu, then click Test Connection in the opened browser window. If the connection is successful, information appears that describes your system setup and licenses.

Installing the SystemsLink external module

  1. Extract the installer to the target machine. Repeat this step for each machine.
    Note: Keep a copy of the installer in case you need to upgrade, repair, or delete SystemsLink.

  2. As an administrator, run the installer.

  3. Click Install Trimble Transportation Products.
    Note: The About Trimble Transportation Products and Resources links do not contain information relevant to installing SystemsLink.

  4. In the License Information window, enter:

    • Your ClientCenter credentials

    • The environment in which you are installing SystemsLink

  5. Click Login.

    image5

    If the login fails after multiple attempts or you do not have a valid license for SystemsLink, contact Trimble Transportation Support.

  6. After successfully logging in, click Next.

  7. In the Installation Type window, select New Installation.

  8. Set the Available Instances field value at 01 for a first time install.

  9. Give a name for the instance and press TAB.
    Note: You will need the instance name later in the installation process.

    image6

  10. Click Next.

  11. In the Products window, select SystemsLink.

  12. Change the installation path if needed, then click Next.

    image26

  13. In the Setup window, select SystemsLink APIs needed for this external instance. Available external services include:

    • SystemsLink RESTful API

    • SystemsLink Vendor API

    • SystemsLink External API

      Warning: You cannot install non-Fuel and Fuel services in the same instance. If both non-Fuel and Fuel services are selected in the Setup window, the Next button will be disabled until your selections are corrected.

  14. Click Next.

  15. Confirm requirements in the Requirements window.

    image9

    Click Next if at least one of the following is true:

    • All requirements are met.

    • One or both browser requirements are not met, but all other requirements are met.

    Click Cancel if one or both of the following are true:

    • The IIS and/or ASP.NET requirement is not met.

    • The SQL server requirement is not met and you are installing a version of SystemsLink that is earlier than 2017.3.

      As of version 2017.3, the minimum SQL Server requirement is 2008 R2. If your machine does not have this version installed, and you are installing version 2017.3 or higher, you will be prompted to install the SQL Server 2008 R2 CLR Types and Shared Management Objects (SMO). They are included with the installer.

  16. In the IIS Setup window, make entries in the following fields for each service that you are installing.

    Field Definition

    Auto Warmup Sites

    For SystemsLink installation, be sure that this checkbox is cleared.

    Web Site

    The root-level web site in IIS Manager defaults to Default Web Site. Select the name of your web site.

    Virtual Directory Name

    The virtual directory receives queries and directs each query to the appropriate data source.

    The default name for the services virtual directory appears in the field. If you want, enter another name for the virtual directory.

    Is SSL?

    First available in TMW Web Products 2018.2

    Select this option if the service is using Secure Socket Layer (SSL).

    Ext. Host

    First available in TMW Web Products 2018.2

    Select this option if the URL for the service will be called externally.

    Application Pool Name

    In IIS 7.0 and later, you group your web applications and services by assigning each to an application pool. Applications that call similar processes could be in the same application pool.

    The default name for the application pool appears in the field. If you want, enter another name for the application pool.

    Site URL

    Enter the addresses of these services installed on the internal web server:

    • SystemsLink Core API

    • WCF Services

    • Web Framework WCF Services

    The Required column indicates whether the web service is already installed in the current instance. A image29 checkmark means the required service is detected, while a image18 red cross means you must provide the URL for the service.

    image30

  17. Click Next.

  18. In the SystemsLink Setup window, enter the WebProducts Framework Service username and password.

    image31

  19. Click Next.

  20. On the Installation Review window, click Begin Installation.

  21. Check the Success column to see the result of the installation. The icon indicates whether the installation is successful.

    Icon Definition

    image18

    The installation was not successful. Contact your Trimble Transportation Support representative. Be prepared to provide a copy the log file, which will reside on the machine’s desktop. You can view the file by clicking image19 Open Log.

    image20

    The installation was successful but one or more post-installation processes failed. Position your cursor over the icon to view a ToolTip describing the issue. Contact your Trimble Transportation Support representative. Be prepared to provide the information in the ToolTip as well as a copy of the log file.

    image21

    The installation was successful. Click Finish to close the installer.

SystemsLink uses credentials to verify that anyone connecting to a TMWSuite database has the correct permissions. This means that you need a username and password, and you must be able to retrieve tokens. Both are required before testing the actual connection.

You create and manage external users using the ExternalUserCreation utility, which is packaged with the installation download available from ClientCenter.

To create administrator and test user accounts, use the ExternalUserCreation program contained in the SystemsLink_ExternalUserMgmt.zip file.

For SystemsLink versions lower than 2019.2, the zip file containing the ExternalUserCreation program is named with the version of SystemsLink being installed. For example, in the 2019.1.0.22 release, this zip file is named SystemsLink_ExternalUserMgmt_2019.1.0.22.zip.

Follow these steps on the internal installation server:

  1. Go to the location of the SystemsLink_ExternalUserMgmt.zip file and extract the archive contents to a local or network directory.

  2. In the newly created directory, open ExternalUserCreation.exe.config in a text editor.

  3. Find the appSettings section and change the username and password to any valid TMWSuite user ID and password.

  4. Save and close the file.

  5. In the same directory, open Ttslocal.ini and make the following edits:

    • Change the servername value to the name of the database server where your TMWSuite database resides.

    • Change the database value to the name of your TMWSuite database.

  6. Save and close Ttslocal.ini.

  7. Open an administrator command prompt in the directory you created and enter:

    .\ExternalUserCreation.exe

    If the help prints to the screen, the application is working.

    image33

  8. Create an administrator account by using the INITIALIZE option.
    For example, to create an account with the password adminpassword and the external link of adminacct enter:

    .\ExternalUserCreation.exe INITIALIZE adminpassword adminacct

    If successful, the message Successfully initialized (<your external link>) for use prints to the screen.

  9. Create a user account by using the CREATE option followed by the administrator password, the user account name, the user account password, and the external xref:

    .\ExternalUserCreation.exe CREATE adminpassword useracct userpassword adminacct

    If successful, the message Successfully created user account <user account name> prints to the screen.

  10. Allow the SystemsLink external module to be accessed from the Internet.
    Note: If you need to set up firewalls or ports, follow your company’s security and other procedures to allow the SystemsLink external module to be accessed from outside the company network.

  11. Add additional users.
    After you have initialized the administrator account with the ExternalUserCreation program, you can use the same program to create and manage all external user accounts. Account information is stored in the WebSystemsLinkCredentials table in your TMWSuite database.

  12. To test in IIS, locate the SystemsLink virtual directory you specified previously and click Content View at the bottom of the window.

  13. Right-click on ExternalAPIWCFServices.svc, then select Browse in the shortcut menu. This opens the service in a browser window.

  14. Confirm the service is active in the opened browser.

    image35

If you want, you can use the SoapUI API testing tool to check the SystemsLink external connection.

  1. Download and install SoapUI.

  2. Create a new project that uses the SystemsLink external WSDL. An example of the WSDL endpoint could be:

    http://[SystemsLink server name]/[namespace for External SystemsLink]/ExternalAPIWCFServices.svc?WSDL

    Note: The endpoint may have a different name than in the example.

  3. Test the GetToken method.

    1. Find the GetToken method in the Navigator sidebar and select the plus sign next to the method.

    2. Click Request 1. A window opens. It contains the standard format of a GetToken request.

    3. Insert the username for the SystemsLink external administrator account inside the userName tag, and the password for that account inside the password tag.

    4. Click image36 Run. The results display in the rightmost section of the window.

    5. Verify that the method achieved the appropriate result. A return code of 0 means that the method was successful. Any other return code means that an error occurred.

      GetToken should return a token inside the TokenValue tag. Use this token for further test requests.

    image37

  4. Repeat Step 3 for the following methods:

    • TestConnection
      Testing this method requires the token received from the GetToken. Insert it into the tokenValue tag.

      image38

    • GetOrder
      Testing this method requires the token received from the GetToken test, as well as a valid order’s header number. Put the token inside the tokenValue tag and the order header number inside the orderHeaderNumber tag.

    image39

Once you have called all three methods successfully, you are ready to use the API.

You can install multiple instances of SystemsLink on a single server. This may be useful in the following situations:

Modifying an existing SystemsLink installation

  1. Follow steps 1-6 in either Installing the SystemsLink internal module or Installing the SystemsLink external module.

  2. In the Installation Type window, select Existing Installation.

  3. If your instance can be modified with this installer, an Add/Remove button appears in the Add/Remove Features column. To add and/or remove features to this instance, click the button.

  4. In the Products window, select any products to add and clear any products you want to remove. Already-installed applications you wish to keep should stay selected. Once finished, click Next.

  5. In the Setup window, select the services to install, then click Next.

  6. Confirm requirements in the Check Requirements window.
    Click Next if at least one of the following is true:

    • All requirements are met.

    • One or both browser requirements are not met, but all other requirements are met.

    Click Cancel if one or both of the following are true:

    • The IIS and/or ASP.NET requirement is not met.

    • The SQL server requirement is not met and you are installing a version of SystemsLink that is earlier than 2017.3.

    As of version 2017.3, the minimum SQL Server requirement is 2008 R2. If your machine does not have this version installed, and you are installing version 2017.3 or higher, you will be prompted to install the SQL Server 2008 R2 CLR Types and Shared Management Objects (SMO). They are included with the installer.

  7. In the Modifications Review window, confirm the features that you want to add or remove, then click Next.

  8. In the IIS Settings window, enter the required information for any added features, then click Next.
    Not all fields will be editable. If only removing features, there may be no editable fields.

  9. In the SQL Setup window, enter your database information and click Next.
    Not all fields will be editable. If only removing features, there may be no editable fields.

  10. In the TTS Setup window, ensure the locations and names of the Tts50.ini and Ttslocal.ini files are correct as well as the user account information. Any errors are indicated by a red highlight surrounding the field.

  11. Do one of the following:

    • If there are no errors in the TTS Setup window, click Next.

    • If there are errors, you must correct the information in those fields before continuing. Once the errors are corrected, press TAB, then click Next.

  12. In the SystemsLink setup window, make any needed changes, then click Next.

  13. Check that the Install Type in the Installation Review window is Modify, then click Begin Installation to begin the modification process.

  14. Do one of the following:

    • If the installation was successful, click Finish to exit.

    • If an error or failure occurred, check the log file. If the error or failure cannot be resolved, provide a description of the problem and a copy of the log file to Support.

  1. Back up your TMWSuite databases.

  2. Follow steps 1-6 in Installing the SystemsLink internal module or Installing the SystemsLink external module.

  3. In the Installation Type window, select Existing Installation.

  4. Select the Upgrade checkbox for the instance, then click Next.

  5. Check that the Install Type in the Installation Review window is Upgrade.

  6. Click Begin Installation.

  7. If the installation was successful, click Finish.
    If an error or failure occurred, check the log file. If the error or failure cannot be resolved, provide a description of the problem and a copy of the log file to Support.

  8. Apply the setting values in your old web.config files to the new web.config files.

  1. Follow steps 1-6 in Installing the SystemsLink internal module or Installing the SystemsLink external module.

  2. In the Installation Type window, select Existing Installation.

  3. Select the Uninstall checkbox for the instance, and then click Next.

  4. In the Installation Review window, confirm that the Install Type column value is Uninstall.

  5. Click Begin Installation.

  6. In the Installation Complete window, check the Success column to see the result of the uninstallation. The icon indicates whether the uninstallation is successful.

    Icon Definition

    image18

    The uninstallation was not successful. Contact your Trimble Transportation Support representative. Be prepared to provide a copy the log file, which will reside on the machine’s desktop. You can view the file by clicking image19 Open Log.

    image20

    The uninstallation was successful but one or more post-uninstallation processes failed. Position your cursor over the icon to view a ToolTip describing the issue. Contact your Trimble Transportation Support representative. Be prepared to provide the information in the ToolTip as well as a copy of the log file.

    image21

    The uninstallation was successful. Click Finish to close the installer.