...
FR# | Pri | Description | Comments / Mockups |
---|---|---|---|
1.1 | P1 | M-PESA is an Excel format (97) | Check if CSV (XML) will work |
1.2 | P1 | M-PESA import file first few lines contain description of file. These are to be ignored. Only data after row of column headings will be imported in the Transactions section. |
|
1.3 | P1 | Import file will have columns in below table |
|
1.4 | P1 | There will be error checking - to successfully import the data. |
|
1.5 | P1 | If a row contains a cell that's missing a required field, Mifos displays an error message for each row this occurs. Only check the rows where Status is Completed. |
|
1.6 |
| When importing, must check to see if Receipt ID already exists in any transaction in Mifos - if YES, then ignore the row and |
|
1.7 | P1 | Dates are in the format YYYY-MM-DD HH:MM:ss. If any value under Date column does not start in format of YYYY-MM-DD, then Mifos displays an error message for each row this occurs. |
|
1.8 | P1 | Compare Other Party Info must be imported. - Take first 10 digits as phone number, and compare with Client's Phone Number fields in Mifos. If there is not a match, then ignore the row and |
|
1.9 | P1 | Changes to Transaction Party Details - no more taking of National ID - remove this functionality. Compare first code listed (before first space) with any loan or savings product in Mifos. If the code exists, import that whole transaction amount to the account associated with that code. Otherwise, ignore what's in the field. |
|
1.10 | P1 | See FR 4.9 for additional error message errors to check for. | |
1.11 | P1 | Check that Status column says "Completed". If it has any other status, Mifos throws the following message: |
|
1.12 | P1 | Check if the same file name has been imported. If so, then throw an error message and reject the whole import. |
|
1.13 | P1 | After clicking on Continue, Mifos will display the Review & Submit screen with the following: | See below FR#7 for additional changes |
1.14 | P1 | User can then either
|
|
1.15 | P1 | If User clicks on Submit, Mifos imports the file and displays confirmation screen |
|
1.16 | P1 | There is no option to revert a file upload once it has been submitted. |
|
1.17 | P1 | Currency of values imported is directly inherited from the loan product that the loan account is mapped to. |
|
1.18 | P1 | If there are no rows found with import data, the following error message should be thrown: |
|
...
Column Name | Required | Description | Comments | Validations | Range | Example | Maps to Mifos |
---|---|---|---|---|---|---|---|
Receipt | Yes | Receipt ID is proof of payment and a unique MPESA identifier that can be cross-reference with clients phone receipt. Need to be imported into Mifos since needed in the KEEF Collection Sheet. | Receipt ID is exclusive to MPESA | Check that there is not an existing RECEIPT ID | Alphanumeric | Y29DW127 | Transaction Details - Receipt ID |
Date | Yes | Payment date |
| Validate date is in range (see above) | YYYY-MM-DD time | 2009-08-26 12:39:42 | Transaction Date |
Details | No | Contains information payment received from phone number, telephone number, MFI account number | Ignore |
|
|
|
|
Status | Yes | Completed | Check that Status says Completed. | Must be Completed to accept row. Other statuses throw an error | Completed, Attempted, Cancelled, Declined | Completed |
|
Withdrawn | No | Amount paid from MFI | Only use for Disbursals, Phase 2 |
|
| 00 |
|
Paid In | Yes | Transaction amount paid to MFI |
| Validate it's an amount and check same validations in Mifos against digits after decimal | Should be digits after decimal = 0 | 200 | Transaction amount |
Balance | No | Balance of MFI | Ignore |
|
| 520,499 |
|
Balance Confirmed | No | automatic check in system | Ignore |
|
| true |
|
Transaction Type | No |
| Ignore |
|
| Pay Utility |
|
Other Party Info | Yes | Safaricom generated phone number and name associated with phone number | Compare first 10 digits to phone number. If none exists, throw error. This will be used to identify where the transaction goes. | First 10 digits must correspond to a Phone Number | Numeric | 0722926212 - CYNTHIA OMONDI | Phone Number |
Transaction Party Details | Optional | Will include Mifos Product Code if there is one, and other information such as Client's Group ID, etc | We will use this to include short names) of product(s) applied to the client's accounts if it is different than the default order set in ImportTransactionOrder | Validate 3-4 letter codes (everything before first space) corresponds to a loan or savings product in Mifos | Mifos product codes | SP1 | Savings Product 1 |
...