Importing Users With Csv

EasySocial allows you to import users using CSV files. But before starting importing, you'll need to ensure that your CSV file contains the appropriate values set. The following values are the mandatory fields needed by EasySocial.

Mandatory Fields

• Name
  This would be the user's name.
• Username
  This would be the user's username.
• Password
  This would be the user's password. It can be plain text or an encrypted MD5 hash. (Make sure you're using Joomla's encryption method)
• E-mail Address
  This would be the user's email address.

Below is an example of the CSV file.

Importing User's Avatar

If you have got a set of avatars that you would like to assign to the users, you can insert the avatar's filename into the CSV files. Then, ensure that the new user avatar's files are uploaded to this folder: /media/com_easysocial/tmp/importer.

During the import process, you'll need to map the avatar field to the CSV column correctly. This is to ensure that the importer script can pick the correct avatar to be assigned to the users.

Import Steps

Following are the simple steps to import users using a CSV file.

1. Navigate to the user's import section at EasySocial > Users > Import. Locate the user's CSV file and choose the profile type for the imported users to be assigned to.

   

2. Click Confirm And Upload to start the import process. You'll then need to map the fields accordingly by choosing the field map dropdown for each of the columns.

   

   On this screen, you'll also be prompted with the following choices:

   • Auto Generate Password
     If you do not want to import the password for the users, you can generate a password for each of the imported users automatically.
   • Automatically Approve User
     If you've turned on the user registration moderation on your site, you'll need to make sure the imported users are automatically approved.
   • Password Type
     If you intend to import the user's password, you'll need to choose the password type.

3. Once you've finalized the mapping of the fields with the correct columns from the CSV file, click on the Confirm Fields Selection button and follow the steps on the following screen.

Importing First, Middle & Last Name

To import the First, Middle & Last names of the imported users, you'll need to specify each of them with a comma (,) such as "lee,chong,wei". The name format in the CSV must be in double quotes (").

• "first,middle,last" - This will store the names into the first, middle and last name respectively.
• "first,,last" - This will store the names into the first and last name respectively since the middle name is empty.