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 MPMileage dialog box, and looks like this:
Set the parameters in this dialog box by starting at the top. As you set the parameters, MPMileage 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 ODBC. This is explained further in the Frequently Asked Questions.
Start with the Data Source Type. Select the required data source type. MPMileage will only list the data source types that are installed on your PC. MPMileage currently supports Excel, Access, SQL Server, ODBC, and Maptitude Data Views. Note that the 1993-2003 and 2007 versions of Excel and Access are listed as separate options. Similarly, ODBC connections can be User DSNs (Data Source Names), System DSNs, or File DSNs. Maptitude data views must be writable.
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.
The Access option will show a check box Set password to **** where the current password is hidden with '*' characters. Set this check box if your Access database requires a password. Press the Set Password button to set the actual password. Note: For security, the password is never saved in the registry or a configuration file. You will need to enter the password every time you start MPMileage.
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.
The Maptitude data view option does not require a file or connection name. All available data views in the current workspace are listed directly as tables.
When the database is selected, MPMileage 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 the connection and view both have full write/update permissions.
If the data source is an Excel file, then a checkbox 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 will be easier to read if the column names are listed on the first row.
When you select the table, MPMileage will query the table's data fields and list these as available data columns.
The input locations can specified in three different ways. These are set with the Locations are: drop-down box. Locations can be specified using Named Data Points, Street Addresses, or Coordinates. Press the Set Columns button to set these. This is described further on the Setting the Input Location Fields page. The Named Data Points option replaces the Pushpins option in the MapPoint version of MPMileage, and is displayed in the image above. This option also requires a Maptitude point layer (or dataset) specifying with the Dataset setting. You should also specify the dataset layer's field (Name Field) that stores the names or identifiers for the data points (see image below). These names are used to refer to the start and end locations in the main database, and equivalent to Pushpin Names in MapPoint.
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.
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 MPMileage to compute mileages for all data rows in the selected database.
Press OK when all the options have been set.