Hi,
Answering to
Is there a better way to programmatically insert customer_user?
I'd prefer writing a script that uses OTRS System modules. You can take a look at the scripts in scripts/test/ to get an idea.
Kind regards,
Juan Clavero
-----Mensaje original-----
De: otrs [mailto:otrs-bounces@lists.otrs.org] En nombre de Santiago DIEZ
Enviado el: miércoles, 19 de julio de 2017 13:22
Para: OTRS LIST
Asunto: [otrs] INSERT INTO customer_user
Hi all,
I installed otrs-5.0.20 from source 10 days ago and it works fine.
Today I tried to add customer_user directly into the MySQL backend with:
INSERT INTO customer_user (
login
, email
, customer_id
, title
, first_name
, last_name
, phone
, fax
, mobile
, street
, zip
, city
, country
, comments
, valid_id
, create_time
, create_by
, change_time
, change_by
)
VALUES (
'turlututu@chapeau.tu'
, 'turlututu@chapeau.tu'
, 'XXXX'
, ''
, 'Turlututu'
, 'CHAPEAU'
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, 1
, NOW()
, 2
, NOW()
, 2
);
INSERT INTO customer_preferences (user_id , preferences_key
, preferences_value)
VALUES ('turlututu@chapeau.tu',
'UserGoogleAuthenticatorSecretKey', '' )
, ('turlututu@chapeau.tu',
'UserLanguage' , 'fr' )
, ('turlututu@chapeau.tu',
'UserRefreshTime' , '0' )
, ('turlututu@chapeau.tu',
'UserShowTickets' , '25' );
But the new users do not show in
otrs/index.pl?Action=AdminCustomerUser;Nav=Agent
Does anyone knows why?
Is there a better way to programmatically insert customer_user?
Regards
-------------------------
Santiago DIEZ
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
