[rt-users] Re: Multiple User Add

[Mike Husband]

I don't see any RT tool or module that you could use to bulk add users.

Also, from my inspection of the RT schema, I think you would need to be
very careful if you add users directly using sql.

You would need to add your groups first to the Groups and Principals tables.
Then you could add your users to the Users and Principals tables.
Next add your user/group mapping to the GroupMembers table.
You may also have to add something to the CachedGroupMembers table,
but I haven't seen enough to know what needs to be done here.

My inclination would be to do only the first 2 steps in sql
and then go into RT to set up the group mappings.

But then, I'm also a novice.  Others might have better ideas.


> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of
> Asif Iqbal
> Sent: Friday, 23 January 2004 3:36 PM
> To: rt-users at lists.fsck.com
> Subject: [rt-users] Re: Multiple User Add
>
>
> Hi All
>
> I think I should use RT instead of mysql to do this. Waiting
> to find out what
> anyone else might have think about this issue
>
> Thanks
>
>
> On Mon, 19 Jan 2004, Asif Iqbal wrote:
>
> > Date: Mon, 19 Jan 2004 11:12:48 -0500 (EST)
> > From: Asif Iqbal <iqbala at qwestip.net>
> > To: rt-users at lists.fsck.com
> > Subject: Multiple User Add
> >
> > -----pgpenvelope processed message
> >
> > Hi All
> >
> > I have been using RT 3.0.5 with Apache+mod_perl and
> mysql-4.0.13. I just make
> > sure it all works together. I am still learning the tools.
> I was wondering if
> > anyone has done any script to bulk add users to RT and add
> them to a specific
> > group.
> >
> >
> > Any help/suggestion/direction would be greatly appreciated
> >
> > Thanks
> >
> > --
> > Asif Iqbal
> > PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
> > There's no place like 127.0.0.1
> >
> > -----pgpenvelope information
> > Hash: SHA1
> > Version: GnuPG v1.2.1 (SunOS)
> > Comment: pgpenvelope 2.10.2 - http://pgpenvelope.sourceforge.net/
> >
> > gpg: Signature made Mon Jan 19 11:12:51 2004 EST using DSA
> key ID E62693C5
> > gpg: Good signature from "Asif Iqbal (Engineering)
> <iqbala at qwestip.net>"
> >
> > pgpenvelope_decrypt: message processed at Fri Jan 23 00:33:15 2004
> >
> > -----end pgpenvelope information
> >
>
> --
> Asif Iqbal
> PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
> There's no place like 127.0.0.1
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm