OFF-LINE DATA COLLECTION MODULE for remote brunches & centers

Description

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).

Environment

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

Activity

Show:
Kakhaber Kheladze
January 25, 2012, 3:01 PM

Some related discussions from DEV group :

1. https://groups.google.com/forum/#!topic/mifosdeveloper/KCbq_V_7H3I

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

2. Discussion on to use Excel/OOO based model or web based client [Part2]:
https://groups.google.com/forum/#!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.

Assignee

Ishan Khanna

Reporter

TengizM

Labels

Implementation Priority

Must

Story Points

None

Team

Core

Scheduled For

Release

Epic

None

productboard URL

None

Man Day Estimate

None

Time tracking

0m

Time remaining

40h

Fix versions

Priority

Minor
Configure