Import Templates

Follow the instructions below to prepare your file before importing it into iTracker. To download the file template and/or get instructions on importing your information into iTracker click on the item you wish to import below.

Preparing your file to import into iTracker:

  1. You can either copy and paste your entries into the template or make sure that your file looks exactly like the template
  2. The column names and sequence must be the same as the template
  3. All columns need to be in the file, if there is no data for a column leave it blank
  4. Once the information is in the file, save it as a .CSV

Import Addresses


Address Import Template

Required Columns: Customer, Address, City, State, Zip, Country

  1. Go to the Address tab
  2. Click on Import Addresses
  3. Navigate to the saved file you wish to import
  4. Click open to begin upload

Note: the larger the upload the longer the import will take, 1000+ entries could exceed 30 minutes in upload time.

Import Cost Codes


Cost Code Import Template

Required Columns: CostCode

  1. Go to the Scheduling tab
  2. Click on settings wheel and select Manage Cost Codes
  3. Click on Import
  4. Navigate to the saved file you wish to import
  5. Click open to begin upload

Import Drivers


Driver Import Template

Required Columns: FirstName, LastName, DriverNumber

  1. Click Add then Add Drivers
  2. Click on Import Drivers
  3. Navigate to the saved file you wish to import
  4. Click open to begin upload

Note: to give a driver access to iField they will need an email and a password. Then you can assign them a license in iTracker.

Import Fuel Receipts


Fuel Receipt Import Template

Required Columns: Date, Driver ID, Vehicle ID, Fuel Type, State, Gallons, Cost

NOTE: State must be the 2 letter abbreviation. Fuel type must be one of the following below, either the 2 character abbreviation or full name:

  • A5 – A55
  • DI – Diesel
  • E8 – E85
  • ET – Ethonol
  • GA – Gasoline
  • GH – Gasohol
  • LN – Liquified Natural Gas
  • LP – Propoane
  • M8 – M85
  • MT – Methonol
  1. Click Add then Add Fuel Receipts
  2. Click on Import
  3. Navigate to the saved file you wish to import
  4. Click open to begin upload

Import Jobs


Job Import Template

Required Columns: Description, Company

  1. Click Home then Import then Import Jobs
  2. Navigate to the saved file you wish to import
  3. Click open to begin upload

Note: if you do not know the start date leave that column blank.

Import Parts


Part Import Template

Required Columns: PartName

  1. Click Add then Parts and Materials
  2. Click on Import CSV
  3. Navigate to the saved file you wish to import
  4. Click open to begin upload

Import Service Types


Service Type Import Template

Required Columns: Name

Note: the name column can contain a service type name or code

  1. Go to the Scheduling tab
  2. Click on settings wheel and select Manage Service Types
  3. Click on Import
  4. Navigate to the saved file you wish to import
  5. Click open to begin upload

Import Stops


Stops Import Template

equired Columns: Address, City, State, Zip

  1. Click Add then Add Routes
  2. Click on Add Route
  3. Click on Import
  4. Navigate to the saved file you wish to import
  5. Click open to begin upload

Import Vehicles


Vehicle Import Template

Required Columns: Vehicle Number

  1. Click Add then Add Vehicles
  2. Click on Import Vehicles
  3. Navigate to the saved file you wish to import
  4. Click open to begin upload

Note: the vehicle icon will default to the truck icon; you can change this by double clicking on the vehicle.