Data Migration Guidelines and Template
OIL WELLS:
Each row is a well site.
The Name column (required) is the well site owner's company name
The short name column (required) is actual well site name.
Mark 1 for “yes” and/or 0 for “no” if the customer is a shipper, receiver, or yard.
OIL DEPOTS, SAND DEPOTS, AND FRESH WATER WELLS:
The Name column (required) is the customer's full company name and will be used in
reporting a billing.
The short name column (required) is an abbreviated version of the company's full name and
is what will be displayed on the handset and dispatch boards.
Mark 1 for “yes” and/or 0 for “no” if the customer is a shipper, receiver, or yard.
ADMIN:
Name and short name are required.
This tab is used to collect data on the customers you will be using for billing.
Set biller to 1.
CARRIERS:
Only the first column, Name, is required.
DRIVERS:
Last Name and First Name are required.
Data for both owner operators and company drivers are collected (set in column D).
Only include Carrier name for the owner operators
ASSETS:
Class and Type are required fields.
Type will be either trailer, truck or pickup