Importing Email Addresses
If you are moving your mailing list from another list manager program to ListManager, you will probably want to import into ListManager the email addresses of your list members.
The easiest way to do this is with the Create Many Members button in the Members Page of the List Admin menu. See First Members Page. This method is recommended if the number of members to import is small or you do not have any programming resources available to take advantage of other methods.
Another method is to add members using an email command sent to the ListManager server. See Adding Many Members for more information on how to use this method.
In addition to these two methods, you may use a perl-script, imp-user.pl, that ListManager has created to import members. This script is flexible, and will import data in many different formats.
You may also import the data directly into your SQL server using tools provided by your SQL server. This method loads data most quickly, averaging speeds of 100,000 members per hour, but is less flexible about how the data may be formatted.
Note that the total number of members you may have on your server is determined by your license. Contact your account representative at sales@lyris.com if you'd like to increase the number of members you may have.
Using the Perl imp-user.pl script
To run this program, go to your web server's CGI directory (where the other ListManager Perl programs were installed) and enter the command:
perl imp-user.pl listname importfilename.txt
You will need to supply the mailing list name and the filename of the import file. The program will display progress information as it imports.
Note: By default, email addresses are checked for duplicates, so that duplicate memberships, if any exist, are automatically removed. If the command-line option 'skip' is specified after the filename argument, duplicates will not be removed. This is only recommended if you are sure that you have no duplicate addresses in your import list or in the existing membership.
The import program supports all the import formats supported by the web interface. Examples of these are:
"John Smith" <jsmith@yourcompany.com>
John Smith <jsmith@yourcompany.com>
jsmith@yourcompany.com (John Smith)
jsmith@yourcompany.com John Smith
jsmith@yourcompany.com
43212,3123
53445,3232 John Smith
The last two examples are CompuServe addresses that ListManager automatically converts into Internet addresses.
Additional member attributes can be set using the specifier [attrib=value] after the full e-mail address and user name.
For example:
User Name <email@address.com> [UserID=1234] [Password=password]
The following attributes can be set: RcvAdmMail, NotifyAdd, NotifyErr, NotifyDetl, ChangeSets, NoRepro, CanDelUser, AppNeeded, ConfirmDat, NotifyDely, IsListAdm, ExpireDate, DateUnsub, SubType, NumAppNeed, NotifyDel, NotifySubm, MessInterv, ReceiveAck, NotifyChan, Password, DateJoined, MemberType, CanAppPend, DateBounce, DateHeld, CleanAuto, NumBounces, UserID, Comment, Additional
Multi-line 'Comment' and 'Additional' settings are not supported. Default values for unspecified attributes are defined in the imp-user.pl script.
Note: If you have a ListProc ". subscribers" file that you want to import into ListManager, you will need to use the "implproc.pl" program to do this. This program functions in the same manner as "imp-user.pl", but reads the ". subscribers" format. To run it, type the command "perl implproc.pl". This script does not support additional member attribute specifications as described above.
Note: If you import a very large mailing list on Windows, that the speed on importing will gradually slow, and the size of the Perl script will grow. This is because Perl on Window leaks memory. If the speed of importing is important to you, you might consider importing members into your list in batches of 20,000, by splitting your member list into groups of 20,000 members. That way, the impact of the perl memory leak will be less strongly felt.
|
|