[rt-users] importing users question...

[Mat W]

essentially, just want to pre-load user's name, email, office, and phone# 
from a basic CSV.  part2 would be to populate a few custom fields for the 
users.

i see the method in the User.pm to create a new user and this was the info 
on the 
wiki:(http://download.bestpractical.com/pub//rt/contrib/3.0/Other/rtadduser) 
...

did a login and let RT create an account for the requestor, I see it added 
info to the Group and GroupMember table.  and i see entries for each user i 
created for the IT staff...

| 106 | User 105 | ACL equiv. for user 105          | ACLEquivalence  | 
UserEquiv    |      105 |
| 107 | NULL     | NULL                             | RT::Ticket-Role | 
Requestor    |       15 |
| 108 | NULL     | NULL                             | RT::Ticket-Role | 
Owner        |       15 |
| 109 | NULL     | NULL                             | RT::Ticket-Role | Cc   
         |       15 |
| 110 | NULL     | NULL                             | RT::Ticket-Role | 
AdminCc      |       15 |


>
> > -----Original Message-----
> > From: rt-users-bounces at lists.bestpractical.com On Behalf Of Mat W
> > Sent: Wednesday, November 15, 2006 10:06 AM
> > To: rt-users at lists.bestpractical.com
> > Subject: [rt-users] importing users question...
> >
> > I'm using RT3.4.0
> >
> > I've read through some of the posts and the wiki.  Everyone
> > seems to think
> > it's possible including myself and honestly, doesn't seem
> > that hard to do...
> > however I've yet to see someone say, "yes, i imported 100
> > users with <blah>
> > technique/script, etc".  The script on the wiki shows how to
> > create a user,
> > but i don't see how it updates the Group tables.
> >
> > I was looking around in the DB.  I see it creates the entries
> > in the Users,
> > Groups, and GroupMembers.  I believe I could create one
> > "example" user and
> > see what changes in the DB and script it myself to
> > essentially "clone" the
> > user 100 more times.  I'm just hoping someone may have
> > already created a
> > "clone" script or can point out things like "don't forget
> > about updating
> > <blah>".
> >
> > I'm no super-DBA or programmer, but i can muddle my way
> > through it.  Just
> > need a shove in the right direction.  Perhaps what function
> > is called when
> > RT auto-creates the users who emailed tickets in?
> >
> > thanks in advance.
> >
> > -MatW
> >
>
>Hello Mat,
>
>Could you explain a bit more about what you actually want to do? It sounds
>like you just want a script that will create users based on some external
>information, but I'm not sure why you are wondering about updating the
>Groups table. What code from the wiki are you referring to?
>
>One piece of advice - don't try to figure out what database tables RT
>updates and reverse-engineer that. The API exists so that you don't need to
>do that and so that you can create all the right records without hosing 
>your
>database.
>
>We have a script that loads and updates user info every night from an
>external source, so if that's what you are after, it's definitely doable.
>
>Good luck,
>Steve
>
>----------------------------------------
>Stephen Turner
>Senior Programmer/Analyst - Client Support Services
>MIT Information Services and Technology (IS&T)
>
>

_________________________________________________________________
Stay in touch with old friends and meet new ones with Windows Live Spaces 
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us