Show/Hide Toolbars

Ultra Mileage

Navigation: Ultra One2One Mileage

Setting the Database Parameters

Scroll Prev Top Next More

The database, table, and data fields are defined using the Database Parameters dialog box. This is displayed by pressing the database Change button on the main One2OneMileage dialog box, and looks like this:

 

one2one_dbparams

 

Set the parameters in this dialog box by starting at the top. As you set the parameters, One2OneMileage will query the underlying database and fill in the available options. Although Microsoft Excel is available as an option, it is strongly recommended that you use a proper database such as Microsoft Access or an ODBC connection. This is explained further in the Frequently Asked Questions.

 

Start with the Data Source Type. Select the required data source type. One2OneMileage will only list the data source types that are installed on your PC. One2OneMileage currently supports Excel, Access, and ODBC. Pre-2007 versions of Excel and Access are not supported. ODBC connections can be User DSNs (Data Source Names), System DSNs, or File DSNs.

 

If the source type requires a database file (i.e. an Excel or Access file), select the input data file by pressing the Data Source "..." button. This will display the standard Windows file selection dialog box, allowing you to select the file.

 

If you have selected ODBC as the data source, then you must enter the connection's Data Source Name (DSN) in the Data Source text box. The DSN defines an ODBC connection to a database. The DSN can be a User or System DSN (as defined in the registry); or as a File DSN. Use the Data Source "..." button to select the required DSN. The ODBC options also let you specify or override the username/password. The DSN selection options and username override options are described on the Specifying an ODBC Data Source page. Note: Setting the ODBC parameters for a database that is located on a different PC or server can be slow.

 

When the database is selected, One2OneMileage will automatically query the database's list of available tables. These will be listed in the Table drop-down box. Select the table that you wish to use. This is the one that lists the start and destination locations for each of the required routes. For ODBC database connections, you can also select database views, but you must ensure that both the connection and view have full write/update permissions.

 

If the data source is an Excel file, then a check box will be displayed. This allows you to specify if the first row of the selected spreadsheet contains the column (field) names. It is recommended that you do this, because the spreadsheet is easier to read if the column names are listed in the first row.

 

When you select the table, One2OneMileage will query the table's data fields and list these as available data columns.

 

The input locations can be specified in two different ways, and this is controlled by the Locations are drop-down box. Locations can be specified using Named Points, or Coordinates. Press the Set Input Columns button to set these. The location input fields are described further on the Setting the Input Location Fields page. The Named Points option also requires either a Maptitude MAP file that contains a point layer of named points, or a second table that lists the coordinates for the named points. This is selected using the Points are in a drop-down box, and the appropriate settings specified by pressing the Set Input Columns button.

 

The Output Columns specify the columns to use for the calculation results. At least one of these must be set. The lists of available columns for the distances, times, and costs also include any numeric data fields that were found. The errors column must be at least four characters wide, and ideally at least 16 characters wide. It is strongly recommended that you set an errors column, because this can help you diagnose any routing or location problems.

 

The Row Selection options are used to select specific database rows for processing, according to the values in the Errors column. This is explained further on the Row Selection page. The default is "Select: all rows", which tells One2OneMileage to compute mileages for all data rows in the selected database.

 

Press OK when all the options have been set.