Click on "Import" to start the import wizard.
Database connection | SuperMailer needs a connection string for every database
access to connect with your database server. Click on "New
connection" to create an new database connection.
hint:
|
Button "New connection" | Click this button to create a new connection or to change
the selected one. Now a wizard ("Database connection properties") will pop up, please follow the instructions in this window. This wizard has its own help functions provided by Microsoft.
|
Button "Connect" | If you have insert a connection string correctly, then click
on "Activate connection" . After that SuperMailer creates an
connection to this database.
hint:
|
List of tables | This list contains all tables in the selected database,
select a table to load all field definitions to define all import field
identifiers.
|
Button "Get structure" | If you click this button, all existing recipients will be
deleted from your list of the recipients. After that, SuperMailer imports
the field structure of this table.
|
Button "SQL query"
|
You can create your own SQL query, to perform complex table
queries or to import recipients with special conditions.
If you don't create your own query SuperMailer will ever use the query SELECT * FROM <table name>.
|
Allocation to SuperMailer field | Select (activate the checkbox) on all fields which should be
imported. After that, perform a double click on every fieldname to define
the corresponding SuperMailer field identifier. For example table field
"name" could be imported to SuperMailer field identifier
"name" in your list of recipients. If you start the import,
SuperMailer will transfer all data to this field name.
|
don't delete existing recipients list | Activate this setting and SuperMailer will not delete your
existing list, instead it will only append new data.
Hint:
|
Import to recipients group | Select the recipients group the recipients should be
imported.
|
Button "Import now" | Click on this button to start the import. This button is
only active, if at least one field identifier is assigned to a table field
and you have an active database connection.
|
Import automatically on opening project file | Activate this option to let SuperMailer import your
recipients on opening the saved project file automatically.
|
ODBC driver
Various ODBC driver are already installed on your windows system, for example MS Access ODBC driver. Many drivers can be downloaded on their manufacturer homepages, other drivers will be installed automatically if you install a database client or server. A MySQL ODBC driver can be found on http://www.mysql.com/.
Create a database called addresses. This database contains a table customers. The table has following structure:
fieldname | data type |
ID | auto increment |
name | char (50) |
firstname | char (50) |
char (50) |
create database alias
Open system panel and click on "data sources (ODBC)" , you also can start odbcad32.exe.
The following screenshot is system specific, here the german variant.
Click in tab User DSN on button "Add".
Now choose "MS Access driver" and click on button "finish".
Insert name "addresses" in field "datasource name" or insert any other alias name without spaces.
Click on "Browse" to search for your database name addresses.mdb and select it. The other options are depends on your database manufacturer, because every driver or database system uses other properties.
Click on "OK" to save this alias.
Click on "OK", to close the wizard. Now you can define this database connection within SuperMailer.
Create Database connection
Click on button "New connection", the following dialog pops up.
Choose tab connection
Now select first the alias name as data source, here "addresses".
Click on "OK" to save this connection.
Activate connection
Click on button "Connect" to establish a connection to your database. SuperMailer will add all database tables to the list of tables
If you select a table in this list, for example table customer, then the structure of this table will be scanned and shown below.
Select every field which have to be imported and define an SuperMailer field identifier corresponding to this field.
Click "start import" to transfer the data to SuperMailer.
IMPORTANT!
SuperMailer imports only tables, whose table name contains no spaces or special
characters. If you try to import an table name which contains spaces or special
characters, SuperMailer will abort the import.