Create Bulk users through Backend

SuiteCRM Forum - English Language Developer Collaboration
1

Hi,
Is it possible to create list of users with role through back end? Help me thanks in advance.

2

Hi Vetri

Did you get anywhere with this?

Many thanks

Luke

3

Have any of you tried using phpMyAdmin to access the database directly and create lines in the “users” table?

I never tried it, but it seems feasible.

4

Hi

I’ve managed to do this with some simple SQL. You can also assign the user to a group my inserting into securitygroups_users

insert into users (id, user_name, user_hash, first_name, last_name, show_on_employees, deleted)
select newid(), [User Name], SUBSTRING(sys.fn_sqlvarbasetostr(HASHBYTES(‘MD5’,[Password])),3,32),[First Name], [Surname], 0, 0 from my_users

This is for SQL Server, but it’s very similar for MySQL

Regards

Luke

1 Like