Skip to main content

GeoTabs Data Mapping

See how Geotabs vehicles, odometer readings, engine hours, and GPS positions map to ToolWatch items, meters, and tracking.

The ToolWatch Geotabs integration is focused on ensuring that the two systems share vehicle inventories and current odometer readings.

Geotabs

Sync Direction

ToolWatch

Vehicles

→

Items

Odometer Readings

→

Meters

Engine Hours

→

Equipment Hours

GPS Position

→

Item Tracking


A uniquely-tracked tool will be created in ToolWatch for every vehicle in Geotabs.

When vehicles are first synced down from Geotabs, an attempt will be made to find a matching Model record in ToolWatch. If one is found, then that Model is used. Otherwise, a new Model will be created, along with any necessary Manufacturers and Descriptions. The Manufacturer, Model, and Model Year are determined by decoding the vehicle's VIN through the NHTSA VIN database — Geotabs does not provide these values directly. The Category is a single fixed value: "GeoTab" by default, or the Category Name configured in the integration settings.

The following fields will be mapped:

Geotabs Vehicle

ToolWatch Unique Tool

Notes

VIN

Serial Number, or VIN

ToolWatch uses the vehicle's VIN from Geotabs. By default it is stored as the Serial Number; if the "Use VIN" setting is enabled it is stored as the VIN instead. Geotabs' own serial-number field is not used.

License Plate

License Number

License Plate State

License State

Name

Model Description

The Geotabs vehicle Name.

VIN (via NHTSA decode)

Manufacturer, Model, Model Year

Decoded from the VIN via the NHTSA database, not read from Geotabs.

Status

-

All Geotabs vehicles are created as active in ToolWatch.

-

Category Description

A single fixed Category — "GeoTab" by default, or the configured Category Name.

ToolWatch does not set an Item Number or Barcode for Geotabs-synced equipment; those fields are left blank.


When vehicles are synced to ToolWatch, the vehicle's odometer reading is synced to the item's meter level.

Geotabs Vehicle

ToolWatch Unique Tool Meter

Notes

Odometer

Meter Level

Geotabs reports the odometer in meters; ToolWatch converts it to miles. The meter is only updated once the accumulated change since the last reading exceeds the configured Distance Threshold.


When the Sync Engine Hours setting is enabled, ToolWatch reads each vehicle's engine hours from Geotabs and records them as Equipment Hours. A new reading is only saved when it exceeds both the configured Engine Hours Threshold and the current on-file value.

Geotabs Vehicle

ToolWatch Equipment Hours

Notes

Engine Hours

Equipment Hours


When the Sync GPS setting is enabled, ToolWatch reads each vehicle's current GPS position from Geotabs and records it in the item's tracking history.

Geotabs Vehicle

ToolWatch Item Tracking

Notes

Latitude, Longitude, Timestamp

Tracking scan

Recorded as a GPS tracking scan against the item.

Did this answer your question?