Re: [otrs] importing customer users from a csv file
ciao Marco,
The problem with a trial that I made is with the password of the user created... (could be solved with the Lost your password? from the customer.pl ?)
In my environment there is no password problem. I can temporarily set a default password and I can instruct the customer to change the password on first login.
insert into customer_user (login,email,customer_id,first_name,last_name,valid_id,create_time,create_by,change_time,change_by) values ('prova', 'prova@prova.it', 'prova', 'p', 'p', 1, sysdate(), 1, sysdate(), 1)
I did a test to try to understand what database modifications are made when I add a customer user. I found modifications in two tables: customer_users -> one row customer_preferences -> many rows Doing an insert like you propose is enough? Or I also have to insert entries on the customer_preferences table? Thanks, Alessandro Cortiana
I've seen that customer_preferences has been fullfilled at the first "prova" login it seems... otherwise, in that table are stored (as the name suggests) preferences for the customer. Having not modified nothing on prova, records for him are: | prova | UserLoginFailed | 0 | | prova | UserShowTickets | 25 | | prova | UserRefreshTime | | | prova | UserLanguage | en | | prova | UserShowClosedTickets | 1 | | prova | UserTheme | Standard | | prova | UserToken | CISmoxkPZzkpvb7 | | prova | UserAuthBackend | | | prova | UserLastLogin | 1267008164 | On Wed, Feb 24, 2010 at 2:40 PM, Alessandro Cortiana < alessandro.cortiana@inetworking.it> wrote:
ciao Marco,
The problem with a trial that I made is with the password of the user created... (could be solved with the Lost your password? from the customer.pl ?)
In my environment there is no password problem. I can temporarily set a default password and I can instruct the customer to change the password on first login.
insert into customer_user
(login,email,customer_id,first_name,last_name,valid_id,create_time,create_by,change_time,change_by)
values ('prova', 'prova@prova.it', 'prova', 'p', 'p', 1, sysdate(), 1, sysdate(), 1)
I did a test to try to understand what database modifications are made when I add a customer user. I found modifications in two tables: customer_users -> one row customer_preferences -> many rows
Doing an insert like you propose is enough? Or I also have to insert entries on the customer_preferences table?
Thanks, Alessandro Cortiana --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
participants (2)
-
Alessandro Cortiana -
Marco Vannini