1

I need to batch create lots of users and I have their emails and some profile details like phone number and address. This data is in a google sheet. I just need to generate usernames and set initial passwords for them before sending login credentials to their email. Security is not a concern. How can I do this programmatically?

  1. Can I use phpmyadmin to directly insert rows into the #__users and the #__user_usergroup_map tables? The password in the table is hashed, I have no idea how hard it would be to hash a password string and insert it into the table. Besides, what should I do with the id column? Can I just find the largest id number and then simply ++ for each user to be imported?

  2. Does Joomla have a class or function that offers this simple utility like JUser::addNewUser($username, $password, $email) so that I can just write some simple code to retrieve data from google sheet and feed it into a helper function like above?

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.