Thanks, yes that did occur to me; it looks as if it probably just needs entries in the ‘group_customer_user’ table. However my ‘sets’ of users are probably going to be simple flat file lists. Should an equivalent script to ‘otrs.AddUser2Group.pl ‘ exist, I could just edit the list to run the command multiple times, once per customer.
Not as technically exciting as doing it via the DB but a quick and dirty approach would suffice here. Cheers Phil From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Bogdan Iosif Sent: 06 September 2013 14:40 To: User questions and discussions about OTRS. Subject: Re: [otrs] Command-line script for adding Customer users to groups? It would be much simpler to perform this operation via SQL directly on OTRS's database On Fri, Sep 6, 2013 at 4:33 PM, Stanford, Philip N. <p...@noc.ac.uk<mailto:p...@noc.ac.uk>> wrote: Hi, Does anyone have a script for adding Customer users to groups? We have a large number of customers and want to add sub-sets of these to a number of groups. I’ve tried modifying the script otrs.AddUser2Group.pl<http://otrs.AddUser2Group.pl> (which adds Agents to groups) without success – probably not surprisingly since I have only a limited acquaintance with PERL and the OTRS programming model. All I’m after is something that works in a similar manner to the supplied script below, and will add a single customer to a group, with permissions: # ./otrs.AddUser2Group.pl<http://otrs.AddUser2Group.pl> Usage: ./otrs.AddUser2Group.pl<http://otrs.AddUser2Group.pl> -g groupname -u username -p ro|rw Suggestions very welcome. Phil ________________________________ This message (and any attachments) is for the recipient only. NERC is subject to the Freedom of Information Act 2000 and the contents of this email and any reply you make may be disclosed by NERC unless it is exempt from release under the Act. Any material supplied to NERC may be stored in an electronic records management system. --------------------------------------------------------------------- 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 ________________________________ This message (and any attachments) is for the recipient only. NERC is subject to the Freedom of Information Act 2000 and the contents of this email and any reply you make may be disclosed by NERC unless it is exempt from release under the Act. Any material supplied to NERC may be stored in an electronic records management system.
--------------------------------------------------------------------- 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