Hi, Great. I'm using the script bin/otrs.Console.pl Admin::CustomerUser::Add
Thx for your help ------------------------- Santiago DIEZ Quark Systems & CAOBA 23 rue du Buisson Saint-Louis, 75010 Paris ------------------------- On Wed, Jul 19, 2017 at 2:40 PM, Mark Roddis <[email protected]> wrote: > 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:[email protected]] 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:[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 > > > ScannedByWebsenseForEurofins > --------------------------------------------------------------------- > 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
