this is an example i did<br><br>[as10g@aspccs11 ~/bin]$ cat rt-adduser.pl<br>#!/opt/perl/bin/perl<br>use lib "$ENV{'RTHOME'}/lib";<br>use strict;<br>use RT::Interface::CLI qw(CleanEnv);<br>use RT::User;<br>
<br>RT::LoadConfig();<br>RT::Init();<br><br>my $user = RT::User->new($RT::SystemUser);<br>my ($id) = $user->Create(<br> Name => 'eliezere.chavez',<br> EmailAddress => '<a href="mailto:eliezere.chavez@movilnet.com.ve">eliezere.chavez@movilnet.com.ve</a>',<br>
RealName => 'Eliezer Eframn Chavez',<br> NickName => 'echave01',<br> Privileged => 1,<br> Password => 'secret',<br> Address1 => 'Av. Venezuela, C.C. El Recreo, Torre Sur, Piso 2',<br>
Address2 => 'Bello Monte',<br> City => 'Caracas',<br> State => 'Distrito Capital',<br> Zip => '1050',<br> Country => 'Venezuela',<br>
WorkPhone => '+58-212-7056470',<br> MobilePhone => '+58-416-6125676',<br>);<br>print 'User id: $id';<br><br><br><div class="gmail_quote">On Wed, Jan 14, 2009 at 12:21 AM, vamsi krishna <span dir="ltr"><<a href="mailto:vkpolisetty@gmail.com">vkpolisetty@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">thanks for the solution, where i need to run this script? is there any possibility to insert through mysql?<div>
<div></div><div class="Wj3C7c"><br><br><br><br><div class="gmail_quote">On Wed, Jan 14, 2009 at 1:08 AM, Eliezer E Chávez <span dir="ltr"><<a href="mailto:eliezer.chavez@gmail.com" target="_blank">eliezer.chavez@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Jesse Vincent</b> <span dir="ltr"><<a href="mailto:jesse@bestpractical.com" target="_blank">jesse@bestpractical.com</a>></span><br>
Date: Tue, Jan 13, 2009 at 2:53 PM<br>Subject: Re: [rt-users] how to add bulk users in RT3.8.1<br>To: Eliezer E Chhhvez <<a href="mailto:eliezer.chavez@gmail.com" target="_blank">eliezer.chavez@gmail.com</a>><br>Cc: Jesse Vincent <<a href="mailto:jesse@bestpractical.com" target="_blank">jesse@bestpractical.com</a>><br>
<br><br>(can you please send this to rt-users, rather than directly to me? For<br>
personal stuff, I need to run it through our sales team)<br>
<div><div></div><div><br>
<br>
On Tue, Jan 13, 2009 at 02:39:56PM -0430, Eliezer E Chhhvez wrote:<br>
> where and how i have to run this snippet?<br>
><br>
> my $user = RT::User->new($RT::SystemUser);<br>
> my ($id) = $user->Create(<br>
> Name => 'my_user_login',<br>
> Password => 'secret',<br>
> RealName => 'Jhon Smith',<br>
> EmailAddress => '<a href="mailto:jhon.smith@example.com" target="_blank">jhon.smith@example.com</a>',<br>
> Privileged => 0,<br>
> );<br>
><br>
> best regards jesse!<br>
><br>
> On Tue, Jan 13, 2009 at 10:22 AM, Jesse Vincent <<a href="mailto:jesse@bestpractical.com" target="_blank">jesse@bestpractical.com</a>>wrote:<div><div></div><div><br>
><br>
> ><br>
> ><br>
> ><br>
> > On Tue, Jan 13, 2009 at 08:18:14PM +0530, vamsi krishna wrote:<br>
> > > Hi,<br>
> > ><br>
> > > I have written script to insert Users table in rt3 database. i can see<br>
> > users<br>
> > > in the rt3:Users table. I am not able to find the name in<br>
> > RT::Webinterface.<br>
> > > what could be the problem?<br>
> ><br>
> > Did you use the RT API or did you do direct SQL inserts? If you did<br>
> > direct SQL inserts, throw out your database and start over using the<br>
> > user creation snippet from<br>
> ><br>
> > <a href="http://wiki.bestpractical.com/view/CodeSnippets" target="_blank">http://wiki.bestpractical.com/view/CodeSnippets</a><br>
> ><br>
> > as a template<br>
> ><br>
> ><br>
> > ><br>
> > > In web interface i am able to select the<br>
> > > Let this user access RT<br>
> > > Let this user be granted rights<br>
> > ><br>
> > > But in mysql i am not able to find the column to select the above<br>
> > feature.<br>
> > ><br>
> > > can any body help me in adding bulk users to Request tracker 3.8.1?<br>
> > ><br>
> > > --<br>
> > > P Vamsi Krishna<br>
> > > Unix Administrator<br>
> > > Ikanos Communications (India) Pvt.Ltd.<br>
> > > Hyderabad.<br>
> > > mobile:+919949024094<br>
> ><br>
> > > _______________________________________________<br>
> > > <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
> > ><br>
> > > Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
> > > Commercial support: <a href="mailto:sales@bestpractical.com" target="_blank">sales@bestpractical.com</a><br>
> > ><br>
> > ><br>
> > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
> > > Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br>
> ><br>
> > --<br>
> > _______________________________________________<br>
> > <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
> ><br>
> > Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
> > Commercial support: <a href="mailto:sales@bestpractical.com" target="_blank">sales@bestpractical.com</a><br>
> ><br>
> ><br>
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
> > Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br>
> ><br>
><br>
><br>
><br>
> --<br></div></div>
> Eliezer E Chávez<br>
> +58-416-6125676<br>
> <a href="mailto:eliezer.chavez@gmail.com" target="_blank">eliezer.chavez@gmail.com</a><br>
> >><a href="http://www.bumeran.com.ve/cv/eliezer-chavez" target="_blank">http://www.bumeran.com.ve/cv/eliezer-chavez</a><br>
<br>
</div></div>--<br>
</div><br><br clear="all"><br>-- <br>Eliezer E Chávez<br>+58-416-6125676<br><a href="mailto:eliezer.chavez@gmail.com" target="_blank">eliezer.chavez@gmail.com</a><br>>><a href="http://www.bumeran.com.ve/cv/eliezer-chavez" target="_blank">http://www.bumeran.com.ve/cv/eliezer-chavez</a><br>
<br>_______________________________________________<br>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>
Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
Commercial support: <a href="mailto:sales@bestpractical.com" target="_blank">sales@bestpractical.com</a><br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br></blockquote></div><br><br clear="all"><br>-- <br>P Vamsi Krishna<br>Unix Administrator<br>Ikanos Communications (India) Pvt.Ltd.<br>
Hyderabad.<br>mobile:+919949024094<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Eliezer E Chávez<br>+58-416-6125676<br><a href="mailto:eliezer.chavez@gmail.com">eliezer.chavez@gmail.com</a><br>>><a href="http://www.bumeran.com.ve/cv/eliezer-chavez">http://www.bumeran.com.ve/cv/eliezer-chavez</a><br>