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

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.

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

More

1. Utilities: Administration: Server: Database

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

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

2. Utilities: Administration: Server: Database: Add Member Column Wizard

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

4.