Adding Multiple Users to Joomla

joomlaSometimes you will need to add a collection of users.  There are Joomla extensions for this purpose, but this article shows you how to add many users quite easily, by using phpMyAdmin. This article was written for Joomla 3.4.

 


Backup

  1. Components > Akeeba Backup > Backup Now.
  2. Enter a comment and click Backup Now!
  3. Go to Administer Backup Files to download your backup in case your web server has a failure.

 

Prepare CSV files

You will need 3 .csv files for 3 different tables, with the following columns:

xxxx_users

You can leave some of these blank, but you here is an example

id, name, username, email, password, block, sendEmail, registerDate, lastvisitDate, activation, params, lastResetTime, resetCount, otpKey, otep, requireReset

99,Steven Pryer,stevenpryer,This email address is being protected from spambots. You need JavaScript enabled to view it.,R15AR9d.JHAu...,0,0,2016-01-26 00:00:00,

xxxx_usergroups

You might need to add usergroups, if you have new ones.  For a default Joomla installation, this might not be necessary.

id, parentid, lft, rgt, title

xxxx_user_usergroups_map

This final table, links users to their groups.  Create multiple records for users in multiple groups.

user_id, group_id

 

phpMyAdmin

Now using your favourite MySQL admin tool, upload the csv files.  Note that it is important that the columns of your .csv files and the table field names match when uploading using .csv files.  Dont' forget to obfuscate the first row.

 

Passwords

Note that if you leave the password field blank, users will have to reset their own passwords.  Otherwise you could set a password for an existing user, and copy the encrypted version of it from the database record to use in the spreadsheet.

 

Thanks for visiting.