The addmembercolumns Command

 

The addmembercolumns command should be used only if using a foreign member table for ListManager.

 

To run the AddMemberColumns command, open a command prompt and change to the directory where ListManager was installed. On the command line, type

 

lm addmembercolumns

 

When this command is run, ListManager will check to see if the member table you named in lmcfg.txt exists, and also whether the email address column name and member ID column name designated in the lmcfg.txt file exist; if not, the command will fail.

 

If the following column names used by ListManager exist in the table, AddMemberColumns will fail. After establishing that these columns do not exist, these columns will be added:

 

     Additional_

     AppNeeded_

     CanAppPend_

     CleanAuto_

     Comment_

     ConfirmDat_

     DateBounce_

     DateHeld_

     DateJoined_

     DateUnsub_

     Domain_

     ExpireDate_

     FullName_

     IsListAdm_

     List_

     MemberType_

     NoRepro_

     NotifyErr_

     NotifySubm_

     NumAppNeed_

     NumBounces_

     Password_

     RcvAdmMail_

     ReceiveAck_

     SubType_

     UserID_



Using a Foreign Members Table Using a Foreign Member Table with Oracle or Postgres