Skip to main content

Can LM Automatically Export the Members Table?

Teague James
  • Updated

Overview

As a Server, Site, or List Administrator on your LM installation, you want to get LM to export your members list automatically.  

Prerequisites

  • You are a Server, Site or List Administrator of your LM installation

Solution

Unfortunately, LM does not support automatically exporting your member data. However, there are methods that can be used to retrieve the Members' data which you can use to build a script that downloads the information for you.

LM provides several 'Command Email' addresses that can be used to perform various functions, including one that will return your members list. Alternatively, you can use the LM API to return this data based on the Introduction to the Application Programming Interface (API) PDF below.

Review-Listname Command Email

The review command normally returns basic information about a mailing list to the person who requested it. However, if the review command is requested by an administrator, after a login command, then the review command also returns a full list of the email addresses of the members of that mailing list.

  1. Using the email account associated with your ListManager Administrator account, send an email to review-listname@domain.com where listname is the name of your list and domain is your Internet Host Name configured in Lyris LM.

  2. In the body of the message include the command to retrieve the Members List after supplying your Administrator Password:

    For example, to get members' information from a list called "demolist", replace "ADMIN_PW" in the example below with your Admin Password:

    login ADMIN_PW
review demolist

    There are many options for the review command. If no arguments are given then members of type 'normal' are returned. Below is a short description of the function of each:

    • (none): Return only those members' email addresses who are of normal status ( default )
    • all: Return members of all types
    • names: Return the email addresses and names only (for normal members only)
    • full: Return email addresses, names, and other information (for normal members only)
    • held: Return only those members who are on hold
    • unsub: Return only those members who have unsubscribed
    • private: Return only those members who are of private status
    • expired: Return only those members whose subscriptions have expired
    • confirm: Return only those members who are of confirm status

    Usage

    review listname [all | names | full | held | unsub | private | expired | confirm]

    Example to retrieve email addresses, names, and other information, for normal members only: 
    login ADMIN_PW
review demolist full

ListManager will use the email address the message is sent from to identify the sender as a Server, Site or List Administrator, and then check the password provided in the login command. If the password you specified with the login command is correct, it will respond with an email that includes your Members' information.

 

Introduction to the Application Programming Interface (API) PDF DOWNLOAD