Wiki Spaces


Get Help from Others

Q&A: Ask OpenMRS
Discussion: OpenMRS Talk
Real-Time: IRC Chat | Slack


Page tree
Skip to end of metadata
Go to start of metadata

2015 GSoC Project Idea

This project is being considered as a potential project for Google Summer of Code 2015. If you are a potential intern and are interested in working on this project, please discuss it in detail with the mentor(s) listed here before submitting your internship proposal.

Primary mentor

Sri Maurya Kummamuru

Backup mentor

Bob Jolliffe

GSoC student



DHIS2- is an aggregate indicator system used along with OpenMRS in many countries.The Present Dhisreport module being used automates the process of running sql queries against an OpenMRS instance and posting the results to a DHIS2 instance. It even exposes a set of web services that can be consumed through cURL. But, this requires a knowledge of the database structure and also SQL skills.
Reporting Module has a system that allows generating reports based on a cohort system that generates the SQL queries automatically. But, This requires creating the cohorts through UI.

This project is aimed at using the cohort system of reporting module and merging it with the dhisreport module to let users without SQL knowledge create reports and send data to the DHIS system.


  • Good Java and SQL skills.
  • Familiarity with J2EE web programming (e.g., JSPs)
  • Familiarity with Spring Framework  and Hibernate will help but not required.

Project Champions


  • Study about the existing dhisreport module, DHIS integration module(this has resources that would explain the integration process) and reporting module.(All links are provided below)
  • Creating the project plan and timeline. 
  • Creating technical documentation for the module.
  • Creating a User Interface that lets users access Reporting module's components to generate the SQL queries.

Extra Credit

  • Enhancing the web services to provide more advanced queries.
  • Writing Unit Tests for the module.

Potential applicants

Please start going through the documentations provided and start familiarizing yourself with Reporting Module, DHIS Integration module, Hibernate and Spring in the same order if possible. You wont be required to have more knowledge about DHIS than provided in Dhis Integration module documentation. Good Luck!



  1. Hello Sri Maurya Kummamuru,

    I am interested in and will like to work on this project

    I am Java, C programmer as a 3rd year undergraduate student at the University of Buea pursuing a Bachelor in Engineering and specialized in Software Engineering. I am also verse with MYSQL. I will appreciate any guidelines in addition to the above links.


  2. Sri Maurya Kummamuru

    Bob Jolliffe

    Hello sir,

    I think i have right qualifications to work on this.

    > in my 2nd year i did my internship at HISP India in New Delhi, India. So i familiar with dhis2 product.

    > during my internship, in first three months i contributed to hundreds of dhis2 reports. developed complex MYSQL queries for requirements, designed reports using eclipse BIRT tool, map data into reports. So I am very familiar with database structure also.

    > and last few months of my internship i got a chance to contribute to dhis2 customizations. contributed to some new modules. So I am familiar with flow of the dhis source code and how hibernate, spring frame work and strut are applied there.


    Now i am in the 4th year reading for Management & Information Technology, University of Kelaniya. I am very interested to work on this project and looking forward to your valuable guidance and support for get selected to this project.


    Thank you..!


  3. Hi Sri Maurya Kummamuru Bob Jolliffe . I am interested to work upon this project  :)

    So far I have studied about the existing dhisreport module, and reporting module. To ensure my flow of understanding and  that I am on the same page I have a few questions :)

    Would be of great help if you look into them.Is this the correct place to ask or by any other means (IRC/OpenMRS Talk/Private mail) ?

    TIA  :)    

  4. Hi Sri Maurya Kummamuru Bob Jolliffe. I am interested in working on this project. 

    I came to know about DHIS2 community as you mentioned once to me that this was one of your previous GSOC projects. 

    I am currently working on the GSOC proposal and would like to discuss further details to know more about the reporting module. Is this the suitable area to ask further questions or letse me know other means of communication.

    Thank you!





  5. Hello All, 

    There is a talk post that I have started for discussing any questions regarding the project.

    Manika Maheshwari you can post your questions here



    Sri Maurya Kummamuru