Upload users into RT

Hi all -

I’ve searched around and can’t seem to find a streamlined way of uploading
users into RT. Perhaps it doesn’t exist? We are running 3.8.7.

Basically, I’m looking for information on how to be able to create (or
upload) all of our student population in RT and give them access to the
SelfService portal.

Not sure if this is possible through direct interaction with the database
with ODBC, or if there is a handy script or not.

Any info is appreciated!

Oh, and does anybody know where in the database structure it tells RT if the
user goes to SelfService or not? I can’t seem to find that either…
Max McGrath
Asst. Network Admin/Systems Specialist
Carthage College
262-552-5512
mmcgrath@carthage.edu

Hi all -
I’ve searched around and can’t seem to find a streamlined way of uploading
users into RT. Perhaps it doesn’t exist? We are running 3.8.7.
Basically, I’m looking for information on how to be able to create (or
upload) all of our student population in RT and give them access to the
SelfService portal.
Not sure if this is possible through direct interaction with the database
with ODBC, or if there is a handy script or not.
Any info is appreciated!

  1. ExternalAuth to LDAP
  2. script the rt command line + a parseable copy of your data
  3. See my scrip on the wiki for VCF, and turn your data into VCFs that
    are the body of individual tickets injected with the Offline edit
    tool.

We use #3, with a tool that takes a CSV and spits out the form for
Offline edit, but we’re processing few records at a time for unknown
users. You would seem to have a large number of known users, so
ExternalAuth is probably the better choice.

Oh, and does anybody know where in the database structure it tells RT if the
user goes to SelfService or not? I can’t seem to find that either…
Whether or not the user is privileged, wiki is your friend:
SelfService - Request Tracker Wiki