Client Data Import Functional Spec

Client Data Import Functional Spec

Client Data Import

Release

2.2

Status:

To be implemented

Introduction

A lot of users need functionality which allows them to create a large number of clients automatically by importing them from Excel file. This option should save a lot of time and effort in comparison to the manual creation of each client in UI. This requires the following:

  1. Ability to import new Clients in any states with all necessary information. It should be possible to import Client inside Group and without Group. Configuration properties should be taken into account. Mandatory fields defined in Mifos should also have impact on importing information.

  2. Import functionality should accept Excel files in .xls format. There should be no difference between clients created manually and by import.

User Stories

Priority

User Story

Section in FR

1

As a user, I want to be able to import a file with all Clients, so that they will be properly created in Mifos. I expect that there are no differences between Clients created manually and by import.

 

1

As a user, I want to have ability to define the Customer Global Number.

 

1

As a user, I want to be able to see errors in import and be able to correct them.

 

Goals

  • Ability to import file with Client data so that Mifos can create Clients in the specified state.

  • Properly displays rows read, ignored, errored, and imported during import.

Non-Goals

The following items will not be addressed in this version of the feature:

  • Ability to import file with different or switched columns

  • Ability to import Client data when Center hierarchy is turned off.

  • Ability to specify meeting information during import.

  • Ability to create default savings accounts for clients during import.

Basic flow in Mifos UI

1. Log in to Mifos.

2. Switch to 'Admin' tab.

3. Click on 'Import client data' link in 'Manage Imports and Exports' section as it is shown below:

4. Import Client data page will be loaded as it is shown below: