Learning and Evaluation/Archive/Boiler room/Contribution logging
In order to automate the maintenance of the evaluation portal, and to evaluate the effectiveness of the Evaluation portal itself, we are logging contributions to wiki pages within the scope of the evaluation portal. Metadata about edits made to these pages are stored in the publicly-viewable p50380g50729__grantsbot MySQL database on the metawiki_p database cluster on Wikimedia Labs. All data are pulled from the metawiki_p replica database, and everything in these tables is publicly-accessible data--no personally identifiable information (such as email addresses, IP addresses for logged-in users, etc) is logged.
Logging allows us to analyze the success of the Evaluation portal and makes it easier to figure out if there are things we need to improve to make it more useful and usable. We used a similar logging setup to evaluate the impact of the Teahouse during the pilot period. These data are not used to determine eligibility for grant funding.
eval_patterns[edit]
This table tracks how many pages there are in the category CategoryLearning patterns and/or its sub-categories, as well as to keep track of recent edits and endorsements to these patterns.
Fields[edit]
id[edit]
page_id[edit]
p_path[edit]
the full page title
p_namespace[edit]
p_creator[edit]
the user_id of the editor who created the page.
pc_username[edit]
the username of the pattern creator
pc_date[edit]
the date the pattern was created
pc_rev[edit]
the rev_id that created the page
recent_editor[edit]
the user_id of the person who edited the page most recently
re_username[edit]
the username of the most recent editor
re_date[edit]
the date of the most recent edit
re_rev[edit]
the revision id of the most recent edit
endorsements[edit]
the number of times the pattern has been endorsed