[Baruwa] importing bulk users

[Anis Jendoubi]

Hi,

I have a situation where I need to create around 750 users/profiles in baruwa, does anyone know which SQL command and which table(s) that need to be affected to add theses users without affecting anything else (as I presume the informations about users are in the DB). I know I can use authentication server tab to do it automatically but this functionality does not work as my expectation (because users have to login as us...@domain.local instead of us...@domain.com), that's why I have to create all the profiles manually.

My version of Baruwa is v1.1.0

Thanks for any help with the SQL command that would do the job (as I'm not a developer/programmer ;) )

Anis

[Jeremy McSpadden]

I would honestly work towards using external authentication. Trying to maintain 2 sets of users, especially with 750 of them; is not best practice. 

What errors have you run into when setting up the authentication? .local should work. You can also use USER instead of USER@domain

--

Jeremy McSpadden

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

[Anis Jendoubi]

Jeremy, thanks, we have multidomain filtering, so actually the users login with their public email adresses, for this specific situation we cant let users login with the .local extentions as most of them are not aware of that, and secondly we can use USER either beceause in multitenant/multidomain situation there could be same USER i two different tenants which conflict with the idea of having multitenant system.
I'm interested even to pay someone who would write even a shell script to connect to the customer ldap (MS Active Directory), pull all the mailboxes with their aliases and import them to the baruwa db (all set with a predefined password). Anyone interested?