Hackfest UK 2014/Email Logging

Message Logging and Reporting

• Contact Names: (please add name if interested)
• Larry Zoumas (larry.zoumas@xtractor.se)
• Martin Sandberg (martin.sandberg@xtractor.se)

Description This plugin will allow admins and teachers to search through messages sent to users. The purpose is to easily answer the question of whether or not a user was notified of an important event, such as a face-to-face session, quiz deadline, etc.

Notes:

• Not all emails go through the messaging system. This needs to be investigated and fixed.
• We might want to allow a place for developers to add hooks or decorate this functionality

Capabilities:

• Can view own messages
• Can view other messages
• Can view messages in your courses (teacher)

Options:

• Optionally log body of message

Proposed Table Schema

messaging_log

• id
• from (user_id)
• from_address (email address or identifier when the message was sent)
• message_type (FK mdl_message_provider)
• moduleid
• courseid
• subject
• body_id
• time

messaging_log_user

• id
• message_log_id (FK to messaging log)
• userid
• to_address (email address or identifier when the message was sent)
• time
• status

messaging_log_body

• id
• body_text

Reporting

• Search system-wide
• Search by course and activity
• Search by user
• Search by message_type
• Search by sent datetime
• Search by subject