Utilities: Members: Import Members
The easiest way to import addresses into ListManager is to use the Utilities: Members: Import Members page. This page allows you to import members from a text file or a csv (comma separated values) file. It also allows you to import members with additional demographic information.
File Type
Select "Email Addresses with Optional Names" if you are importing a text file, and "CSV File with First Row Column Names" if you are importing a csv file.
Email Addresses with Optional Names
To import email addresses or email addresses or names, the file must be a plain-text file. Each email address and name must be on a separate line, and must be in one of the following formats:
bob@shelby.com
bob@shelby.com Bob Shelby
bob@shelby.com (Bob Shelby)
Bob Shelby <bob@shelby.com>
CSV File with First Row Column Names
A csv file has the information you would like imported in a csv (comma separated values) format. The first row of the file tells ListManager which field the data in each column should be imported into. For example:
EmailAddr_,FullName_,Company,Phone
bob@shelby.com,Bob Shelby,Shelby Corp.,510-549-4350
In this example, EmailAddr_ and FullName_ correspond to the default database fields in the Members_ table for email addresses and full names.
Additional fields called "Company" and "Phone" have been added to this Members_ table, so this information can also be imported into each member's record. (These fields are not provided by default; you will need to add them to your Members_ table if you would like to store this information).
The "EmailAddr_" column name is required. You may add other data if you like. Some default Members_ table fields which you may want to include in your import are:
Additional_
Placeholder for any information you want to store associated with this member.
Comment_
Holds whatever comments you wish to put in. Useful as a user-defined 'additional info' field.
EmailAddr_
The email address of this person (required).
FullName_
Full name of this person.
MailFormat_
What mail format does the user prefer, (T)ext, (M)ultipart, or (H)TML.
UserID_
Holds the user-definable 'user id' information, such as a key back to another table.
You may also have your database administrator add additional columns to your Members_ table so it can store additional information about each member. Ask your database administrator about what these field names are so you can properly label the columns of your data before importing it.
Action
You may import members in one of three ways:
Import Quietly as Regular Members
Import the members into the list, but do not send a hello or confirmation message. These members will receive normal list mailings.
Import as Regular Members and Send List Hello Doc
Import the members into the list, and send them the hello message as specified for your list in Utilities: List Settings: Basic Information: Documents. If no document is specified here, new members will receive a generic message from ListManager. These members will receive normal list mailings.
Import as Unconfirmed Members, and Send Confirmation Request
Import the members into the list as unconfirmed, and send them the confirmation message as specified for your list in Utilities: List Settings: Basic Information: Documents. If no document is specified here, new members will receive a generic message from ListManager. These members will not receive normal list mailings until they confirm their memberships.
Select File
Enter the path of the file that contains the members you'd like to import. Or, select Browse to find the file.
More
2. Utilities: Members Main Page
3. Utilities: Members: Find Members
4. Utilities: Members: Create Members
1. Utilities: Members: Create Many New Members
2. Utilities: Members: New Member
3. Utilities: Members: Import Members
5. Utilities: Members: Delete Members
|
|