-
Notifications
You must be signed in to change notification settings - Fork 84
Home
-
Download template.
-
Open the downloaded template.
-
Enter the required data.
-
Upload the entered data.
-
In case of erroneous entries in some rows.
-
See the error report, fix it and re-upload.
After the tool gets up and running, here is a sample workflow :-
- Enter your offices and staff through the UI provided with MifosX.
- Import clients.
- Import groups and meetings.
- Enter your Currency Configuration, Funds, Charges, Loan Product configuration (Administration -> Organisation) and Payment Types (Administration -> System -> View Code ->Add/Edit Code Value) through the UI.
- Import loans along with approval and disbursement information. For quick import of outstanding balances, enter the total amount repaid in this workbook or proceed to next step for maintaining complete repayment history.
- (Optional) Import complete loan repayment history.
- Enter your Savings Product configuration (Administration -> Organisation) through the UI.
- Import savings accounts along with approval and activation information. For quick import of current balances of each savings account, enter the current balance as Minimum Required Opening Balance or proceed to next step to maintain complete transaction history.
- (Optional) Import complete savings transaction history.
-
Default entries to fields in loan and savings import worksheets are set for the first 1000 rows. After that data validation rules still apply, but default filling of fields on selecting the product does not work.
-
The group import sheet format right now has a maximum upper limit of 100 clients per group.
-
Special characters in names (such as office name, client name, staff name, loan product name) will break the naming conventions used in Excel and no data can be entered which refers to these names.
-
In some cases, where the name itself starts with a number or special character, the template cannot be generated and results in a download error.
Changes in MifosX at these endpoints might directly affect the fuctionality of the tool:-
- /offices
- /staff
- /clients
- /loanproducts
- /funds
- /codes/12/codevalues
- /loans
- /loans/{loanId}?command=approve
- /loans/{loanId}?command=disburse
- /loans/{loanId}/transactions?command=repayment
- /savingsproducts
- /savingsaccounts
- /savingsaccounts/{savingsId}?command=approve
- /savingsaccounts/{savingsId}?command=activate
- /savingsaccounts/{savingsId}/transactions?command={withdrawal/deposit}
- /groups
- /groups/{groupId}/calendars
-
Import Class Diagram.
-
Sample Import Sequence Diagram.
-
Populator Class Diagram.
-
Sample Populate Sequence Diagram.
-
Populator DTOs diagram.