Hi Rick, I had the same large userbase import issue, and ended up writing a Perl script to process a CSV file into a format that the 'rt' binary[1] could handle, then pass off the commands directly to it. The syntax that 'rt' uses is explained briefly in the binary's help file, but basically 'rt create user Name="" EmailAddress="" RealName=""' is a good place to start.
I guess I should extend the script to allow processing of a CSV/TSV file that is directly posted/piped to it! HTH [1] Located in $RTHOME/bin Regards, Sasha Sasha Gerrand Web & Database Developer Austbrokers Holdings Limited Level 21, 111 Pacific Highway North Sydney NSW 2060 PO Box 1813 North Sydney NSW 2060 Ph: 02 9935 2230 Mobile: 0431 895 718 Email: [EMAIL PROTECTED] Web: http://www.austbrokers.com.au NOTICE If you are not an authorised recipient of this email, please contact Austbrokers Holdings immediately by return e-mail or by telephone on +61-2-4920-6117. In this case, you should not read, print, re-transmit, store or act on this e-mail or any attachments. Please destroy the message and attachments. This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Austbrokers Holdings or third parties. You should only re-transmit, distribute or commercialise the material if you are authorised to do so. Internet e-mails are not necessarily secure, Austbrokers Holdings does not accept responsibility for changes made to this message after it was sent. This Notice should not be removed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips Sent: Saturday, 17 March 2007 3:56 PM To: rt-Users Subject: [rt-users] Bulk Adding Users I have looked hard at the wiki and done extensive searching on the general web but can't seem to find any reference as to how to bulk upload users. In can dump the users directly into the database (I am assuming) but the passwords will need to be encrypted. I have a utility which will bulk encrypt passwords using md5sum. Is this the encryption method for RT? Will I need to update any other table other than RT-users? In our situation, it's a "closed shop" and the potential users are all known. I have been trying to make the MS active directory authentication work but have had to give up on that. I am using (via RPM install on Mandriva) version 3.4.5. Thanks in advance, Rick _______________________________________________ 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 _______________________________________________ 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
