MAC OS X – Renaming Multiply Filenames to Lowercase in a Directory

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 […]

Another Moodle report – List of users in a course with enrolment and access info

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 = […]