Import from database

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:
Every connection string can be modified by hand, but please, only if you know what you are doing.

 

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:
If the connection fails, then please check all parameters within the connection string.

 

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:
To avoid duplicates use the function "Remove duplicates".

 

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/.

 

Example Microsoft Access Database

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)
email 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.