You will need the Terminal for this operation. Open Terminal and navigate to the directory using the cd command where you want to change the case of the files. Then run the following command: for FILE in `ls -A1 *`; do FILENAME=`echo ${FILE} | sed ‘s/ /\\ /g’`; echo mv ${FILENAME} `echo ${FILENAME} | tr […]
A report was needed by my client to list participants in a course with access info, so those who did not access the course can be warned to perform the mandatory quiz before closing it. SELECT u.firstname, u.lastname, u.idnumber, c.shortname, IF(ue.status = 0, ‘Active’, ‘Suspended’) as status, e.enrol, FROM_UNIXTIME(ue.timecreated, ‘%m/%d/%Y %h:%i:%s %p’) as enrollment_date, IF(ue.timestart = […]