It works, thanks! ------------------------- Santiago DIEZ Quark Systems & CAOBA 23 rue du Buisson Saint-Louis, 75010 Paris ------------------------- On Wed, Jul 19, 2017 at 1:29 PM, Jaroslav Balaz wrote:

Hi,

Did you tried to delete the cache?

bin/otrs.Console.pl Maint::Cache::Delete.

BR,

Jaroslav

On 7/19/17 13:21, Santiago DIEZ wrote:

...

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

Hi, As a rule do not update / insert into the OTRS database directly. If you do, test on a backup first and once done you must clear the cache otherwise you will not see the change immediately on the front end. There are a number of admin functions that can be done via the built in otrs.Console.pl script. A full list of admin operations can be found by running the script with the help parameter. If you need to insert a large number of users or customer then use a csv in conjunction with the script and use Excel to create the necessary repetitive data to speed things up. Regards, Mark Roddis The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from any computer. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. The sender therefore is in no way liable for any errors or omissions in the content of this message which may arise as a result of email transmission. If verification is required, please request a hard copy. We take reasonable precautions to ensure our emails are free from viruses. You need, however, to verify that this email and any attachments are free of viruses, as we can take no responsibility for any computer viruses, which might be transferred by way of this email. We may monitor all email communication through our networks. If you contact us by email, we may store your name and address to facilitate communication. -----Original Message----- From: otrs [mailto:otrs-bounces@lists.otrs.org] On Behalf Of Juan Manuel Clavero Almirón Sent: 19 July 2017 13:30 To: User questions and discussions about OTRS. Subject: Re: [otrs] INSERT INTO customer_user 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 --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs ScannedByWebsenseForEurofins