Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 
MentorsTBD
Overview & Objectives

Capturing surveys and other forms of data is an essential tool for a MFI to manage it's client relationship. Mifos X currently has taken a new approach to capturing this information and any additional data on clienta (and other entities like Groups, Loans etc) through the "datatables" approach. We want to simplify the process for setting it up.

 

Description

Capturing additional data is currently done by manually creating MySQL database tables with appropriate columns to store the additional data and then using MifosX Platform API's to link these newly created tables to existing entities.

We are looking to simplify this process by

a)

Helpful Skills

Mifos X provides an API called 'datatables" which allows the IT team that is deploying Mifos X to 

  1. Create a MySql Table(s) following Mifos X Non Core column conventions (listed later)
  2. Register that MySql table with a 'Core' Mifos X MySql table
  3. Immediately be able to Create, Read, Update and Delete data in the reference User Interface.

We are looking to simplify this process by

a) Providing API's for creating these MYSQL tables

b) Providing a user Interface that leverages the API's for creating the "MySQL" tables and columns

Helpful Skills Java (Spring/JPA/Jersey), SQL , MySQL
Impact

Capturing client data and having a holistic transparent view into the client is one of the most powerful and definitive features of Mifos X. This data is used to monitor and analyze the services being delivered to the client and social impact these services are having.

Having a simple interface in which to

collect this survey

define this additional "Survey" data is an essential part of making this a usable feature of the software for MFIs.

Other Resources

 Link to existing code

Link to Question Groups overvie?Mifos X - Plugging In Non-Core and User Defined Data

 

Create Data Import Tool for Mifos X

...