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:

Reference Guide: https://github.com/openMF/DataImportTool