On Tuesday, June 08, 2004 4:42 PM
Charles R. Thompson
I want to run through the entire OTRS tickets table and add each customer_user_id as a customer with the same password in the customer users' list. How might this be done? Can it be done via SQL?
Although we do not recommend working on the raw database, it were possible this way. Be cautious, though. What do you mean by customer_user_id - The customer_id, ie. login? Then the SQL statement were: UPDATE customer_user SET customer_id = login, pw ='CryptedPassHere';
My concern is that maybe the passwords have to be encrypted. I was wondering if I could encrypt a simple password and use that encrypted string for all the others.
Yes. Best were to use the password entry of an existing customer user. hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388