To download a PDF of this document, please see the attachment.


How To Extract a TMW Suite File

Running the Inter-Tax Agent (usually done through the created desktop icon), there is a tab within the agent called "History" and another one called "Manual Extract". To re-pull a given period, visit the “History” tab and delete the history of the period you wish to pull for (a given day, a week, a month, etc.). Then go to the “Manual Extract” tab and hit Start. The Inter-Tax Agent will recognize the date range as missing and re-extract those files to catch up.

Example with FUEL:

  1. Launch the Configure Inter-tax Agent shortcut
  2. Select the appropriate extraction in the top left box. This is typically called Default if there is only one extract, or may be renamed to a specific Company or type of extract especially in the case of multiple extracts
  3. Click on the History tab in the middle of the GUI window
  4. In the drop down, select FUEL
  5. Find the appropriate date (example 1/1 - 2/1)
  6. Select the extraction, and click Remove
  7. Click Save Settings in the upper right
  8. Click on the Manual Extract tab, and click start to begin re-pulling the Fuel data.


Note that the same steps apply for GPS, Dispatch and Tractor extracts as well.



It is often also a good to check if data was in TMWSuite first. You can run a basic SELECT, to see if it retrieves data:

Example for GPS

SELECT * FROM checkcall WHERE ckc_date >= '20151104' AND ckc_date <= '20151105'

Example for FUEL

SELECT * FROM fuelpurchased WHERE fp_date >= '20151104' AND fp_date <= '20151105'

Example for TRACTOR

SELECT * FROM tractorprofile WHERE trc_retiredate >= '20151104' AND trc_startdate <= '20151105'

Example for DISPATCH

SELECT * FROM legheader I INNER JOIN stops s ON l.lgh_number = s.lgh_number WHERE l.lgh_enddate >= '20151104' AND I.lgh_enddate <= '20151105'