[LON-CAPA-admin] Searching / listing users

[Stuart Peter Raeburn]

Jeff, 

LON-CAPA currently lacks a web-based user interface for the Domain 
Coordinator to retrieve the data you seek.  Existing interfaces for the 
display of user information are available on a course specific basis in 
ENRL. 

LON-CAPA does include a single .db file (ids.db) that will provide speedy 
access to usernames and student IDs for users in a given domain.  From the 
command line on the library server a system administrator can rapidly 
determine the total number of user accounts in their domain by using: 

/root/loncapa-2.0.1/loncom/debugging_tools/dump_db.pl -u 
/home/httpd/lonUsers/msu/ids.db |wc -l 

(all on one line, and replacing msu with the appropriate domain name if you 
are in another domain, e.g., vcu). 

It would not be difficult to add a web interface to allow querying and 
reporting from this .db file.  Searching by lastname would be less 
efficient, but a brute force method could be devised to provide this (or a 
.db file could be created containing username=lastname pairs). Gathering of 
all information from all the environment.db files and roles.db files for all 
the users could also occur, to allow sorting by role etc. 

I'll most likely be writing scripts to carry out these tasks during the next 
week. 

Stuart 

Stuart Raeburn
MSU LON-CAPA development/support
Div. Science & Math Education
Michigan State University
East Lansing MI 48824 

Jeff Nugent writes: 

> I am looking for a way to do the following in LON-CAPA: 
> 
> 1) Generate a list of users by role (ideally for all currently enrolled 
> students) that contains username, first / last name, etc. This would also 
> be helpful to gain a sense of the total number of student users we have 
> enrolled in our system....I'm unaware of how to access this information as 
> domain coordinator. 
> 
> 2) Ability to search for a user by last name as opposed to username. 
> 
> Thanks in advance for replies. 
> 
> ~Jeff 
> 
>  
> 
> Jeffrey S. Nugent
> Center for Teaching Excellence
> Virginia Commonwealth University
> James Branch Cabell Library
> 901 Park Avenue, 4th Floor
> Richmond, VA 23284
> Ph (804) 827-0563; Fax (804) 827-0837
> http://www.vcu.edu/cte