Lookup Table: From Fleetmatics

Settings


Sync & Save can be used to upload a list of Fleetmatics vehicles.

Fields will be loaded with a default list of fields. Click Edit to customize the list of fields. Field names must exactly match the field names below, but can be listed in any order. Field names should be separated by a comma.

Connecting to Fleetmatics


See this knowledge base article for instructions on connecting to Fleetmatics.

Changing an Existing Lookup Table


See this knowledge base article for instructions on changing the columns in an existing lookup table.

Filtering


See this knowledge base article for instructions on filtering.

Vehicle Fields

  • ClientDriverId
  • ClientVehicleId
  • Cost
  • CreatedDate
  • DeviceCode
  • DeviceId
  • DriverId
  • HasNavigationDevice
  • InitialMileage
  • Notes
  • Odometer
  • RegistrationNumber
  • VehicleId
  • VehicleMake
  • VehicleModel
  • VehicleName
  • VehicleYear
  • VIN
  • AddressCity
  • AddressLine1
  • AddressLine2
  • AddressState
  • AddressZip
  • EngineMinutes
  • GeoFenceName
  • LastLocalUpdate
  • Latitude
  • Longitude

Feedback and Knowledge Base