Programmed Create User

[JohnDix]

Operating system: Ubuntu. Linux 2.6.15-26-server
Sugar: Sugar Open Source 4.5.1e
Webserver: Apache 2.0.55
PHP: 5.1.2
MySQL: 5.0.22

Is there a batch procedure for creating new Sugar users? I need to create many new Sugar users from existing database entries for another environment.

It did not appear possible to directly enter new user data into MySql, so I I tried to create new user accounts by logging onto the Sugar server from a Java HTTP Client instead of from a browser. I am trying to first log in exactly as though I were using a browser, and then upload some Create User form data, When I first receive the login form, it is accompanied by a PHP session ID in a cookie, but then the server rejects my login attempt by resending the login page, along with a new PHP session ID, but with a good HTTP return code (200). If anyone is familiar with this kind of problem, I would appreciate any advice, because this general approach should address my batch creation probelm.

[tomgerrard]

Hi John,

We have just migrated from Act to Sugar - I couldn't find a webservice way of creating users, so I just created entries in the users table which has worked fine for us.... Did you have problems doing it that way?

[JohnDix]

Thanks very much! You inspired me to retry inserting into the users table, and I did get it to work. On the off chance that I might help you a little in return, I wanted to say that I discovered along the way that the user_hash column is the md5 hash of the user's password.