[rt-users] importing users question...

[Stephen Turner]

> -----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)