The main Ultra One2OneMileage dialog box looks like this:
One2OneMileage requires a database for input, and the results are also written to this database. Locations are provided as longitude,latitude coordinates, or named points. Named points are defined in a separate table in the same database, or in a Maptitude point layer.
The database must contain a table with one row per route to be calculated. It must have field(s) that specify the start and destination locations. There must also be a primary key that allows the rows to be unique identified. The table must contain one (or more) data fields to store the results. The options are: distance, time, cost, and error. The error field must be a text field, but the others can be a number or text field. An error field is strongly recommended as it can be used to diagnose any problems. The errors are listed in the Error Results page.
Supported databases include Microsoft Access (64 bit only) and ODBC connections. Microsoft Excel is also supported although it is not recommended. Excel is not a true database: it is very inefficient when used as a database, and is weakly typed. This can cause a range of setup problems, hence we do not recommend the use of Excel. Potential problems and workarounds for Excel are explained further in the Frequently Asked Questions.
First set the road network (road pack) information in the Road Data box.
Next, set the database, table, and field definitions in the Database Parameters dialog box. This is displayed by pressing the database Change button. The database section of the main dialog box also provides a text description of which database parameters (if any) still have to be set. The location fields are also set via this dialog box.
The Routing Parameters specify the units, rate table information, and route types to find. They are described further on the Routing Parameters page.
The Start button is enabled when all the parameters have been set. Press this to start processing. The status indicator will report the present status. The Start button will be renamed Stop during processing. Press to halt processing.
One2OneMileage can require a lot of parameters to be set. To make it easier, configuration parameters can be saved or restored using the Configuration buttons.The configuration settings also include the ability to run in Batch Mode (without a dialog box), and to write the processing progress and any error messages to a log file. Press the Log & Batch Settings button to set these options.
The Using Ultra One2OneMileage with an Access database example includes a walk-through of all these parameters.