RE: [Ruqueue-devel] bulk add users?

[Montana Quiring]

Thanks for all the info.
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.
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? 
Would it be better just to alter lookup_name.php's searching or add another
require_once to lookup_name.php?

-Montana Quiring


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