TruckMate 2023.4 New Features: Operations

A new PURGE_MADD_DEBUG procedure makes it easier to delete unnecessary data from your MADD_DEBUG table.

TruckMate uses the MADD_DEBUG table to track system issues in specific scenarios. Previously, you could only clear data from this table manually or by using Data Purge.

The PURGE_MADD_DEBUG procedure has two parameters:

When you run the procedure, it removes all records outside the parameter range you specified.

If you want, you can set this up as a repeating DAWG. You can then run the procedure as needed automatically.

In SQL Execute, you can now view information about these events:

To access them, open the System Info window, select *ALL* as the schema and select an event in the Type field.

Once run, you (and Trimble Transportation Support, if needed) can diagnose an issue by viewing information in these fields:

These illustrations display samples of returned data.

If your company uses the OrbComm or TracKing mobile provider, you can now increase the number of job processors to the associated service in Mobile Communications Manager. This helps increase data download and processing times, especially for companies that have large trailer fleets.

By default, the number of processors available is 1.

When reviewing the service logs, you can see the specific thread that is responsible for a given job.

Data continues to flow normally into the LOCHIST and POSHIST tables.

Previously, when an outgoing message was created as part of the Mobile Communications workflow, some fields were occasionally left blank. For example, a message that should have included the power unit, device, and driver omitted the driver.

Now, the Mobile Communications service attempts to fill all fields based on information it finds in associated trips.

In the example above, TruckMate now looks to see if the power unit is currently assigned to a trip.

This workflow now exists inside the INSERT_MESSAGE_FORWARD stored procedure. This provides significant performance improvement for companies that have a large number of load offers and P&D workflows.

In both Dispatch and Multi Mode Dispatch, you can create filters on any grid using the Quick Filter Builder.

Quick Filters offer these benefits over traditional SQL filters:

For details on this new feature, see Quick Filters.

Previously, the Trip View feature provided a tree view of a trip. You accessed this feature by right-clicking on a trip in the Trips or Trip Legs grid.

With the addition of the Trip Tree View, this feature is no longer necessary. It has been removed as of this release.

These read-only columns have been added to the freight bill grid in Multi Mode Dispatch:

The columns can be sorted, moved, and formatted.

The CITY_LINK stored procedure assists in generating lists of freight bills within the pickup grid in Multi Mode Dispatch.

This procedure has been streamlined to help improve performance, especially when a large number of freight bills is in the grid.

Previously, when a Depart Dock status was applied against an empty leg on a multi-leg trip, the leg was completed automatically by default.

In Codes Maintenance, a new additional rule, Complete Empty Leg, lets you decide how TruckMate handles this type of leg.

If you upgrade to this version of TruckMate, the Complete Empty Leg checkbox is selected for existing statuses and deselected for any new statuses created after the upgrade.

By default, the checkbox is deselected (except as noted above). With this, applying the Depart Dock status activates the leg but does not complete it.

If the checkbox is selected, applying the Depart Dock status completes the leg and advances the trip’s active leg.

In Multi Mode Dispatch, you can now view available information about dangerous goods for a freight bill after it has been assigned to a trip.

In the grid, right-click on the trip. If details are available, you can select Dangerous Goods Details from the shortcut menu. This opens the Freight Bill Details window, in which you can see the dangerous goods records added to the freight bill.

Previously, if in Multi Mode Dispatch you selected a mixture of freight bills from the pickup and delivery grids, the order in which you selected the bills was not reflected on the P&D trip. For example, if you selected freight bills in this order:

dragging the bills manually onto the P&D trip caused the stops to be sorted as follows:

Now, TruckMate respects the order in which you select bills when they are applied to the trip.

In Dispatch, the GET_DISP_TRIP_QUERY stored procedure populates the Trips grid.

With this version of TruckMate, the procedure has been modified to provide significantly better performance within the grid.

Previously, the Adjust/Pickup Delivery window in Dispatch and Multi Mode Dispatch let you update pickup and delivery times and any appointment-based fields. However, you could not update spot fields.

Now, you can define and update spot information in this window for the Shipper, Pick Up At, Consignee, and Care Of entities.

This illustration displays the window for a single selected freight bill. All audit tracking functionality remains unchanged.

This illustration displays the window for multiple selected freight bills, none of which share a date.

If two or more freight bills share all dates, that date appears in the appropriate field and/or the corresponding checkbox is selected.

If two or more freight bills only share some dates, the fields are blank but the checkboxes are displayed in a neutral state.

These rules apply in the Adjust/Pickup Delivery window as well as in Customer Service:

With this release, changes were made to SQL filters that affect the Deliveries, Pickups, and CrossDock grids in Multi Mode Dispatch. The changes involve these fields:

If you have a SQL filter that references one or both of these fields, and you attempt to use it in TruckMate 2023.4, an error appears that is similar to the one in this illustration.

You must recreate your filter using TruckMate’s Quick Filter Builder feature, as it will not work as a traditional SQL filter. Quick Filters are written in JSON, as shown in this illustration.

For more information, see Quick Filters.

With this release, the Fixed SQL component has been modified for these trip grids in Multi Mode Dispatch:

These aliases have been modified as indicated:

If any of your filters contain a direct reference to one or more of these fields, you may experience issues when using them in TruckMate 2023.4. We strongly recommend you review and modify your filters prior to upgrading.

In addition, the maximum number of characters allowed for all filters applied to a grid at once has changed from 2500 to 8000. If the number of characters exceeds 8000, an error displays.

An Operational Plan Sequence column has been added to the Trips grid in Dispatch and to these grids in Multi Mode Dispatch:

This column shows the sequence of Trip Operation Planning trips created and linked to a specific operational plan ID. With it, you can see the order of planned trips more clearly. You can also use grid formatting and filters to show or hide trips that are outside a Trip Operation Plan sequence.

This illustration shows the ID and sequence columns in Multi Mode Dispatch.

This illustration shows the ID and sequence columns in Dispatch.

New information has been added to the About page:

In ConnectedDock Admin, you can now update a dockworker’s password from within their user profile.

You can update passwords regardless of whether users are logged into ConnectedDock. If you update their password while they are logged in, their session is not affected. They must use the new password the next time they log in.

Previously, the only barcode type supported by ConnectedDock for Keyence devices was Code-128.

Now, ConnectedDock also supports the Code-39 barcode type.

You must enable this support on devices manually. For more information, contact the Keyence support team.