He Nils I saw your name in this file syncuser_csv2otrs.pl it might be coincidence, but do you know how to get this file to work for customer users and not just agents? This will be a great help if anyone knows how. <snip> #!/usr/bin/perl -w # -- # syncuser_csv2otrs.pl - sync csv user list or otrs # Copyright (C) 2001-2006 OTRS GmbH, http://otrs.org/ # -- # $Id: syncuser_csv2otrs.pl,v 1.2 2006/10/03 14:34:47 mh Exp $ # -- # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA # -- # example of csv file (0;1;2;...) # [...] # me1;me1@example.com;Nils;Example;somepass;Mr.; # [...] </snip>
Maurice James Ny wrote:
He Nils I saw your name in this file syncuser_csv2otrs.pl it might be coincidence, but do you know how to get this file to work for customer users and not just agents? This will be a great help if anyone knows how.
I have nothing to do with this file AFAIK. :o) Nils Breunese.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb:
He Nils I saw your name in this file syncuser_csv2otrs.pl it might be coincidence, but do you know how to get this file to work for customer users and not just agents? This will be a great help if anyone knows how.
maybe this is of help for you... http://www.cape-it.de/download/synccustomeruser_csv2otrs.pl.gz ...any feedback is welcome. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHZorzvXo8m5PgoXQRAumFAJ49Wo7Nut4xCT0ghsBLSDTGi5D/1ACfdw8O o93vTs6lOznTB//mFJN+jRI= =HjO2 -----END PGP SIGNATURE-----
This is great. You are the man. Are you going to add this to the cvs for inclusion in the next update? -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Torsten Thau Sent: Monday, December 17, 2007 9:43 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Nils ------->syncuser_csv2otrs.pl -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb:
He Nils I saw your name in this file syncuser_csv2otrs.pl it might be coincidence, but do you know how to get this file to work for customer users and not just agents? This will be a great help if anyone knows how.
maybe this is of help for you... http://www.cape-it.de/download/synccustomeruser_csv2otrs.pl.gz ...any feedback is welcome. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHZorzvXo8m5PgoXQRAumFAJ49Wo7Nut4xCT0ghsBLSDTGi5D/1ACfdw8O o93vTs6lOznTB//mFJN+jRI= =HjO2 -----END PGP SIGNATURE----- _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
Your system is very nice. Can you sum up what you have done different from the original install? What have you added? -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Torsten Thau Sent: Monday, December 17, 2007 9:43 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Nils ------->syncuser_csv2otrs.pl -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb:
He Nils I saw your name in this file syncuser_csv2otrs.pl it might be coincidence, but do you know how to get this file to work for customer users and not just agents? This will be a great help if anyone knows how.
maybe this is of help for you... http://www.cape-it.de/download/synccustomeruser_csv2otrs.pl.gz ...any feedback is welcome. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHZorzvXo8m5PgoXQRAumFAJ49Wo7Nut4xCT0ghsBLSDTGi5D/1ACfdw8O o93vTs6lOznTB//mFJN+jRI= =HjO2 -----END PGP SIGNATURE----- _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb:
Your system is very nice. Can you sum up what you have done different from the original install? What have you added?
...thanks a lot. Unfortunately, it's not that easy. Since we haven't changed only the layout but also added and modified some core functionalities the list of files is quite long - approximately 120 files, including the layout. Furthermore it's currently based on 2.1.7 as you may have noticed. But we're currently thinking about releasing these changes as an opm-package in spring 2008. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHZ3KFvXo8m5PgoXQRAg06AJ9FNdE9V1Q9MVGHheVBJi+ngAFLgACfbDPx udkybYrXGXylJc7XoznLjhM= =7WkD -----END PGP SIGNATURE-----
This file still should work on 2.2.x right? -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Torsten Thau Sent: Tuesday, December 18, 2007 2:11 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Nils ------->syncuser_csv2otrs.pl -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb:
Your system is very nice. Can you sum up what you have done different from the original install? What have you added?
...thanks a lot. Unfortunately, it's not that easy. Since we haven't changed only the layout but also added and modified some core functionalities the list of files is quite long - approximately 120 files, including the layout. Furthermore it's currently based on 2.1.7 as you may have noticed. But we're currently thinking about releasing these changes as an opm-package in spring 2008. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHZ3KFvXo8m5PgoXQRAg06AJ9FNdE9V1Q9MVGHheVBJi+ngAFLgACfbDPx udkybYrXGXylJc7XoznLjhM= =7WkD -----END PGP SIGNATURE----- _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
What kind of modifications did you make to this file? Its giving me errors. Do you think that you will be able to strip your extra mods out and just leave to where it updates the customer database? -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Torsten Thau Sent: Monday, December 17, 2007 9:43 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Nils ------->syncuser_csv2otrs.pl -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb:
He Nils I saw your name in this file syncuser_csv2otrs.pl it might be coincidence, but do you know how to get this file to work for customer users and not just agents? This will be a great help if anyone knows how.
maybe this is of help for you... http://www.cape-it.de/download/synccustomeruser_csv2otrs.pl.gz ...any feedback is welcome. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHZorzvXo8m5PgoXQRAumFAJ49Wo7Nut4xCT0ghsBLSDTGi5D/1ACfdw8O o93vTs6lOznTB//mFJN+jRI= =HjO2 -----END PGP SIGNATURE----- _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Maurice James Ny schrieb:
What kind of modifications did you make to this file? Its giving me errors. Do you think that you will be able to strip your extra mods out and just leave to where it updates the customer database?
(1) What errors do you get exactly ? (2) Of course you probably need to do some modifications, for your customer attributes: First: you have to define the colum index for the customer user attributes, which are available in your cvs (lines 28 and following). Second: uncomment/add/modify lines which contain attributes that you do(n't) need or which are named differently in your customer mapping in the following statements: $CommonObject{CustomerUserObject}->CustomerUserUpdate( ...and... $CustomerUserData{UserID} = $CommonObject{CustomerUserObject}->CustomerUserAdd( ...maybe I forgot to mention that this script is very simple and works only with one customer user data backend. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHaRgMvXo8m5PgoXQRAvQzAJ44VAGP6hFKsGe+xb6VYVQHQ+lYMACePgTa l+rMl7EoEAnLqnT57FNf0eY= =hbxr -----END PGP SIGNATURE-----
I will try to get that error to you tomorrow. I haven't made any modifications to my database so the default script (syncuser_csv2otrs.pl) to add agents work fine. We have about 5000 users and I currently have only about 300 in the system by way of hand jamming each one at a time. The only reason I don't use LDAP is because we use PKI to for authentication and I have no idea how to implement this. If I can get your script to work just like syncuser_csv2otrs.pl does out of the box it will save me about 10 more grey hairs. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Torsten Thau Sent: Wednesday, December 19, 2007 8:10 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Nils ------->syncuser_csv2otrs.pl -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Maurice James Ny schrieb:
What kind of modifications did you make to this file? Its giving me errors. Do you think that you will be able to strip your extra mods out and just leave to where it updates the customer database?
(1) What errors do you get exactly ? (2) Of course you probably need to do some modifications, for your customer attributes: First: you have to define the colum index for the customer user attributes, which are available in your cvs (lines 28 and following). Second: uncomment/add/modify lines which contain attributes that you do(n't) need or which are named differently in your customer mapping in the following statements: $CommonObject{CustomerUserObject}->CustomerUserUpdate( ...and... $CustomerUserData{UserID} = $CommonObject{CustomerUserObject}->CustomerUserAdd( ...maybe I forgot to mention that this script is very simple and works only with one customer user data backend. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHaRgMvXo8m5PgoXQRAvQzAJ44VAGP6hFKsGe+xb6VYVQHQ+lYMACePgTa l+rMl7EoEAnLqnT57FNf0eY= =hbxr -----END PGP SIGNATURE----- _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Maurice James Ny schrieb:
I will try to get that error to you tomorrow. I haven't made any
...it'd be helpful if you added your customer mapping/configuration as well.
modifications to my database so the default script (syncuser_csv2otrs.pl) to add agents work fine. We have about 5000 users and I currently have only about 300 in the system by way of hand jamming each one at a time. The only reason I don't use LDAP is because we use PKI to for authentication and I have no idea how to implement this. If I can get your script to work just like syncuser_csv2otrs.pl does out of the box it will save me about 10 more grey hairs.
...it did the same to me :). regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHa592vXo8m5PgoXQRAhp+AJ9JQnwl9mjooEfF6d4ibHjCHelsOACeL2+k BHnaBytSxhPCLlH53Ly4+YI= =RUwn -----END PGP SIGNATURE-----
participants (3)
-
Maurice James Ny -
Nils Breunese (Lemonbit) -
Torsten Thau