Reporting Component Design Notes

Prerequisites

•  MySQL workbench 5.2 - ER diagram tools
• OpenOffice.org 3.2 - data discovery spreadsheet

Steps

• Collect requirement
  • Collect user activities from wiki/blogs/forum
  • Implement data object for OverallContributionScoreComponent
• Data Discovery
  • Mediaiwki with multi-languages support
  • wordpress
  • phpbb
• LDM/PDM design
  • 
• Mapping and ETL development
  • ETL tools
    • CloverETL and Kettle are so big, need jre environment . We don't need more flexible ETL tools here.
    • MySQL (select ... into outfile/load data infile)
• Report development
  • Implement reports and charts based on OverallContributionScoreComponent and refactor the /home/porlets/PortletClass.php
  • Fix tickets #238,#270,#271