
I have a CentOS with OTRS installed. I need to import a lot of customer users into the otrs database. These users are stored in a csv file. Is there any way to do this automatically (via script or via the GUI)? If not, what do you suggest? Thanks, Alessandro Cortiana

ciao Alessandro, I think that it could be made by a batch job that makes something like: 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) 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 ?) On Wed, Feb 24, 2010 at 11:02 AM, Alessandro Cortiana < alessandro.cortiana@inetworking.it> wrote:
I have a CentOS with OTRS installed. I need to import a lot of customer users into the otrs database. These users are stored in a csv file. Is there any way to do this automatically (via script or via the GUI)? If not, what do you suggest?
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/

Hi Alessandro,
Cape IT has developed a module that extends the existing Import <>
Export module with the ability to import Customer Users:
http://bugs.otrs.org/show_bug.cgi?id=4697
It's still missing some unit tests so we have not integrated it yet in
the core ImportExport package.
but usually, if you *HAVE* a remote system where you can create the
CSV file from, it's much nicer to use the remote system as a data
source and integrate directly with the remote database.
((enjoy))
-
Michiel Beijen
R&D
OTRS AG
Norsk-Data-Str 1.
61352 Bad Homburg
Germany
T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I: http://www.otrs.com/
Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial
register: 10751, Tax ID: 003 240
97505 Chairman of the Board: Burchard Steinbild, Managing Board: André
Mindermann (CEO), Martin Edenhofer
CU@ CeBIT 2010 in Hannover (Germany) and get to know more about OTRS
at booth no. C37, in hall 2 from March 2-6, 2010! http://bit.ly/7uyQfY
On Wed, Feb 24, 2010 at 11:40 AM, Marco Vannini
ciao Alessandro, I think that it could be made by a batch job that makes something like: 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)
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 ?)
On Wed, Feb 24, 2010 at 11:02 AM, Alessandro Cortiana
wrote: I have a CentOS with OTRS installed. I need to import a lot of customer users into the otrs database. These users are stored in a csv file. Is there any way to do this automatically (via script or via the GUI)? If not, what do you suggest?
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/
--------------------------------------------------------------------- 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 (3)
-
Alessandro Cortiana
-
Marco Vannini
-
Michiel Beijen