Blocks

I preferred doing it by myself as I need it quickly and working on the "old" 1.6 Moodle.
Also, I think that some problems like users with no e-mail are specific of users I'm working with, far from university or school students.

I also suppose that the majority of Moodle administrators consider the current user administration interface as fully satisfactory, as it have few or no changes in the last 3 years.

Ehm... I made a little mess with language files
Here is the correct package, with english files in en_utf8

ok ok... I put a "burst" of feature requests in the tracker.

This is a block that is only viewable from the homepage.

Go to yourMoodles homepage, turn editing on then add the User Administration block.

That should be it.

Hi all,
after an almost complete rewrite of the code, here is the User Administration block version for Moodle 1.8

I tested it in development sites, but I was not able to test it in crowded, production sites, so consider it still a beta version.

Some of the new features:

• User filter by Role in a given Context
• Filter by Authentication mode (manual, ldap, email...)
• Filter Confirmed/Unconfirmed users
• Filter remote MNET users by Peer
• Role assignment/unassignment selecting users from the list
• CSV download of users applying filter conditions
• Role of users in Courses, in CSV file download
• Some UI enhancements

I completely removed Excel file format download, as it caused random problems.

Sorry, but I added no support for Group management

For Moodle 1.6 users, I fixed a couple of bugs and disabled buggy Excel download. No new feature). You can download the new release for 1.6 here.

Lorenzo

Hi Trip,
you say you enter the "Browse list of Users" page and you see "123 on 123 users" (where 123 is exactly the number of users on your site), you see the search/filter form, but the table below is empty?

Some questions to pinpoint the problem:
Do you see the footer ("Add a new User" link...)?
Do you see a "No User matching conditions" message?
Did you try to reset the search pushing the [Clear all search conditions and reload] button, even if you do not enter any search condition?
What database are you using (MySQL/Postgres and what version)?

Lorenzo

Hi all,
Here is a new release of User Administration block for Moodle 1.8

I've fixed some minor bugs, and a major one causing error on PHP4 (or... I hope it is fixed, as I was not able to test on PHP4. Please report me about it).
I've also added search byUsername.

This version may overwrite previous version without problems.

Lorenzo

Hi Michael
the support for hidden role assignment is a good idea.
Unfortunately changes needed are not trivial. I added it to my TODO list

Thanks

Lorenzo

Hi all,
here is a new update of the Useradmin block.

Changes are:

• fixed some minor bugs
• added granularity in capabilities check (see README.txt)
• added hidden roles assignment.

Please download it here, until the Plugin Database entry will re-approved.

Lorenzo

Hi Rafael,
thank you for your contribution. I'll update the block code with your patch

Lorenzo

I'am a little confused because I read line 178 as
// Password is always empty

I do know nearly nothing about PHP, I can only understand PHP when I see how someone solves a problem So in this case I do not know what to do.

Could you explain this fix a little more?

Thank you very much - andreas

The useradmin.zip file contains two directories [lang] and [useradmin].

1. Upload [useradmin] in yourmoodledir/blocks/ directory.
2. Upload [lang] in yourmoodledir/. That will place the corresponding files in the existing lang directory.
3. Go to yourmoodledir/admin/ to register the block.
4. You can now add a User Administration Block in your main page and/or in your administration page.

You should read the readme.txt included in the [useradmin] directory.

Cheers.

Hello again,

Sorry for the post, too fast before I search !!

I found where was the problem for me, perhaps I don't have the latest version.

In the useradminlib.php file, I modify the function "useradmin_get_users_listing"
on line 738
the "WHERE" condition contains :

/... 'OR u.institution $LIKE '%$search%' OR u.institution $LIKE '%$search%' .../

'u.institution' is used twice
I change it to

/... 'OR u.institution $LIKE '%$search%' OR u.department $LIKE '%$search%' .../
and the search on department works.

Thanks and have a good day.

Ug. i'm having problems getting this thing to work.

i've got this installed as> /public_html/moodle_anisa/blocks/useradmin

and have tried installing the lang directory in a couple of places. First in public_html/moodle_anisa/ which tries to wipe out the current /lang subdirectory and then in public_html/moodle_anisa/lang/ which still does not encourage Useradmin to appear in my list of Blocks.

Any ideas?

Have a great morning!

Hi Fred,
Moodle stores the last time a Role assignment changed in column timemodified of the mdl_role_assignments table.

I'll try to explain why showing or sorting by assigned Role (or assignment date ) would be messy.
UserAdmin pages always show one row per User.
But a User may have many Roles assigned (and assignment dates too) [technically this is a one-to-many relation].
They should be shown as a table of roles (and dates) under each User row. As a single user may have a lot of Roles, the UserAdmin page would become a monster.

Anyway... to unenroll students after 30 days you should try setting the Enrollment duration in the Course Settings page.
I'm not sure, but I think it does what you need.

Lorenzo

Hi Dirk
you can download users CSV file also from the "Browse list of Users" page, where you can filter only users having the "Student" role in a given Course, for example.

Lorenzo

Scott -
I just had an instructor write me that one of her students has been submitting assignments, posting to forums, and completed a quiz. When the instructor asked the student to edit her profile to use upper and lower case letters for her name, the student instead created a new account (using a different email address). Then the student went into the course and uploaded another assignment, and made several forum postings before the instructor realized that instead of editing her profile, the student created a new account. The instructor wrote me asking if it was possible to merge the two accounts. Right now, my answer to her will be no. I, for one, would LOVE to see a merge user feature. Please keep us informed.

~Cynthia

if possible add 2 more columns field for records display,
1st -> duration "how long that the user online on moodle".
2rd -> registration date "date of user register on moodle".

but i think this two columns have to add a new database table on moodle,
hope latest version user administrator is include two columns

We're running 1.9.2 and using the useradmin19.zip posted on July 25/08 and have the same problem. We're using Postgres 8.1.4.

We're trying to run a query to list all the teachers in a course category, but keep getting zero results.

The query being generated from the attached screenshot looks like this:

SELECT 
	u.*, mh.name AS mnethostname, 
	mh.wwwroot AS mnethostwwwroot 
FROM 
	mdl_user u, 
	mdl_mnet_host mh 
WHERE 
	(u.mnethostid = mh.id OR u.mnethostid IS NULL) AND 
	u.deleted <> '1' AND 
	u.username <> 'changeme' AND 
	u.username <> 'guest' AND  
	EXISTS ( 
		SELECT * 
		FROM 
			mdl_role_assignments ra, 
			mdl_context c  
		WHERE 
			ra.userid = u.id AND 
			ra.contextid = c.id AND 
			c.contextlevel = 40 AND 
			ra.roleid = 3 AND 
			c.instanceid = 59 
		) 
ORDER BY firstname ASC 

It seems like a valid query in Postgres, but the results are zero. I'm wondering how well has this been tested on Postgres ?

Any ideas ?

Hi Roger,
Enhanced User Admin block is for site administrators and not course teachers.
It allows to modify users that are, by definition, "site-wide" and not "course-wide".

Read the README.txt to know the capabilities this block relies on.
Please not that users must have the required capabilities in SYSTEM (global) context.

Lorenzo

Big oops here - its working now
Mix up between two moodle installations. It happens to the best of us - thats my excuse anyway

Arif

I guess what I am asking is, is do I have something configure incorrectly, or is this expected behaviour?

Also, when we use the export functionality there are no groups exported, this would be really useful to see as we'd like to generate a file which can be re-uploaded and imported in the User Administration block to add updated parents.

Hello,

I'm trying to install useradmin19 in moodle 1.93.

For that I have used XMLDB editor at the bottom of the site administration (is it correct)
Administration/ ► Miscellaneous/ ► XMLDB editor.

So I succeed to creat and load the file (i got green light), but i have no trace of the block even in

► Administration/ ► Modules/ ► Blocks/ ► Manage blocks

or

in the ''Add'' block in the frontpage

I don't know what i did wrong as it is the first block i'm trying to install

Hey

Yeah, I have this problem too. Only want to export users who have never logged into the site, but it exports everyone.

HELP!!

Hi all

a new release of UserAdmin block for Moodle 1.9 is available at my dowload link.

I fixed some bugs related to user upload from file.
Sorry, but I was not able to add any other feature.

I also added the pt-br translation. Thanks Danilo!

For people unable to install this block: please read the official Moodle documentation about the location of blocks in the Moodle directory tree.

Lorenzo

Hi Robert,

custom user fields are not supported, yet

Lorenzo

Hi all

I've updated the UserAdmin block (1.9 version only).

Now there is some support for custom user profile fields and ability to hide unwanted standard user fields from User listing and User download (no support in User upload, yet).

Use the new block configuration page (from Modules->Blocks) to enable custom fields or hide standard fields.

This is the download link.

This is an updated list of the features of this block (sorry for the terrible english )

---

This block is thought for Administrators only and is hidden to users with lower roles.
So it may be put in the Home page and in Administration page, in upper left or right corner for easy access.

BROWSE LIST OF USERS
These features are available in the User listing page:

• Search for an arbitrary text in firstname, lastname, email, institution, department and username fields, and in selected custom user profile fields
  
• Filter by firstname/lastname first letter
• Filter users having/not having a specified Role in a Site, Course Category or Course context
• Filter users by authentication method
• Filter confirmed/unconfirmed users
• Ordering by any of the shown columns
• Collapsing/expanding columns
  
• Paged view, with selectable page length
• Filtering, ordering, paging, column collapsing information are all stored in the user's session. When the user get back to the Listing page, he find it exactly in the same state as he leave it.
• Download to file only users matching the filter conditions (ignoring paging)
• Global block configuration (in Site Administration->Modules->Blocks) to include any custom user profile field or hide unwanted custom user fields, from User listing and User Download

ACTIONS ON USERS FROM USER LIST
In the User listing page some actions may be taken on users, without entering User's Profile page:

• Disable/Enable a user's email with one click
• Delete a user with one click (...and confirm ;) )
• Confirm an unconfirmed user

Some mass-actions may also be applied to many users, selecting them one by one or by page:

• Mass assign/unassign Role in a Site/Course Category/Course context
• Mass delete users (beware!)
  

DOWNLOAD USERS TO FILE
Users data may be downloaded to a CSV File.

• Download all users, from the block entry
• Download only users matching filter conditions, from the User listing page (please first apply search condition with the [Search] button and then click on "Export these users to CSV file")
• Selectable field separator character (comma, semicolon, pipe or tab)
• Selectable line terminator (Windows, Unix and Mac style)
  
• Selectable file encoding (UTF-8 and ISO-8859-1 only)
• Optionally includes custom user profiles fields (selected in block configuration, see above)
• Excludes hidden standard user fields (selected in block configuration, see above)
• 5,10 or 20 columns may be included to show Roles of the users in as many courses
• The downloaded file may be used to feed the User upload feature, for mass-updating user data (please note that custom fields are not yet supported in user upload, so the file may not be used to feed the upload if these fields have been included)

USER UPLOAD FROM FILE
May create or update users uploading from a CSV file, with some additional features compared to standard "Upload users".

• When creating a new user checks for duplicate username and e-mail
• Checks if e-mail address is valid (just syntactically)
• Existing users may be updated, using username as "key" to find users
• Username "renaming" may be enabled
  
• Assign roles and groups in Courses context (only) when uploading new users or updating
• Password may be explicitly specified (no password policy check, yet)
• Alternatively, password may be randomly generated for each user. In this case automatically send an e-mail with credentials to each newly created user.
• Fake, unique e-mail address generation for users with no known e-mail. E-mail address is automatically disabled for this users. Off course, automatic password creation may not be used for these users, as no one will know the password and it will not be recoverable by e-mail ;)

Please note that there is no support for custom user profile fields in User upload

Also note when you save changes in a User's Profile page, you get back to the standard Moodle user administration page.
This is not a bug.
The User's Profile page is a standard Moodle page, that redirect to standard pages after saving. There is no way to get back to a custom page.
Anyway, as User Listing page persists its state in session, if you get back to home page and then to User Listing you'll find this page exactly in the same state as you leave it.

Lorenzo

Hi Edwin

the query shown is correct.
If it is terribly slow even executing the SQL directly (for example in phpMyAdmin) I think it is a database performance problem.

The number of users is not the issue. This block is in use in much larger sites.

Maybe the problem comes form the number of custom fields combined with the number of users.
The query have a subquery foreach custom field. It may be very "expensive" for the db engine, but there is no other (portable) way to implement it.

Also, AFAIK, MySQL is not very efficient with this kind of queries.
Maybe adding some db index on mdl_user_info_data could help. But I do not know MySQL very well. I use PostgreSQL on my production server.

If this doesn't help, I can only suggest to include fewer custom fields in UserAdmin.

For the direct Download not including custom field, I'll check the code.
This may be a bug.

Lorenzo

Hi Lorenzo, can I install this feature on Moodle 2.0.1+ ?