Overview and Background
General Contributing Guidelines
Getting Started
External 3rd Apps
MifosX
Core Banking & Embedded Finance
Application Framework
Main Platforms
Staff UI Platforms
Customer UI Platforms
Ancillary Tools
Payment and Process Orchestration
Getting started with - Data Import Tool
Getting started
Starting Data Import tool, Using Git bash >> Go to:
Run:
Once the server is started:
Using Data Import tool, from web browser - Go to:
http://localhost:8070/DataImportTool
Using Data Import Tool
Setting up from Front end
In order to start importing data, you should have created office & staff from front-end:
Importing Clients
Updating details in the downloaded sheet:
Note: All fields marked with an asterisk(*) are compulsory.
Drop down values should be selected, i.e. for: Office Name, Staff Name and Active.
Date format should be: DD-MM-YYYY
Uploading the sheet:
Choose file and select the file >> then click on submit button to upload.
Re-Uploading unsuccessful import sheet
If the import was not completely successful, then Re-Upload.xls sheet will be generated automatically:
Open the sheet and check for status
In the shown example:
a) For 2nd row for client – “John”, Import was failed and the status is “activationDate : Client activation date cannot be a date before the office opening date” (Shown in red).
b) For 3rd row for client - “Anna”, Import was Successful and the status is “Imported (Shown in green)”.
After making the necessary changes, upload the same sheet again.
For this example, I am only updating for failed import i.e.:
a) For 2nd row for client – “John”, updating the “Activation date” to the Office opening date or later date.
Import Successful
On successfully completing the import, it will show the message as:
In the same way Data can be imported
Import Centers:
Import Groups:
Import Loans:
To start importing Loans, you should have defined from front end:
Currency configuration, Loan products & Charges. (Administration => Organisation/ Products)
Payment Types (Administration -> System -> View Code -> Add/Edit Code Value)
Import Loan repayments:
Import Savings:
To start importing Savings, you should have defined from front end:
Currency configuration, Savings products & Charges. (Administration => Organisation/ Products)
Import fixed deposit:
To start importing fixed deposit, you should have defined from front end:
Currency configuration, fixed deposit products and Charges. (Administration => Organisation/ Products)
Import recurring deposit:
To start importing recurring deposit, you should have defined from front end:
Currency configuration, recurring deposit products and Charges. (Administration => Organisation/ Products)
Importing RD account transaction’s:
Importing closing of savings account:
Importing/Adding – Journal entries:
Last modified 2yr ago
Copy link
Contents
Getting started
Using Data Import Tool
Importing Clients
Updating details in the downloaded sheet:
Uploading the sheet:
Re-Uploading unsuccessful import sheet
In the same way Data can be imported
Import Centers:
Import Groups:
Import Loans:
Import Loan repayments:
Import Savings:
Import fixed deposit:
Import recurring deposit:
Importing/Adding – Journal entries: