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)
• David Aylmer (davidaylmer(a)hotmail.com)

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)
• Can view message body

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
• message_attachment_id (FK to file)
• email_headers (if any)

Reporting

• Filter by course
• Filter by activity
• Filter by user
• Filter by message_type
• Filter by sent datetime
• Filter by subject