Utilities: Administration: Server: Database: Add/Remove Member Columns: Add Column to Member Table

The members_ table is used by Aurea List Manager to store all information about your list members. It contains the fields it requires to send mail to each member and to keep track of their membership status. It also has three fields, Additional_, UserID_, and Comment_ that it does not use and that you may populate with the data you choose.

If you add additional fields to the Aurea List Manager members_ table, you may import or add members with additional data. Having these fields in the members_ table (as opposed to another table) allows you to use the wizards in Content to easily personalize your mailings. You may segment your list more easily as well.

Adding a Member Column

1. Go to Utilities: Administration: Server: Database Administration: Add Member Column.

2. Enter the Field Name. Valid field names should not have spaces.

3. Enter the Field Type.

Caution    Field Types must be one of the options listed below. Other types will produce strange results or cause errors.

Number (Integer)

Numeric data only (no characters).

Date

A date field.

One, Two or Three Character String

A field that must contain one, two or three characters; the length is not variable.

Variable Length String

A field that may contain characters or numbers, and may vary in length up to the max specified.

4. Click Add.

5. Restart Aurea List Manager and the Aurea List Manager web server for your changes to be visible in the Aurea List Manager web interface. The change has already taken place in the database, but Aurea List Manager must be restarted to recognize it.