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
Some related discussions from DEV group :
2. Discussion on to use Excel/OOO based model or web based client:
2. Discussion on to use Excel/OOO based model or web based client [Part2]:
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.
ODC consists from 3 parts:
Download Data for Field officer
Data Entry in remote area ( village, center, group place, etc)
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"?
Please re - investigate and put all results under this case.