Import users from CSV file into Joomla 3 database
I've developed this tool for a massive users upload into some different joomla3 websites.
I hope it can be useful for you too.
This tool import users from CSV/TXT file into Joomla3 database.
This tool require a file formatted as:
Name1,Surname1,[email protected],password
Name2,Surname2,[email protected],password
Name3,Surname3,[email protected],password
...
...
Joomla Users Importer will generate an username and a password for each user.
Each username will be generated unifying lowercase "Name" and "Surname" CSV columns, using an underscore "_"
name1_surname1
Each password (if you will use auto generated password) will be generated unifying username with a prefix "password_"
password_name1_surname1
It's very easy and intuitive.
- Just upload tool by FTP on your server (where is running your joomla db)
- Upload your CSV file inside
joomla-users-importer/csvdirectory - Launch tool using a browser:
http://yourdomain.xxx/path/to/joomla-users-importer/ - Fill all form fields with your own data
You can find some documentation on tool form page
After each import Joomla Users Importer will save a detailed logfile with a list of all added users. Log files will be saved inside joomla-users-importer/logs directory
Names and/or surnames with some special chars as "D'Amico" will generate errors during import.