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_patternsEdit

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.

FieldsEdit

idEdit

page_idEdit

p_pathEdit

the full page title

p_namespaceEdit

p_creatorEdit

the user_id of the editor who created the page.

pc_usernameEdit

the username of the pattern creator

pc_dateEdit

the date the pattern was created

pc_revEdit

the rev_id that created the page

recent_editorEdit

the user_id of the person who edited the page most recently

re_usernameEdit

the username of the most recent editor

re_dateEdit

the date of the most recent edit

re_revEdit

the revision id of the most recent edit

endorsementsEdit

the number of times the pattern has been endorsed

eval_patterns_endorsementsEdit

FieldsEdit

eval_profilesEdit

FieldsEdit

eval_questionsEdit

FieldsEdit