Support Center

Importing Your Data

Last Updated: Sep 05, 2018 01:12PM CEST

1. Set Up Mambu

2. Download the Template and Fill in the Data

3. Validate the Excel File and import your data

4. New and changed validations:

-------------------------------------------------------------------------------------------------------------------------------- Back to top

Migrating your clients data is the first step that you need to take before using Mambu and it should be done after setting up Mambu as described in Steps to Get Started.

Data can be imported for both new and existing customers in a state different to "PENDING_APPROVAL".

To start importing your clients' data go to Administration > Data. It involves four steps:

1. Set Up Mambu

Create your branches, centers, users, roles, products, custom fields and clients/groups. This setup needs to be done before starting the migration. You'll first have to create the users and give them the proper permissions to access to Mambu, add your organization's branches and the custom fields which  you want to include in the forms and available products (loan and deposits) you offer.

It's important that you do this in advance so that after importing your data to Mambu all clients and groups are already assigned to branches, centres and credit officers; the custom fields are filled for every client; and the accounts are assigned to their products. Not doing this before importing the data will make the whole process much longer and complex since you would have, for instance, to open each client's profile one by one to add the custom fields.

2. Download the Template and Fill in the Data

2.1. Download the Excel template

There you'll find two types of sheets - empty sheets to fill in with data and sheets with data (Clients, Groups, Loan Accounts, Savings Accounts and Chart of Accounts), such as IDs to be used as a reference when filling the others (Branches, Credit Officers, Centres, Loan Products and Savings Products)

The types of sheets can be differentiated by the color of the column titles: the empty sheets have green cells titles and the pre-filled sheets have grey cells titles. The content of both types of sheets is editable.

 The downloaded template can have the only type of extension which is XLSX. No other file extension is allowed, neither upload or download (e.g: XLS format).

2.2. Fill in the Data

The template can be either manually filled from your old system or you can use mapping tools.
Each sheet contains specific field validations (please review the extensive validations) as mandatory fields that cannot be empty, date formats allowed with/without timestamp, a specific length that is allowed and references between entities (e.g. branch-center-client).

For custom fields, validations are based on the type of the custom field:

  • Selection fields: dependent Selection custom fields can only have values from the available options
  • Linked fields: user linked custom fields are referenced with the username of a credit officer, group/client link custom fields are referenced with group/client ID
  • Checkbox fields: can have only two values: true/false.
Custom fields can be seen as required fields or fields that need to have specific pattern or length.

3. Validate the Excel File and import your data

3.1 Validate file (success/ error report)

After all data is in the excel template, it’s ready to be validated. In order to validate the data, Save the excel file filled before -> click on Choose File and choose the file -> click on  Import Data button.

 Until a file is chosen to be uploaded the Import Data button is disabled.

During the import a progress bar is displayed with a percentage of the data that is imported.

If the validation is successful, i.e. if there are no errors in the uploaded file, on the bottom of the screen will be displayed an orange bar which notifies the user that the data migration is in progress.

The status of the uploaded file is Draft during this phase.

No UI action can be performed during the import
This intermediate state before the approval can be used to look at the data uploaded into Mambu and see if everything is working correctly.

After the file is uploaded under ‘Import Events’ section are displayed some information about data from some sheets like how many loan accounts, clients etc. were imported - with two options: Approve and Reject.

All the imported data will be validated only after the data migration process is approved.

In case there are some errors, a notification message will be displayed and an Excel file where are retrieved all  the errors (highlighted in red) and also the comments about the how to fix them are displayed in  ‘Errors’ sheet ’ from the file (the last sheet from the file).

The downloaded error report file can have the only type of extension which is XLSX.

After all errors are corrected the file can be again uploaded to be validated and proceed with the import. After the validation is successfully done a confirmation notification is displayed on the page.

3.2. Import Data (Approve/Reject)

After the import is successfully done user has two options: to approve the import or to reject it. Both actions: approve and import need to be confirmed by the user.

To confirm the import click on Approve Import -> Confirm.

If the import is approved the status of the import changes from Draft to Approved, and all clients and groups are already assigned to branches, centers, and credit officers; the custom fields are filled for every entity, and the accounts are assigned to their products.

The orange bar will disappear from the bottom of the screen, showing that the data migration is now complete.

The data will be permanently stored and will no longer be removable.

3.3 Revert Data Import 

If there are any mistakes while looking at the imported data when the migration is in progress, then data can be reversed by clicking on Reject Import -> Confirm.

After the import is reversed the status of the import changes from Draft to Reverted and all uploaded data is removed from the system.

4. New and changed validations:
  • Loan Accounts state field is case sensitive. The following values are allowed (Pending Approval, Approved, Rejected, Withdrawn, Written Off, Closed, Active) otherwise the account state will be seen as invalid.
  • Date fields support only format dd.MM.yyyy regardless the date format set on the tenant. Any other date format used is considered invalid.

------------------------------------------------------------------------------ Back to top
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found