Import users into phpList

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 
[email protected]   User    ZeroZeroOne   Animals 
[email protected]   User    ZeroZeroTwo   Computers 
[email protected]   User    ZeroZeroThree Animals
[email protected]   User    ZeroZeroFour  Computers
[email protected]   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 users

    From the menu on the right, click on manage users.

  3. click on import users

    Under 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 import

    Underneath 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 down

    You 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:

    FirstFirstName
    LastLastName
    LikesInterests

    After selecting all of your attributes, click on Continue.

  7. review import click on confirm import

    On 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 successfully 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-users

    To 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!

InMotion Hosting Contributor
InMotion Hosting Contributor Content Writer

InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!

More Articles by InMotion Hosting

Was this article helpful? Join the conversation!