-
Bug
-
Resolution: Fixed
-
Minor
-
3.5.4, 3.6.2, 3.11.5, 4.0
-
MOODLE_311_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_400_STABLE
-
MOODLE_311_STABLE
-
Setup
- Log in as admin
- Navigate to Users > Accounts > User profile fields in site administration
- Create a new Text input profile field
- Short name: myfield
- Name: My field
- Should the data be unique: No
- Create another new Text input profile field
- Short name: myuniquefield
- Name: My unique field
- Should the data be unique: Yes
- Create a new user:
- Username: user01
- My field: Tomato
- My unique field: Rabbit
1. Regression test for duplicating existing data in unique field (
MDL-40881)- Navigate to Users > Accounts > Upload users in site administration
- Upload MDL-64770-1.csv
- Confirm you see the following in the Status column:
This value has already been used. (profile_field_myuniquefield)
2. Test uploading new duplicated data to unique field
- Navigate to Users > Accounts > Upload users in site administration
- Upload MDL-64770-2.csv
- Confirm you see the following in the Status column of the second row:
This value has already been used. (profile_field_myuniquefield)
3. Test uploading new non-duplicated data to unique field
- Navigate to Users > Accounts > Upload users in site administration
- Upload MDL-64770-3.csv
- Confirm both users are created with correct My unique field value
4. Test uploading new duplicated data to non-unique field
- Navigate to Users > Accounts > Upload users in site administration
- Upload MDL-64770-4.csv
- Confirm both users are created with correct My field value
Setup Log in as admin Navigate to Users > Accounts > User profile fields in site administration Create a new Text input profile field Short name: myfield Name: My field Should the data be unique: No Create another new Text input profile field Short name: myuniquefield Name: My unique field Should the data be unique: Yes Create a new user: Username: user01 My field: Tomato My unique field: Rabbit 1. Regression test for duplicating existing data in unique field ( MDL-40881 ) Navigate to Users > Accounts > Upload users in site administration Upload MDL-64770-1.csv Confirm you see the following in the Status column: This value has already been used. (profile_field_myuniquefield) 2. Test uploading new duplicated data to unique field Navigate to Users > Accounts > Upload users in site administration Upload MDL-64770-2.csv Confirm you see the following in the Status column of the second row: This value has already been used. (profile_field_myuniquefield) 3. Test uploading new non-duplicated data to unique field Navigate to Users > Accounts > Upload users in site administration Upload MDL-64770-3.csv Confirm both users are created with correct My unique field value 4. Test uploading new duplicated data to non-unique field Navigate to Users > Accounts > Upload users in site administration Upload MDL-64770-4.csv Confirm both users are created with correct My field value
Defining new user profile field there are several options:
- Is this field required? YES/NO
- Is this field locked? YES/NO
- Should the data be unique? YES/NO
- Display on signup page? YES/NO
- Who is this field visible to? NOT VISIBLE/VISIBLE TO USER/VISIBLE TO EVERYONE
It seems that user profile fields uniqueness does not work when users are imported from a file (tested with current users data update, not creating new one). There are even no any warning about this.
What do you think about this behavior? This is a bug or not in your opinion?
How to reproduce?
- Make sure that you have at least two users on your Moodle site.
- ADMIN: Add new user profile field: Site administration -> Users -> Accounts -> User profile fields; required options:
- Should the data be unique? YES
- ADMIN: Site administration -> Users -> Accounts -> Bulk user actions
- Selected user list... Add all
- With selected users... Download -> Go -> Download
- Type the same value for at least two user for user profile field defined in 2.
- ADMIN: Select changed file with users on Site administration -> Users -> Accounts -> Upload users
- Upload type: Update existing users only
- Existing user details: Override with file
- User profile fields values for at least 2 users will be duplicated
