Import Joomla Users from Excel or CSV File
Migrate users with custom data fields as User-Profile plugin is supported

  • Imports new users & updates data of existing users in Joomla.
  • Supports custom "Users Fields" and User-Profile plugin fields.
  • Sends customized "Welcome" emails to imported users.
This remarkable extension allows to import users from Excel or CSV file into Joomla. All users will be created as regular Joomla users, so you can manage them in admin panel and new users get all benefits of registered accounts on your web-site!

User import extension supports wide range of fields:

  • Joomla core user data: Id, Name, Username, Password, Email, Params, Register Date and Group(s).
  • Joomla Users Fields: Any custom fields created by new Joomla 3.7+ Fields system.
  • Preinstalled User-Profile plugin: Address 1, Address 2, City, Region, Country, Postal/ZIP Code, Phone, Website, Date of Birth, About, and any other custom fields.

Main features of user import:

  • Create new users, update data of existing users or do both actions simultaneously.
  • Columns order in Excel/CSV file is not essential.
  • Allows to import users into one or a few Joomla groups.
  • Gives possibility to set new password for users (plain or already encrypted one).
  • If there are no passwords in your file - import can create passwords for new users automatically.
  • Notifies new users by email about registration and provides with login/password.
  • "Email Sending Report" is available, so you can check that emails were sent to users.
  • Allows to save import settings into "Profile" for frequent import.
  • Possibility to block users automatically which are no longer exist in Excel/CSV file.
  • Grant and revoke access to import extension for your coworkers.
  • Import multiple checkbox values.
  • Auto user import by schedule is available (using Cron).
  • Import into "Improved AJAX Import & Register" extension fields is supported.
  • Supports most of third party components like "K2" or "AcyMailing".

Buying import extension, you also get:

  • Updates to a new versions.
  • Best support by Email, Skype, website chat or TeamViewer.
  • Consultations how to setup import most efficiently in your specific case.

What our clients say about import extension:

Difference between "User-Profile Plugin" fields and "Joomla User Fields".

User-Profile plugin is a pre-installed Joomla extension which is disabled by default.
You can enable it here: Admin panel->Extensions->Plugins:

Plugin allows to extend Joomla core user fields and adds one more tab with additional fields to user profile.
You can find these additional fields here: Admin panel->Users->Manage->Select any user:

Plugin also puts these fields for each registered user in their profiles on website, so they can edit data in these fields. Unfortunately there is no easy way to customize/add/remove these fields without additional extension or extra codding work (however if you're familiar with XML, you can do it). Our import extension supports all these fields and can import data from excel/csv file in these fields. Even if you customized or created new fields via XML - import extension will support them.

Joomla User Fields supported by Joomla 3.7 and later. These fields have a huge advantage compared to User-Profile plugin - you can customize/add/remove them as you need. A wide range of fields available: text, dropdown, link, check box and much more. You can find these fields in Admin panel->Users->Fields

In my case I have created 4 custom fields which are available in user profile in admin panel and on website.


All fields created with "Joomla User Fields" system supported by our user import extension.

Conclusion: User-Profile plugin is a much older and less flexible way to store users data. So if you are looking for a way to store more data about users then it is better to start with new "Joomla User Fields". However if your website uses "User-Profile" fields for a long time and it perfectly meets your needs then there is no necessity to stop using it.


"Profile" feature.

"Profile" is a template with import preferences. It was created to save your time by settings up import settings once instead of doing this each time.

Let's see how to set it up. For example, we've got a file with users from third-party website and we need to create accounts for those users in our Joomla website. Since we must update users every week - it's better to use "Profile" feature.

How to create "Profile":
1. Upload file and go to next step.
2. On the 2nd step, match file's columns with Joomla fields, select Joomla group and other settings you may need.
3. Click "SAVE PROFILE" button, give "Profile" a name and click ["Save profile"]. That's it - profile has been created.

How to use Profile:
1. Next time we open Import Users page, we'll see saved profile button. We should click on it & select file.
2. Go to next step. On the 2nd step, all settings, we’ve chosen before, already pulled up from Profile and automatically applied. So we only need to check if everything is okay and go to next step.

Here is some useful cases when "Profile" feature comes in handy:
- file with users information has to be imported several times, for example, each week;
- you have two or more different files and each file has its own columns’ order;
- when you need to import all users from file #1 into e.g. "Managers" group and users from file #2 into "Editors" group – just create 2 profiles.

That's all you need to know to start saving time now!


Sending emails to imported and/or updated users.

“Import Users” tool provides option to notify new and/or existing users. With this option you can send personalized messages along with users data like Name, Address, Password, etc.

In the below example, we’ll show how to set up email sending to newly imported users. Since user mailing is turned off by default, let’s enable it by following these steps:

1. Click at “Switch to Advanced mode” link on 2nd step:

2. Tick “Notify newly added users” option:

3. Let’s use Email Template popup to set up email preferences:

“Import Users” offers two types of variables:

  • “Default” – pre-defined variables list that includes common-used variables, like Name, Username, Website;
  • “Dynamic” – they pull values from imported file on the fly.


“Default” & “Dynamic” variables that available in email “Subject” and “Body” fields, you can find here:


For example, we match “Name”, “Username”, “Email”, “Address 1”, “Region” and “Postal/ZIP code” fields:


Then after we go back to Email Template and click at “Add Matched Fields”, we’ll see available variables. To insert any of above variables, just click at it.
Tip: in case if “Matched Fields” popup comes up empty – it means that columns from file haven’t been matched with Joomla fields. So do columns matching first.

In case if you want to use custom text colors, insert image or change sizes, please use “Source Code”. With it you can change HTML the way you need. To turn it on, go to “Tools” - > “Source Code”:

After finishing configuration of email template click “Save”.

In case if you want to email existing users as well, enable “Notify existing users” option and set it up as previous.


Screenshots

Import Users to Joomla step 1 Import Users to Joomla step 2 Import Users to Joomla step 3 Import Users to Joomla step 4

Need New Feature?

Make sure you left your contacts in message, so we could contact you.
payment security
payment security

FAQ

  • By default Joomla has preinstalled plugin called "User - Profile".

    It allows to store more data about users like Address, City, Country, Website, etc.

    But this pugin is disabled by default. To enable it you need to go to:
    Admin Panel->Extensions->Plugins and use search to find "User - Profile" plugin.

    If plugin disabled - enable it, and you will be able to see additional information for each users here:
    Admin Panel->Users->Manage->Select Any User->User Profile Tab

    These fields can be changed, so it is possible to add new or remove current ones with special extensions, for eaxample with this one.

    Our import supports it and can import data from your file into "User - Profile".
  • “Welcome” mails are disabled by default, but you can enable them in advanced settings on Step 2. You can even create your own message and send login/password.

  • Yes, our import supports all characters from UTF-8, for example: Ü, ß, É, 字
    But your file should be in UTF-8

  • Don't match (using sandwich) the password column on step 2. The import will create password column automatically on step 3

  • You need to do next steps:
    1. You need to click on "Switch to Advanced mode".
    2. Then you need to check "Notify newly added users".
    3. At message dialog click "Tools" then click "Source code"
    4 In "Source code" editor you can use HTML to customize your email the way you need.

  • 1. Your file should contain column where Groups are separated by comma, e.g. "Editor, Manager, Administrator". So that one user can have any amount of Groups.
    2. On "Step 2 (Settings)" match the column with "Groups" field. Please note that you no longer need to use "Joomla group:" dropbox.

  • Fortunately, there is such possibility.
    Joomla has "Require Password Reset" option and when it's enabled user will be required to change his password on the first/next login.
    To enable this you will need to have column in excel/csv file with values "Yes" (to require password reset) and "No" to not require it. And match this column with Joomla "Require Password Reset" field.

  • Fast way to fix this issue is to change settings in Joomla administrator panel. Please go to: System -> Global Configuration -> Server and change "Error Reporting" field to "None" value. If it don’t help - please contact us and provide us with ticket number.

  • Unfortunately Auto updater is not available for this extension.
    To get the latest version of import you need:
    1. Go to our website: www.UkrSolution.com
    2. Login and go to "My Products" menu.
    3. Here you will find all your extensions and can download them.

  • To find out the reason why some users can’t be imported - you just need to hover your mouse over the user in tab “Won’t be imported”.

  • Our extension is using standard Joomla functions to send emails, so actually we don't have much control on this process. Import extensions just gives email to Joomla and if Joomla's and Server's mail configurations are correct - email will be sent to inbox.

    So if users don't receive emails the problem might be in:

    1. Incorrect Joomla email configuration - ask your developer to check it out.
    2. Problems with mail service on the server - ask your system administrator to check it out.
    3. Some emails comes to spam/junk folder - ask user to check these folders too.
  • Our extension is using standard Joomla functions to send emails, so actually we don't have much control on this process.

    This issue is based on a few factors, which can be fixed/changed by server administrator and domain owner.

    1. Correct mail server configuration
    2. Server's IP might be black listed, you can check it here: http://mxtoolbox.com/blacklists.aspx
    3. You can use DKIM, SPF, DMARC to make your domains valid for mass mailing
    4. Keep valid reverse DNS records for the IP address(es).
  • Maximum file upload size is a global PHP setting (called upload_max_filesize), you need to increase this value. Most hosting providers allows to change this setting in your Hosting Control Panel. Also you can ask your system administrator or developer to change it.

  • You need to send email to us and provide us with details:

    1. How to reproduce bug
    2. Screenshots of bug
    3. Best way to describe the problem is to create video (you can use software like Jing)

    If you subscribed to support, you can count on fast update (1-2 work days)

  • Our extension doesn't support joomla's auto updater.

    You need to login on our web-site and download last version:
    My Account -> My Products -> Select your product -> Download button
    After it you need to remove old version from your joomla and install a new one.

  • If you need some additional fetures, there are 2 ways:

    1. Send us email about new feature, and we will try to implement it in next version. As we receiving a lot of suggestions some of them can be rejected.
    2. We can create special release for you, in a short time, with all improvements you need for separate payment. Please contact us to know more about it.
  • Contact form on our web-site: https://www.ukrsolution.com/ContactUs

You also might be interested

Export/Download Joomla users (+ User Profile) to Excel or CSV file

Export/Download Joomla users (+ User Profile) to Excel or CSV file

 
 
 

This extension will help you to export (download) Joomla users (+ User Profile) to Excel or CSV file. User friendly interface allows to do export with the least effort. Please, check out our short video to find out how it works. Read more...

User Profile Custom Fields Editor

User Profile Custom Fields Editor

 

This extension allows you to add custom fields on registration form and in User Profile.

This "User Custom Fields Editor" component extends standard Joomla "User Profile" plugin (which is installed on your Joomla website. You need to enable it.), so "User-Profile" becomes a great tool for managing users data and extra fields. Read more...

Write comment, question, opinion :



You will be charged by «Lerus» Ltd.