[rt-users] Fwd: how to add bulk users in RT3.8.1

Eliezer E Chávez eliezer.chavez at gmail.com
Wed Jan 14 13:22:09 EST 2009


this is an example i did

[as10g at aspccs11 ~/bin]$ cat rt-adduser.pl
#!/opt/perl/bin/perl
use lib "$ENV{'RTHOME'}/lib";
use strict;
use RT::Interface::CLI qw(CleanEnv);
use RT::User;

RT::LoadConfig();
RT::Init();

my $user = RT::User->new($RT::SystemUser);
my ($id) = $user->Create(
    Name         => 'eliezere.chavez',
    EmailAddress => 'eliezere.chavez at movilnet.com.ve',
    RealName     => 'Eliezer Eframn Chavez',
    NickName     => 'echave01',
    Privileged   => 1,
    Password     => 'secret',
    Address1     => 'Av. Venezuela, C.C. El Recreo, Torre Sur, Piso 2',
    Address2     => 'Bello Monte',
    City         => 'Caracas',
    State        => 'Distrito Capital',
    Zip          => '1050',
    Country      => 'Venezuela',
    WorkPhone    => '+58-212-7056470',
    MobilePhone  => '+58-416-6125676',
);
print 'User id: $id';


On Wed, Jan 14, 2009 at 12:21 AM, vamsi krishna <vkpolisetty at gmail.com>wrote:

> thanks for the solution, where i need to run this script? is there any
> possibility to insert through mysql?
>
>
>
>
> On Wed, Jan 14, 2009 at 1:08 AM, Eliezer E Chávez <
> eliezer.chavez at gmail.com> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: Jesse Vincent <jesse at bestpractical.com>
>> Date: Tue, Jan 13, 2009 at 2:53 PM
>> Subject: Re: [rt-users] how to add bulk users in RT3.8.1
>> To: Eliezer E Chhhvez <eliezer.chavez at gmail.com>
>> Cc: Jesse Vincent <jesse at bestpractical.com>
>>
>>
>> (can you please send this to rt-users, rather than directly to me? For
>> personal stuff, I need to run it through our sales team)
>>
>>
>> On Tue, Jan 13, 2009 at 02:39:56PM -0430, Eliezer E Chhhvez wrote:
>> > where and how i have to run this snippet?
>> >
>> > my $user = RT::User->new($RT::SystemUser);
>> > my ($id) = $user->Create(
>> >     Name         => 'my_user_login',
>> >     Password     => 'secret',
>> >     RealName     => 'Jhon Smith',
>> >     EmailAddress => 'jhon.smith at example.com',
>> >     Privileged   => 0,
>> > );
>> >
>> > best regards jesse!
>> >
>> > On Tue, Jan 13, 2009 at 10:22 AM, Jesse Vincent <
>> jesse at bestpractical.com>wrote:
>>
>> >
>> > >
>> > >
>> > >
>> > > On Tue, Jan 13, 2009 at 08:18:14PM +0530, vamsi krishna wrote:
>> > > > Hi,
>> > > >
>> > > > I have written script to insert Users table in rt3 database. i can
>> see
>> > > users
>> > > > in the rt3:Users table. I am not able to find the name in
>> > > RT::Webinterface.
>> > > > what could be the problem?
>> > >
>> > > Did you use the RT API or did you do direct SQL inserts? If you did
>> > > direct SQL inserts, throw out your database and start over using the
>> > > user creation snippet from
>> > >
>> > > http://wiki.bestpractical.com/view/CodeSnippets
>> > >
>> > > as a template
>> > >
>> > >
>> > > >
>> > > > In web interface i am able to select the
>> > > > Let this user access RT
>> > > >  Let this user be granted rights
>> > > >
>> > > > But in mysql i am not able to find the column to select the above
>> > > feature.
>> > > >
>> > > > can any body help me in adding bulk users to Request tracker 3.8.1?
>> > > >
>> > > > --
>> > > > P Vamsi Krishna
>> > > > Unix Administrator
>> > > > Ikanos Communications (India) Pvt.Ltd.
>> > > > Hyderabad.
>> > > > mobile:+919949024094
>> > >
>> > > > _______________________________________________
>> > > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>> > > >
>> > > > Community help: http://wiki.bestpractical.com
>> > > > Commercial support: sales at bestpractical.com
>> > > >
>> > > >
>> > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> > > > Buy a copy at http://rtbook.bestpractical.com
>> > >
>> > > --
>> > > _______________________________________________
>> > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>> > >
>> > > Community help: http://wiki.bestpractical.com
>> > > Commercial support: sales at bestpractical.com
>> > >
>> > >
>> > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> > > Buy a copy at http://rtbook.bestpractical.com
>> > >
>> >
>> >
>> >
>> > --
>> > Eliezer E Chávez
>> > +58-416-6125676
>> > eliezer.chavez at gmail.com
>> > >>http://www.bumeran.com.ve/cv/eliezer-chavez
>>
>> --
>>
>>
>>
>> --
>> Eliezer E Chávez
>> +58-416-6125676
>> eliezer.chavez at gmail.com
>> >>http://www.bumeran.com.ve/cv/eliezer-chavez
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
>
>
>
> --
> P Vamsi Krishna
> Unix Administrator
> Ikanos Communications (India) Pvt.Ltd.
> Hyderabad.
> mobile:+919949024094
>



-- 
Eliezer E Chávez
+58-416-6125676
eliezer.chavez at gmail.com
>>http://www.bumeran.com.ve/cv/eliezer-chavez
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090114/cbefa242/attachment.htm>


More information about the rt-users mailing list