> -----Original Message----- > From: [EMAIL PROTECTED] On Behalf Of Mat W > Sent: Wednesday, November 15, 2006 10:06 AM > To: rt-users@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) _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
