Customer database configuration

The Customer database configuration dialog allows to specify a mapping between an external customer database and the address information fields in RadiMation^®.

Location

In this field, the location of the database must be entered. It is also possible to press on the small button behind the textbox, after which a popup window will be shown that allows the end-user to select the correct customer database. If an ODBC connected database is used, a dialog will be shown which allows to select an already created ODBC data source.

Table and Fields

It is necessary to specify in the customer database configuration, which table and column(s) should be used, to correctly map the information in the customer database to the data in RadiMation®. There for the following selections must be made. It is not necessary to specify a selection for each and every field, but the Table and Company has to be specified. Table The table that should be used to retrieve the information from Company The database column name from which the 'company' name should be retrieved. Contact The database column name from which the 'contact' name should be retrieved. Address The database column name from which the 'address' name should be retrieved. Zip Code The database column name from which the 'Zip code' name should be retrieved. City The database column name from which the 'city' name should be retrieved. State The database column name from which the 'state' name should be retrieved. Country The database column name from which the 'country' name should be retrieved. Telephone # The database column name from which the telephone-number should be retrieved. Fax # The database column name from which the fax-number should be retrieved. E-Mail Address The database column name from which the e-mail address should be retrieved.

Advanced

Shows some more advanced settings for the customer database configuration: Use default query Will configure the customer database driver to use the default SQL query, which uses the selected database column names. The SQL query that is used will be shown in the Query textbox Use customized query Allows the end-user to specify a specific or more detailed SQL query, that should be used by the customer database driver. The SQL query can be specified in the Query textbox Query Shows the SQL query that is used by the customer database driver. If the Use customized query option is selected, it is possible to change the SQL query Login Name Allows to specify a login name that should be used to the connect to the customer database. The default value is 'admin', which should be correct in almost all situations Password The password that corresponds with the specified Login Name which are necessary to connect to the customer database. The default value is ' ', which should be correct in almost all situations Load Database Tries to connect to the selected database, using the specified Login Name and Password, to determine the list of available tables and column names.

Structured Query Language