Importing data into Aurea List Manager

Aurea List Manager uses a single members_table, which contains the email addresses and other information it needs to send email messages.

You may already have data about your list members in your database table and like to use this data when sending out mail using Aurea List Manager.

There are several ways of having Aurea List Manager use this data, depending on how your database is set up.

Here are some suggestions:

• Add columns with pertinent member information to your Aurea List Manager members_ table, and import your members with this additional information. A CSV member import, triggers, the Aurea List Manager SOAP API, or ODBC database synchronization to keep the data between your other tables and the Aurea List Manager members_ table in synch.
• Import your members into the Aurea List Manager members_ table, and use a column to add to the members_table to refer to the primary key used by your other table. You may then create advanced subsets that join to that other table based on the added field.
• Import your members into the Aurea List Manager members_ table, and create a lookup table which matches the Aurea List Manager members_.MemberID_ field with the primary key of the table, which contains the additional data you need for your mailings. You may then create advanced subsets which join to that other table.

For more information, see:

• Members: Import Members
• Introduction to the API
• ODBC
• Joining to Another Table
• Member Fields

The topics below explain further how the importing of data into Aurea List Manager can be achieved: