User upload via CLI

If you want, create your own CSV file and follow documentation to https://docs.moodle.org/39/en/Upload_users

Test 1. Basic scenarios

1. In the command line from the moodle directory run

   php admin/tool/uploaduser/cli/uploaduser.php --help

2. Observe the generated help and make sure it makes sense (i.e. information about the script, its supported parameters and how to use it should be printed)
3. Try to run CLI script without arguments

   php admin/tool/uploaduser/cli/uploaduser.php

4. Check the "Argument --file is required" message is displayed
5. Try to run CLI script specifying non-existing file. The script should fail and exit code should be 1

   php admin/tool/uploaduser/cli/uploaduser.php --file=PATHTONONEXISTINGFILE

6. Check the "File xxxxxxx does not exist or is not readable" message is displayed
7. Take attached examplecohorts.csv file, copy it to the Moodle root directory and run:

   php admin/tool/uploaduser/cli/uploaduser.php --file=../../../../examplecohorts.csv

8. Make sure users are created and added to the cohorts. There will be errors about non existing course
9. Create the course with shortname "math102"
10. Run the same script again - it should say that users already exist. Make sure users are not enrolled in the course.
11. Run the same script with the same file but with additional argument

    php admin/tool/uploaduser/cli/uploaduser.php --file=../../../../examplecohorts.csv --uutype=2

12. Make sure users are now enrolled into the course and groups are created and the users are added to the groups groupA and groupB (as in the file)
13. Run the command (this will use semicolon as delimiter):

    php admin/tool/uploaduser/cli/uploaduser.php --file=../../../../examplecohorts.csv --delimiter_name=semicolon

14. Check the errors "Not enough columns" is displayed
15. Replace all commas in the file with semicolons and run the same command again.
16. Check script completes correctly (in this case there will be no changes because users already exist)

Test 2 . Error testing

1. Download a fresh examplecohorts.csv.
2. Edit it and remove the "cohort1" text in the first row.
3. Run the script with the file:

   php admin/tool/uploaduser/cli/uploaduser.php --file=../../../../examplecohorts.csv

4. Make sure CLI script prints the message error '"" is not a valid field name'.
5. Download a fresh examplecohorts.csv.
6. Edit it and add a "x" colum after "cohort1".
7. Run the script with the file:

   php admin/tool/uploaduser/cli/uploaduser.php --file=../../../../examplecohorts.csv

8. Make sure CLI script prints the message error ' "x" is not a valid field name'.
9. Download a fresh examplecohorts.csv.
10. Run the script with the file:

    php admin/tool/uploaduser/cli/uploaduser.php --file=../../../../examplecohorts.csv --uutype=5

11. Make sure CLI script prints the message error "Value for argument --uutype is not valid. Allowed values: 0, 1, 2, 3"
12. Run the script with the file:

    php admin/tool/uploaduser/cli/uploaduser.php --file=../../../../examplecohorts.csv --country=Australia

13. Make sure CLI script prints the message error "Value for argument --country is not valid. Allowed values: , AF, AX, [...]"

Test 3. Colors in the UI

1. Go to "Site administration > Users > Accounts > Upload users"
2. Upload the same file, submit again leave all default values
3. Make sure the status column displays warnings with yellow-ish background
4. Upload the same file, submit and then change the upload type to "update existing users"
5. On the next screen, make sure the enrolment actions are displayed with green-ish background
6. In the CSV file change one of the users' names, upload it and submit the second form with the default values
7. Check the error message about the duplicate email address is displayed with the red-ish background