BrnDmp

Custom reporting Moodle

Writing custom SQL statements for reporting for client.

Requirements are:

• total number of visitors on site per month (SQL statement on log table)
• total number of visitors per country (SQL statement on log table)
• number of users per country per course (SQL statement on log table)
• show documents which have not been updated for 1 year (filesystem script)

Moodle logs the ip addresses so to know the country I have to call to some API like:

http://www.hostip.info/use.html

I was already planning to write a PHP/Python script to do this so then I could use their http libs to call the API’s.

Also thinking about extending the script with R-stats to plot trend lines and produce nice plots. This could be a good start for server reporting of Moodle.

• Course usage
• Trends
• Site usage