Utilities: Administration: Server: Database Administration: Add Member Column

The Members_ table is used by ListManager 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 ListManager 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. Field Type options are:

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 ListManager and the ListManager web server for your changes to be visible in the ListManager web interface. The change has already taken place in the database, but ListManager must be restarted to recognize it.

1. Utilities: Administration: Server: Database

2. Utilities: Administration: Server: Database: View and Edit Data

1. Utilities: Administration: Server: Database: View Member Table

2. Utilities: Administration: Server: Database: View Table

3. Utilities: Administration: Server: Database: View Segment

4. Utilities: Administration: Server: Database: Run Your Own SQL Query

5. Utilities: Administration: Server: Database: View Query Results

6. Utilities: Administration: Server: Database: View Row

3. Utilities: Administration: Server: Database: Add/Remove Member Columns

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

2. Utilities: Administration: Server: Database: Delete Member Column

4. Utilities: Administration: Server: Database:Add/Remove Action Tag Columns