OFF-LINE DATA COLLECTION MODULE for remote brunches & centers


Some of our units ( brunches | centers) are in provinces. There is no communication channels in those areas: no internet, no GPRS, no 3G, no GSM, etc. We need to have a off-line data collection interface in order to record data , bring in regional office (where there is a connection to Mifos) and import/synchronize it into Mifos.

Easiest way is Spreadsheet ( Libreoffice | Excel) with XML|CSV import macros based on some format.

QUESTION1: can Mifos import file? where is the description ( conceptual schema or just sample) of import file?

QUESTION2[Optional]: Can Mifos Export data to Spreadsheet for Data Collection? This question is optional because I guess it is possible in reporting (BI).


Win 7 Home 32 | Prof. Ult 64
JDK 1.6.0_20 32|64
MySQL Ver 5.5 32|64
Tomcat 6.0.33 32|64
Mifos Ver 2.2.1 | 2.1.4
Mifos BI 1.3


Kakhaber Kheladze
January 25, 2012, 3:01 PM

Some related discussions from DEV group :


2. Discussion on to use Excel/OOO based model or web based client:!searchin/mifosdeveloper/off$20line$20data$20collection/mifosdeveloper/7PjuO1qy9yo/J0NV6-80quwJ

2. Discussion on to use Excel/OOO based model or web based client [Part2]:!searchin/mifosdeveloper/off$20line$20data$20collection/mifosdeveloper/APw3xQLUIG8/rEcn3emNLzIJ

Kakhaber Kheladze
February 16, 2012, 9:43 AM
Kakhaber Kheladze
February 16, 2012, 10:05 AM

I have obtained following ODC modules:

1. Chrome based
2. Developed by Conflux
3. Developed by Hugo
4. Mifos Light By Logica (Kenia)

Is there is any docs / descriptions available?
If you know more ODC modules please add here.

Kakhaber Kheladze
March 14, 2012, 11:52 AM

ODC consists from 3 parts:

  1. Download Data for Field officer

  2. Data Entry in remote area ( village, center, group place, etc)

  3. Upload Data into Mifos

from this 3 items 2 is something we all ( most of us) agree on:

1. Download Data using Pentaho BI
2. Upload Data into Mifos using REST API

Issues we have different views on:
1. Data Entry ( web based UI, GUI Based UI, Spreadsheet based App, etc. )
2. Data Format : XML | JSON | XLS | XLSX | ODF | Other

Let us start from the tasks which we all agree on: Download (PENTAHO) and Import (REST) .
Let us use XLS at the beginning as data exchange format, as historically it was used in most cases, almost all users are familiar with it ( despite of JSON) and we will have more contributors, and finally - if in some stage decision will be done to use XML or JSON it should not be so difficult to move from structure, well formatted XLS to XML|JSON.

Lukaz - already implemented "IMPORT NEW CLIENT from XLS" functionality. Can we now implement "import new loan"?

Kakhaber Kheladze
September 21, 2014, 6:14 PM

Please re - investigate and put all results under this case.


Ishan Khanna




Implementation Priority


Story Points




Scheduled For




productboard URL


Man Day Estimate


Time tracking


Time remaining


Fix versions