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?
Can I use phpmyadmin to directly insert rows into the
#__user_usergroup_maptables? 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
idcolumn? Can I just find the largest id number and then simply
++for each user to be imported?
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?