Adding Multiple Users to Joomla
Sometimes 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
- Components > Akeeba Backup > Backup Now.
- Enter a comment and click Backup Now!
- 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.