>From /opt/otrs/scripts/database/initial_insert.sql: INSERT INTO system_user (first_name, last_name, login, pw, valid_id, create_by, create_time, change_by, change_time) VALUES ('Admin', 'OTRS', '[EMAIL PROTECTED]', 'roK20XGbWEsSM', 1, 1, current_timestamp, 1, current_timestamp); -- group_user (add admin to groups) INSERT INTO group_user (user_id, permission_read, permission_write, group_id, create_by, create_time, change_by, change_time) VALUES (1, 1, 1, 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO group_user (user_id, permission_read, permission_write, group_id, create_by, create_time, change_by, change_time) VALUES (1, 1, 1, 2, 1, current_timestamp, 1, current_timestamp); INSERT INTO group_user (user_id, permission_read, permission_write, group_id, create_by, create_time, change_by, change_time) VALUES (1, 1, 1, 3, 1, current_timestamp, 1, current_timestamp);
You don't have to add new users to all groups, of course. Regards, Robert Kehl ----- Original Message ----- From: "Lars Monsees" <[EMAIL PROTECTED]> To: "Otrs (E-Mail)" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 4:02 PM Subject: [otrs] CustomerUser import Hello, I used MySQL and sql statements to directly import users (originally from an access databases). The users are listed in phone view, but when I choose one of them I get the text "invalid" printed in red next to the textbox. I have to open the customer in admin view, click on change and save them so I don´t get the error. I also filled the table "customerpreferences" with data (password encrypted of course - copied from a testuser), but it still doesn´t work. What do I have to change so that otrs thinks the user has been created by otrs? btw: An automatic import from e.g. textfiles would be a nice feature. Lars _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/