TruckMate Service Host

This grid is where you define the main export groups, currently only Great Plains Accounting is supported.

Description

Enter a description of the group you are defining.

Active

This a flag whether the group is currently active or not. If not active the export can’t run.

License Key

For each type of export TruckMate requires a license. The license key required for this export is displayed in this field.

Date Format

You can setup the date format for exported data items of type Date.

Sequence

This is the sequence of the group among all other defined groups.

Log Details

This flag indicates whether to log the details of the export process or not for the selected group.

This section is where you define the sub-types of the selected main group. Each subtype can be run separately, at a different scheduled time interval.

Description

Enter a description of the sub-type you want to define.

Active

This a flag as whether the selected sub-type is active or not. Only active sub-types can be scheduled to run.

Scheduled to Run

Enter an interval for executing this sub-type.

Column Headers

This is a True / False flag to indicate whether the column headers will be exported along with the data or not.

Output File Name

Enter the name of the file you want the data of this sub-type to be exported to.

Output File Directory

Select the folder where you want the export file to be stored.

Secondary Output File Directory

Provide an additional folder where you want the export file to be stored.

FTP / FTP Host

The first field indicates whether the export file is going to be directed to an FTP site or not. If true, the second field is the address of the FTP host that will receive the export file. If the FTP option is selected, further defining is required in Advance Setting (the following section) > FTP tab.

Show

This radio button group allows you to filter the sub-types appearing on the grid to show only 'Active' ones, 'Inactive' ones or all. Selecting a different radio button (other than the one selected) will refresh the grid and apply the selected filter option on the displayed sub-types.

Activate

This group includes two buttons 'All' and 'None', which means that you can select the 'All' button to activate all available sub-types, or you can select the 'None' button to deactivate all sub-types.

The advanced settings section allows you to configure the specifics of the data to be exported, for that, its highly advised that you consult Trimble Transportation Support before you change.

Column Headings Exist

Select whether or not there are column headings in the import file.

Column Headings Validation

If 'Column Headings Exist' is checked, select whether or not you would like the Level 1 Exception Check to include a validation against the column headings in the 'Column Headings Row Number' versus the 'Import Column Names' you have defined in the mapper detail below, rejecting any file that is not an exact match (including an exact match on upper/lower case).

Column Heading Row Number

If 'Column Headings Exist' is checked, enter the row number containing the row that contains the column headings. The default is 0.

Data Start Row Number

Enter the row number to start reading the order data. This allows the processing to skip past column heading or other extraneous information at start of the file. The default is the 'Column Headings Row Number' + 1.

Master Line Tag/Detail Line Tag

These two fields are both relevant only when a NON-Flat file is selected. If a NON flat file is selected (the 'Flat' checkbox is un-checked), then the user must enter a tag for the master line and another tag for the detail line.

'Break' Column Number

Enter the column number that will tell the import processor that, when this value differs from the previous row’s value, it needs to break to a new Freight Bill. This would typically be the column that contains the order number. This feature thus allows for instances where the file is a 'multiple rows per Freight Bill' format. A value must be entered for this field.

Number of Columns

For display purposes only. Whenever you do an edit/save to the mapping definition below, the number of columns is recalculated and displayed here. The Level 1 Exception Check will ensure that the number of columns for all rows in the CSV file does match to the number of columns here, rejecting any file that is not a match.

EDI SID# User Field

Displays from EDI Communications Manager Setup, if applicable. If you are not using EDI, click the first button 'Change EDI SID# User Field' to invoke the edit-pick, then choose which Customer Service User field shall hold the SID Shipment ID#. Though not recommended, the second button 'Empty EDI SID# User Field' will clear the selection (and this also clears the field in EDI).The SID# is helpful when navigating through failed orders in the Order Preprocessor > Pending tab as well as for any of your needed order filtering in TruckMate. Once this value is set, it will automatically apply to all your FB Imports (as well as all your EDI 204 Inbound maps) and it should not be changed.

Category

The available values for this field are 'Master' and 'Detail'. If a NON-Flat file format is selected (the 'Flat' checkbox is NOT checked), then this field must indicate whether the column being defined is on the master line or on the detail line. If the file is 'Flat' (the 'Flat' checkbox is selected), the value of this field becomes irrelevant.

Column Number

Enter the position of this column in the CSV file. Set this to '0', if you are using the hard-code default for the Order Preprocessor staging table column. Duplicates are allowed when you need to map an import field to more than one column in the Order Preprocessor staging table e.g. Column 11 'Date' typically would map to 'Deliver By', 'Deliver By End', 'Pick Up By' and 'Pick Up By End' dates in TruckMate.

Import Column Name

If the 'Column Headings Validation' is checked, then the column name entered here must match exactly to how it exists in the CSV file. Otherwise, enter a short description of what this column contains. If you enclose the value in quotes, this does not represent a column heading but rather a hard-code default to force the Order Preprocessor staging table column to this value (should you not be setting it from the import data itself).

Import Data Type:

Enter the data type for this CSV column from the pull-down list. The import will validate to ensure the value in the file is of this data type. Leave it empty, if you do not want the field to be validated e.g. you are not mapping this field so there is no need to validate it. Valid entries are:

Behavior

Enter the mapping behavior from the pull-down list. Valid entries are:

Required

Select 'True' if this field cannot be null/empty/blank. Level 2 Exception Check will ensure this CSV column contains a value, rejecting this order if a required field is missing. Select 'False' if no check is required. The value here is not relevant if you did not enter an 'Import Data Type' for this column.

TM Table

Select which Order Preprocessor staging table you wish to map this field to. Choices are PTLORDER for header fields, PTLDTL for detail line fields and PTRACE for trace numbers. Leave this field empty, if you are not mapping this field. If 'Behavior' = 'CUSTOM', the value here is for informational purposes only. There would be corresponding import specific code added by TruckMate to handle this field.

TM Column Name

If a 'TM Table' has been entered, select which column in the Order Preprocessor staging table to map this field to. If you need to assign the PTLORDER.BILL_NUMBER from data in the import file, you must also address the mapping of SITE_ID since both these fields are required for the post of a manual bill number in TruckMate. Also, ensure Required = 'True'. These orders will automatically be posted, regardless of your value in 'Post Bill Number before Update'.

Note: The import does not check for duplicate BILL_NUMBER. Order Preprocessor and the update of the Freight Bill into Customer Service both allow for duplicate bill numbers. However, if the Customer Service Application Configurator 'Duplicate FB Number' = 'False', you will be prevented from doing an edit-save on duplicates in Customer Service.

TM Type

For display purposes only. If a 'TM Column Name' has been entered, the data type is extracted from the schema and displayed.

The Web Service section is where the connection settings for interacting with the Omnitracs Portal web site are entered.

URL

Enter the URL of the Omnitracs Portal web site. This field will normally automatically populate, but you modify the information if requried.

Cust Name

Enter your Company’s Customer Name associated with the Omnitracs Portal web site.

UserName / Password

Enter the User details associated with your Company’s account on the Omnitracs Portal web site.

ESS Subscriber No.

If applicable, enter your Company’s ESS Subscriber number in the field provided.

This section controls how (and where) log files for the Omnitracs Portal are generated and stored.

Log File Path

Enter a hard drive location to store the log files. This field will default to the directory from which the TruckMate Windows Service Host program is run.

Rotate

This value determines the amount of days that the log files will be maintained on the hard drive. Using the default ('30' days) means that the hard drive will contain- at any point in time- the previous 30 days worth of log files. All logs older than 30 days (from the current date) will be automatically deleted.

If your system connects to the internet through a Proxy Server, you must check the 'Connect Through Proxy Server' option and provide the Proxy details in the available fields in order for the TruckMate Windows Service Host program to interface with the Omnitracs Portal website.

Server

Enter the Proxy Server’s address and port number (eg 111.111.111.111:8080).

UserName / Password

Enter the User details associated with your system’s account on the Proxy Server in these two fields.

AutoStart

When this option is enabled, the Omnitracs Portal service will automatically be started when the TruckMate Service Host program is opened.

Mark Failed Requests as Completed

When this option is enabled, any requests sent by the TruckMate Windows Service Host program that are not received by the Omnitracs Portal web site (those requests marked as 'Failed') will be set to 'Complete' and ignored when the program attempts to reconnect to the Portal web site.

Echo Interpretation Errors to Drivers

Sends a copy of the log to the Driver assigned.

Enable Auto-Dispatch

Allows a Driver to accept a load offer while on an existing trip. When enabled, multiple load acceptances will be accepted by the system. Additionally, new fields have been added to the Dispatch trip Grids entitled: 'Load Offer Status' and Load Offer Sequence'. Load offer status options will be offered, read, accepted, declined, active, or completed. The load offer sequence will be system generated when the load offer is generated. For more information, refer to the Dispatch program.

Notify Driver of Status

Place a checkmark in the box provided if you wish to notify the Driver of any status changes.

The Status Codes section allows you to assign TruckMate Status Codes to a variety of communication events across several Tabs organized for different business models. Truck Load Carriers, for example, will want to setup the various options on the TL Tab, while Less Than Load Carriers will use the LTL Tab.

The Tabs themselves consist of various drop-down menu fields tied to specific communication messages. The User may setup TruckMate Status Codes for all events, or for only those events that they expect to use when communicating with the Omnitracs Portal web site during normal operations.

TruckMate Status Codes are defined and maintained in the Codes Maintenance program > Status Codes Tab.

Choose which Users you would like to give access to the Unaddressed Messages that your system receives. Simply select the User you would like to add to the 'Distribution List' section and click the 'Right' arrow to add them.

Auto-Read Messages

Place a checkmark in the box provided if you wish to mark interpreted incoming messages as 'Read'.

Addressed Messages Setup

Selecting the 'Setup' button will allow users to create group distribution lists. After selecting the 'Setup' button from the previous screen, you can view the Distribution Group Setup window. Create a new group name, and add users to the group distribution list.

Use the '+' sign to add a new group name, and then highlight a member’s name and use the right facing red arrow () to move a user into the distribution list.

In the Communications Macro Setup program, you can configure a Return macro that the Driver can use to query the TruckMate database for information about the nearest fueling facility. The pertinent return macro field type is 'Free Form Text', and the return action is 'Request Fuel Search'. When a Driver sends a macro that contains this field, the records from the Contacts and Phone program are searched based on the criteria specified here. Then, a Forward macro is sent to the Driver that contains the information that was requested, based on the criteria below.

Phone Category

In the Contacts and Phone program, you can assign Categories to individual records. For example, you could create records for all your card lock fuel locations, and assign to them the category 'CARDLOCK'. Then, in this field, select the category 'CARDLOCK' to filter the records in the Contacts and Phone program that will be automatically sent to the Driver in response to his return macro.

Maximum Matches

Enter the maximum number of records that you wish to send to the Driver in response to his return macro.

Search Area

In the Contacts and Phone program, you can assign a Latitude and Longitude positions to records. These must be in the format of hours, minutes, seconds, and position, such as '0510215N'. (Note that you can use third-party mileage software, such as PC*Miler, to determine longitude and latitude values.) When a Driver sends a return macro with a request for a fuel search, his current position is compared against the latitude and longitude positions assigned to the records in the Contacts and Phone program. The closest geographical matches will be included in the reply to the Driver.

in the Communications Macro Setup program, you can configure a Return macro that the Driver can use to query the TruckMate database for information about the nearest repair facility. The pertinent return macro field type is 'Free Form Text', and the return action is 'Request Breakdown Search'. When a Driver sends a macro that contains this field, the records from the Contacts and Phone program are searched based on the criteria specified here. Then, a Forward macro is sent to the Driver that contains the information that was requested, based on the criteria below.

Phone Category

In the Contacts and Phone program, you can assign Categories to individual records. For example, you could create records for all your repair locations, and assign to them the category 'REPAIR'. Then, in this field, select the category 'REPAIR' to filter the records in the Contacts and Phone program that will be automatically sent to the Driver in response to his return macro.

Maximum Matches

Enter the maximum number of records that you wish to send to the Driver in response to his return macro.

Search Area

In the Contacts and Phone program, you can assign a Latitude and Longitude positions to records. These must be in the format of hours, minutes, seconds, and position, such as '0510215N'. (Note that you can use third-party mileage software, such as PC*Miler, to determine longitude and latitude values.) When a Driver sends a return macro with a request for a breakdown search, his current position is compared against the latitude and longitude positions assigned to the records in the Contacts and Phone program. The closest geographical matches will be included in the reply to the Driver.

Enabled

If this box is checked, the Communication Manger program will analyze position updates received from remote units and attempt to determine if the trip to which the Power Unit is assigned (in the Dispatch program) is late. The system will look at the Active Leg to which the Power Unit is currently assigned. Using the Latitude and Longitude value that is configured for the 'Leg To' zone (in the Codes Maintenance program, or using the Latitude and Longitude Update program), the system will calculate the distance between the unit’s current position and the Leg To zone. Then, using the value entered in the Avg. Speed field, the system will calculate the expected time that will be required to reach the Leg To zone. If that time exceeds the leg’s Deliver By time, the trip’s status will be changed to the Default for Category for the 'Late' Code Behavior (as configured in the Codes Maintenance program).

Avg Speed

Enter the average speed that the Power Unit travels. This value is used in the late calculation described above.

Late Threshold

Enter a numerical 'buffer' value in this field. For example, if the value in this field was 30, and the trip was calculated to be 15 minutes late, the trip’s status would not change.

Notify Dispatch when Driver is Running Late

If this box is checked a new message will be created for the users on the Distribution List informing them that the Driver is running late. If this box is not checked, the trip status will be changed by no message will be generated.

You can use the 'Wait Time' field to allow a grace period (in minutes).

Use Mileage Server for Distance Estimate

If this box is not checked, latitude and longitude values are used to calculate distances. If this box is checked, the Mileage Server program will be used to interface with your third party mileage software, and thus determine distances based on available routes rather than simply by latitude and longitude.

Return Receipt

If this box is checked, when a message sent from the Dispatch program or Driver Call In program is read by the Driver, an 'AR' status will be sent from the remote unit. This is translated by the TruckMate Windows Service Host program into an 'A' status, which is used to indicate that the message has been read by the Driver. In the Driver Call In program, you can view the status of any Forward (ie, dispatch office to remote unit) message.

For sites using the Dispatch program’s Drill Down function, this box must be checked in order to use the 'LTL Read by Driver' status change (as configured on the General Tab).

Forward Message Priority

Sets the default QTracs/Cancom priority value for outgoing messages. 'Default' will use the value specified in the QTracs software, which is by default 'Normal'. 'Normal' status attempts to send messages up to 9 times over 35 minutes. 'Important' status has the same send frequency, but sends the message immediately, rather than waiting for the next scheduled communication. 'Sleepy' attempts to send the message 7 times over 18.25 hours. 'Important Sleepy' has the same send frequency as 'Sleepy', but initiates an immediate communications dialog. You can also configure the message priority for specific macros in the Communication Macro Setup program. Also, in the Dispatch program or Driver Call In program, you can select the message priority on an individual basis for each forward message.

Distribute Reply to Sender Only

You can specify that Return messages that are in reply to Forward messages only get distributed to the user who sent the original Forward message. The Login Name (as configured in the Security Setup program) of the user who created the Forward message is used, and the Distribution List configured on the Distribution Group Tab is ignored.

Once you have set these, reboot the host machine and then restart QTracs and the TruckMate Windows Service Host program.

Copy Power Unit History

If this flag is selected, when a Power Unit for a specific Device ID has been renamed to a different Power Unit ID, the Qtracs Portal will copy the original Power Unit position history over to the new Power Unit ID.

Mark Return Message as Seen on Web Portal

When a return message is received on the Qtracs Portal a copy of that return message is also sent through the Qtracs Portal API. Normally, the return message into TruckMate, but the return message on the Qtracs Portal web site is still marked as 'Unread'. When this setting is turned on, after the return message is imported, TruckMate sends a command to mark the message as 'Read' on the Qtracs Portal web site.

Enabled

In order to use the Automated Arrival and Departure features, you must check this checkbox.

Log Events

If you wish to Log Events from the Omnitracs Portal web site, check this checkbox.

Event Status Setup

Clicking this button will open an Event Status Setup window where you may use pull down menus to configure the Status Codes for the 'Arrived' and 'Depart' events for your Shipper and Consignee customers. Check the 'Use non-standard Status' option if you are using non-standard Status Codes in your TruckMate system.

Arrival Time Tolerance

Enter a time value (in minutes) for the Automated Arrival system.

End-of-Trip Threshold

Enter a time value (in minutes) for the End-of-Trip Threshold.

Low Confidence Event Offset

Enter a time value (between 5 and 120 minutes) for the Low Confidence Event Offset.

Check Pending Arrival Events

Enter a time value (between 5 and 120 minutes) that will elapse before checking for pending arrival events.

Send to TruckMate Resources

When this flag is selected and if a device is added/updated/deleted on the Qtracs Portal, a message is sent by Omnitracs to notify TruckMate of this action. For example, if the notification is that a new device has been created on Qtracs Portal, then TruckMate will take that device information and add it into TruckMate automatically.

Send to Web Portal Resources

When this flag is selected and a device is added/updated/deleted in TruckMate, the information regarding the resource is sent to the Qtracs Portal to be updated there. For example, if the device is assigned a Power Unit in TruckMate, TruckMate will send that information to the Qtracs Portal to be updated.

VIN #

Omnitracs has added a new VIN number field to their equipment list. We can now update the tractor and trailer’s VIN number with that information.

Note: If you have many QTracs devices, you can import a list of QTracs devices into TruckMate using the 'Import QTracs Portal Devices' option available from the Mobile Device Maintenance program > Menu Bar > File Menu.

SCAC

Enter the Trailer’s SCAC code in this field. The default value should be 'SCAC'.

Trailer Type

Enter the Trailer Type in this field. The default value should be 'DFT'.

Management Group

Enter the Management Group in this field. The default value should be 'DFT'.

Copy Trailer History

When moving a Trailer Tracks device from a previous Trailer to a new Trailer, this setting will tell TruckMate to update the Trailer Tracks device history onto the new Trailer.

ReeferTracs Message Notify

When this flag is checked and a Temperature Tolerance Event or Low Fuel Event gets imported by the Trailer Tracks, a return message is generated to let the user know that these events have come in and need immediate attention.

Send to TruckMate Resources

When this flag is selected and if a Trailer or Device is added/updated/deleted on the Omnitracs T2 service, a message is sent by Omnitracs to notify TruckMate of this action. For example, if the notification is that a new device has been created in T2l, then TruckMate will take that device information and add it into TruckMate automatically.

Send to Web Portal Resources

When this flag is selected and a device is added/updated/deleted in TruckMate, the information regarding the resource is sent to the T2 software to be updated there. For example, if the Trailer or Device is assigned a Power Unit in TruckMate, TruckMate will send that information to the Omnitracs T2 softwarel to be updated.

The various options in the Schedule group allow the user to set when the service will check the system for new messages generated from DAWG alerts and send them out. You can configure the check to run based on a per minute basis, an hourly basis, a 12 hour basis, a 24 hour basis, or at a specific time.

These two radio options control the 'Last Run' variable, which tells the system when THE DAWG was last executed. This variable is used to determine when THE DAWG should next be run.

Actual

The 'Actual' setting will set the 'Last Run' variable to the exact date/time that THE DAWG processes completed. Thus, if you have selected a 'When' option such as 'Every 30 minutes', THE DAWG will execute 30 minutes after the 'Last Run' variable, which may be 12:03pm. As each 'Last Run' variable will change depending on the amount of work for THE DAWG to process, using the 'Actual' option may lead to erratic automatic launches.

Fixed

The 'Fixed' setting will alleviate any erratic launching of THE DAWG caused by the 'Actual' setting. When using this option, the 'Last Run' variable will always correspond to the 'When' setting you have chosen. If you have set the 'When' variable to 'Once a Day at a specified time', THE DAWG will always be launched at that exact time, no matter how long it took to run the previous day.

Log Path

Provide a log path for the messages generated by the Scheduler DAWG service. You can use the ellipsis button to browse to a hard drive location on your machine.

Rotate

Enter the amount of days that should elapse before the existing log file is automatically deleted by the TruckMate Windows Service Host program and recreated.

AutoStart Module / AutoStart Activity Log Window

These two flags control if the service will automatically start when Windows is started on the machine and will auto-open the Activity Log within the TruckMate Windows Service Host program when it is opened.

The various options in the Schedule group allow the user to set when the service will check the system for new Detention email messages and send them out. You can configure the check to run based on a per minute basis, an hourly basis, a 12 hour basis, a 24 hour basis, or at a specific time.

E-Mail Default Profile

Select which profile should function as the default for Detention warnings.

Note: E-mail settings are all controlled via the TruckMate E-Mail System.

Setup

Clicking this opens the Codes Maintenance program > Site Setup tab.

Template / Choose Template

This field displays the email Template that will be used for the Detention emails. Use the 'Choose template…​' button so select an email Template to use.

Note: If setting up a multi-company Detention email integration, be sure to create similar email templates for each of your companies and assign them to their respective company record.

Log Path

Provide a log path for the messages generated by the Scheduler Detention service. You can use the ellipsis button to browse to a hard drive location on your machine.

Rotate

Enter the amount of days that should elapse before the existing log file is automatically deleted by the TruckMate Windows Service Host program and recreated.

AutoStart Module / AutoStart Activity Log Window

These two flags control if the service will automatically start when Windows is started on the machine and will auto-open the Activity Log within the TruckMate Windows Service Host program when it is opened.

The various options in the Schedule group allow the user to set when the service will check the system for new email messages and send them out. You can configure the check to run based on a per minute basis, an hourly basis, a 12 hour basis, a 24 hour basis, or at a specific time.

E-Mail Default Profile

Select which profile should function as the default for Detention warnings.

Note: E-mail settings are all controlled via the TruckMate E-Mail System.

Setup

Clicking this opens the Codes Maintenance program > E-mail Setup tab.

Printer to send faxes to

Use the drop-down menu to configure the default printer to be used for faxes.

Log Path

Provide a log path for the messages generated by the Scheduler Email service. You can use the ellipsis button to browse to a hard drive location on your machine.

Rotate

Enter the amount of days that should elapse before the existing log file is automatically deleted by the TruckMate Windows Service Host program and recreated.

AutoStart Module / AutoStart Activity Log Window

These two flags control if the service will automatically start when Windows is started on the machine and will auto-open the Activity Log within the TruckMate Windows Service Host program when it is opened.

Delivery Confirmation Profiles

This button opens the E-Mail Confirmation Profile window, allowing users to create Delivery Confirmation Profiles.

Note: If setting up a multi-company Scheduler e-mail integration, be sure to create similar email templates for each of your companies and assign them to their respective company record.

DLL File

Use the ellipsis button to select one of the available DLLs to be run.

*Warning:* The .dll file being used must be a .dll of 'Function' type, and must return a Boolean value (an INTEGER of '0' or '1'). If you wish to use the .dll functionality of the TruckMate Scheduler program without error, you cannot have the .dll return 'CHAR' or 'STRING' values.

Routine

Enter the routine you wish to run when the DLL is accessed.

Function Parameters

Enter the parameters you wish to run against the .DLL using the fields available.

The various options in the Schedule group allow the user to set when the service will access the configured .DLL file. You can configure the check to run based on a per minute basis, an hourly basis, a 12 hour basis, a 24 hour basis, or at a specific time.

Log Path

Provide a log path for the messages generated by the Scheduler Email service. You can use the ellipsis button to browse to a hard drive location on your machine.

Rotate

Enter the amount of days that should elapse before the existing log file is automatically deleted by the TruckMate Windows Service Host program and recreated.

AutoStart Module / AutoStart Activity Log Window

These two flags control if the service will automatically start when Windows is started on the machine and will auto-open the Activity Log within the TruckMate Windows Service Host program when it is opened.