Re: [Ruqueue-devel] bulk add users?

[John Fulton]

Please see my replies below.

Montana Quiring wrote:

> What I'm going to do is use a Perl script that a colleague of mine
> made. It will populate my LDAP tree with the room numbers from a
> flat file and I will just import them locally by searching for them
> as issues come up for each room number. I want the room numbers in
> LDAP anyway so this is my compromise.

If your LDAP tree has an attribute for room numbers you probably want
to alter the user table to store that field.  That way all the fields
(not all the results) of your LDAP search can be stored and associated
with the ticket.

> I was kind of hoping to put all of these in a separate OU so as not
> to mix my staff and residence rooms together.  It should be possible
> to make extensible user lookup search in more than one OU, eh?

I don't see any reason that you can't.  Putting a pull-down on a
lookup page to specify which OU to use wouldn't be too difficult.
However, I assume that you would be using the staff OU for
authentication and the student OU for your users.  If this is the case
then you would modify the file functions-auth-ru-ldap.php to work with
your staff OU.  Then you would modify lookup_name.php to work with
your student OU.  I don't see why you would be looking up your staff
(i.e. the people who are working at your Help Desk) in LDAP for
anything other than authentication.

At Rutgers everyone has a NetID (accompanied by a password) and our
LDAP server provides authentication service for everyone (students,
staff, faculty, etc).  We use ruQueue's staff table to denote a subset
of NetIDs that can login to make tickets.  The same LDAP server also
keeps everyone's contact data.  We do LDAP lookups for anyone (who
might be in the user table) in order to cut down on data entry.

> Would it be better just to alter lookup_name.php's searching or add
> another require_once to lookup_name.php?

lookup_name.php is just a wrapper to get stuff from LDAP into the user
table (as opposed to the staff table).  You could tweak the items it
requires so that they are compatible with your LDAP server.

  John

> -----Original Message-----
> From: John Fulton [mailto:address@hidden
> Sent: Wednesday, September 06, 2006 11:07 AM
> To: Montana Quiring
> Cc: address@hidden
> Subject: Re: [Ruqueue-devel] bulk add users?
>
> Montana,
>
> I think that you're misunderstanding this feature.  Bulk-user add is for
> giving ruQueue accounts to the people you work with, so that they can
> login and make tickets.  It's for your Help Desk staff, not your users.
>
> It sounds like you want to insert a bunch of people into the users
> table, not the staff table.  If you do a 'desc user;' at the MySQL
> prompt you will see the table that you want to insert into.  If you have
> a delimited text file of your users, you could write a script which
> directly imports them into the users table.  You might even want to
> alter the users table to match your file.  Try inserting yourself and
> then looking yourself up (making a ticket for yourself) to see how they
> connect.
>
> I recall that you were looking into LDAP.  The users table basically
> caches data from LDAP.  So, rather than having staff enter all that data
> it's auto populated by an LDAP lookup for the user with the problem.  If
> I were you I'd either get LDAP populating that table or write a script
> to parse your tab-delimited file of 2000 users and insert them into the
> user table.
>
>    John
>
> Montana Quiring wrote:
>> Thanks for the info.
>> I'm running out of free time this week, so I might just wait for your
>> official release.
>>
>> How does the "bulk add users" work? Does it let you pull info from a 
flat
>> file that contains a list of usernames? I would like to add about 2000
> users
>> (bed-spaces in residence) and am hoping this will let me do it easily.
>>
>> -Montana
>>
>>
>> -----Original Message-----
>> From: John Fulton [mailto:address@hidden
>> Sent: Wednesday, September 06, 2006 9:53 AM
>> To: Montana Quiring
>> Cc: address@hidden
>> Subject: Re: [Ruqueue-devel] bulk add users?
>>
>> Montana,
>>
>> It is complete and works for the version of ruQueue in CVS.  You're
>> welcome to check that out if you like.  The latest release (1.2.2 which
>> is a bit old now) does not have it working.  I'm hoping to have a new
>> release soon (perhaps even this week depending on other factors) that
>> will have it working.
>>
>> If you check out a new web-tree from:
>>
>>   https://savannah.nongnu.org/cvs/?group=ruqueue
>>
>> and then run the ALTER statements in DB/ruqueue_mysql_5_upgrade.sql
>> (this is a misnomer you don't need MySQL 5, but it will work with
>> MySQL5) it should work.  Please let me know if it doesn't.  Also, please
>> back up your DB (with a mysqldump) and tar up your web-tree before
>> upgrading just in case.
>>
>>    John
>>
>> Montana Quiring wrote:
>>> Hello,
>>>
>>> I was wondering if the "bulk add users" feature under Config -> 
Users ->
>>> Bulk Add Users
>>> ...is complete and works.
>>> I did some searching but couldn't find any evidence that it does.
>>>
>>> If it does, can someone give me some help getting it to work, please?
>>> When I click it, it gives me an empty box called "Bulk Add Users".
>>>
>>> -Montana Quiring
>>> HSL IT Admin
>>> University of Manitoba
>>> 204.474.8694
>>>
>>> "Live on purpose."
>>>
>>>
>>>
>>> _______________________________________________
>>> Ruqueue-devel mailing list
>>> address@hidden
>>> http://lists.nongnu.org/mailman/listinfo/ruqueue-devel
>

--
John Fulton, Senior Web Designer, Rutgers University
http://www.nbcs.rutgers.edu/      732.445.6950 x6032