Database Setup

The Loadman Fleet Manager (FM) database stores static information about your business (Customers, Services, and Routes) and dynamic data related to the Service having actually been performed.

The database content includes ...

Filling the Database:

It is possible to just start typing, the FM provides a complete set of data entry/edit tools to allow the database to be maintained completly within the FM.

However, in many cases the data already exists in some other computer application or database. The FM provides facilities to import data from just about any computer based source. This process involves you providing a description of the data, Creative Microsystems then provides you with one or more special files that customize the import facility of the FM to your needs, and you import your data. Of course some situations are simpler than others.

The fields that can be imported are...
The bare minimum required is a Customer identifier and a Route identifier. In this case the Route would be simply a list of Customer indentifiers making up each Route. The LoadData collected after the Route was run would be date/time, load, GPS, etc along with the Customer identifier.

If more data is provided to the FM then the FM can do more, such as provide addresses on the Route sheet, use your 16 character loadname to be displayed on the meter instead of the FM generating one from the Customer identifier (and optionally other fields), or provide more complete data export.

Also, if the import includes enough data, the FM can generate the Routes. If this is of interest, see the Route generation tutorial.