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:[email protected]] En nombre de Santiago DIEZ Enviado el: miércoles, 19 de julio de 2017 13:22 Para: OTRS LIST <[email protected]> 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 ( '[email protected]' , '[email protected]' , 'XXXX' , '' , 'Turlututu' , 'CHAPEAU' , '' , '' , '' , '' , '' , '' , '' , '' , 1 , NOW() , 2 , NOW() , 2 ); INSERT INTO customer_preferences (user_id , preferences_key , preferences_value) VALUES ('[email protected]', 'UserGoogleAuthenticatorSecretKey', '' ) , ('[email protected]', 'UserLanguage' , 'fr' ) , ('[email protected]', 'UserRefreshTime' , '0' ) , ('[email protected]', '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 --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
