In this article we're going to review how you can import multiple users into phpList to save you time from having to create them one at a time.

If you already have a large list of users that you've been mailing with another application, you might like to start sending messages to those users from phpList. It's much easier to simply import them all at once instead of relying on adding them yourself one at a time.

WARNING! Per our Terms of Service, you can only send mailing lists out to opt-in email addresses. This means that each user on your list needs to confirm their continued interest in receiving your mailings before you mail them on a regular basis.

Import users with attributes

Following the steps below, you'll be able to take a formatted tab delimited text file or CSV (Comma Seperated Value) file of users, and add them into phpList.

If you've been following along in this phpList education channel, our example lists are using the attributes FirstName, LastName, and Interests. So we'll want the text file that we're importing to match up to what phpList is going to be expecting for users.

In this example, we're going to be using a Tab delimited list. This means that a Tab separates our fields of data. The example text file we'll be importing looks like this:

email	First	Last	Likes
user001@example.com	User	ZeroZeroOne	Animals
user002@example.com	User	ZeroZeroTwo	Computers
user003@example.com	User	ZeroZeroThree	Animals
user004@example.com	User	ZeroZeroFour	Computers
user005@example.com	User	ZeroZeroFive	Computers

We've got our fields in this text file set to email, First, Last, and Likes. These will match up nicely to the attributes we already have defined in phpList.

  1. Login to your phpList admin dashboard.
  2. click on manage usersFrom the menu on the right, click on manage users.
  3. click on import usersUnder Control values for, click on import users.
  4. Click on the first option of import emails with different values for attributes.

    This will allow each of our imported users to have their own unique attributes, we want this since the text file we're importing already has unique information for each of them.

  5. select details for import click on importUnderneath Select the lists to add the emails to, select the mailing lists you'd like the users you're about to import added to. In our case we chose Weekly newsletter.

    Beside File containing emails, click on Choose file, then navigate on your local computer to the location of your text file of users.

    For our example you'll want to leave both Field Delimiter, and Record Delimiter blank. If you were using a CSV file, you'd want to set a comma , as the Field Delimiter.

    Then you'll want to place a check-mark beside Test output, this will ensure the columns of data we're importing line up with our phpList attributes we've already created.

    The other options aren't really going to apply if this is your first time importing users into phpList, each one should be self-explanatory as to what they do.

    Finally scroll to the bottom of the page and ensure that you select Send Notification email to comply with our TOS, then click on Import.

  6. assign attributes for import from drop downYou should now be on the Import Attributes page, this is where you'll want to assign the values for the columns from your text file to match up with your attributes. This is accomplished by selecting the attribute you'd like to assign a certain column to, from the -- Create a new one drop-down.

    These are how we lined up ours:

    First FirstName
    Last LastName
    Likes Interests

    After selecting all of your attributes, click on Continue.

  7. review import click on confirm importOn the next page you should see the Test Output from your import. If everything looks like it matches up without any issues, click on confirm import.

    If for some reason things didn't line up, click on reset import session at the top of the page and start over.

  8. You should now see that your users were successfully imported with a confirmation message along the lines of:
    Reading emails from file ... ..ok, 6 lines
    5 emails succesfully imported to the database and added to 1 lists.
    5 emails subscribed to the lists
    0 users were matched by foreign key, 5 by email
    

    click-on-usersTo see the users that you've just imported, from the menu on the right, click on users.

You should now have successfully imported a list of users into phpList saving yourself a lot of time!

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Like this Article?

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!