INSERT INTO customer_user

Santiago DIEZ <[email protected]>
Newsgroups gmane.comp.otrs.user
Message-ID <CAJh8RqUigTb0Q996Dja02Li_ue51DoBD6EPG0X17yX1dP8+qpA@mail.gmail.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.