Versions Compared

Old Version 2

changes.mady.by.user UdaiU

Saved on

compared with

New Version 3

changes.mady.by.user UdaiU

Saved on

Key

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

Table of Contents

Project Idea

Getting their initial data into Mifos X when setting the platform up for the first time is often time-consuming and difficult for MFIs. This project will create an Excel-based data import tool for directly importing bulk data into Mifos X. Using the REST APIs exposed by the platform, this tool will import the following data: Client Details, Client Loan and Saving account details, Client Fee Details, Client repayment History. Upon completing their initial organizational and loan product configuration, the MFI can generate a pre-formatted Excel template to import their data in. These templates will primarily be used for inputting manual paper-based or other Excel-based data but could also be used for migration from another system database. 

Planned Schedule

Up to June 1 : Get to know the request parameters for entities to be imported. Discuss details with mentor.

TimelineObjectives
Week 1 (June 01 - June 09) Implementing the workflow with a simple entity such as Office.
Week 2 (June 16)
  • Implementing Client Import template where the first sheet of workbook is pre-formatted with existing Offices entered through the MifosX platform and these constraints are imposed on the second worksheet.
  • Implement Personnel Details import template where the first sheet of workbook is pre-formatted with existing Offices entered through the Mifosx platform and these constraints are imposed on the second worksheet.
  • Import of the above two workbooks.
Week 3 (June 23)
  • Implementing Client Loan import template where the first three sheets of workbook is pre-formatted with existing Loan Product configuration entered through the MifosX platform and Clients and Loan Officers entered in the above step and these constraints are imposed on the fourth worksheet. 
  • Implementing Client Repayment History import template where the first sheet of workbook is pre-formatted with Client Loans imported in the first step and these constraints are imposed on the second worksheet.
  • Import of the above two workbooks. 
Week 4 (June 29)
  • Implement Saving Account import template where the first two sheets of workbook is pre-formatted with existing Offices and Clients imported in the first step and these constraints are imposed on the third worksheet. 
  • Import the above workbook.
Week 5 (Aug 4)Mid-term evaluations
Week 6 (Aug 11)TBD
Week 7 (Aug 18)TBD
Week 8 (Aug 25)TBD
Week 9 (Sept 1)Implement any validation code that is missing in the platform regarding data import.
Week 10 (Sept 8)Refactor the code base.
Week 11 (Sept 15)Check through various test cases if the code breaks anywhere. 
Week 12 (Sept 27)Write tests, documentation, and submit final evaluation.

...

Project Details

Github: https://github.com/avarice010/DataImport