>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/
