Imports and Exports Sanity Testing

This page contains Sanity Testing Checklist for Manage Imports and Exports section.

Import transactions

head-master-

archive #1483

Michał S

head-
master-
archive
#1483

Lech R

Comments

Check 'Import transactions' link on Admin page

(tick)(tick)

 

Verify layout on 'Import transactions' page

(tick)(tick)

 

Check if 'Import format' dropdown contains only installed plugins (Audi Bank, MPESA)
(copy both plugins from http://mifos.org/product/download-mifos/plugins to ~/.mifos/plugins)

(tick)(tick)

 

Select Audi Bank plugin and click on Browse button. Verify that file selection window appears.

(tick)(tick)

 

Select inappropriate format file e.g. .pdf and click on Review button. Verify that validation message appears.

(tick)(tick)

 

Select proper .xls file and click on Review button.

(tick)(tick)

 

Page expired error appears during xls file import

(tick)(tick) 
Check how many time takes to import transactions

(tick)

(tick) 

Verify that the following message appears: "No payment type found named 'Bank Audi sal'."

(tick)(tick)

 

Go to 'Define lookup options' page and add 'Bank Audi sal' payment mode.

(tick)(tick)

 

Go back to 'Import transactions' page and select again proper .xls file and click on Review button.

(tick)(tick)

 

Verify that the following message still appears: "No payment type found named 'Bank Audi sal'." because payment mode hasn't been defined on 'Define accepted payment types' page.

(tick)(tick)

 

Go to 'Define accepted payment types' page and add 'Bank Audi sal' payment mode for repayments.

(tick)(tick)

 

Go back to 'Import transactions' page and select again proper .xls file and click on Review button.

(tick)(tick)

 

Verify that file is properly analyzed and errors are listed and displayed in red.

(tick)(tick)

 

Click on 'Edit:Import information' button and select different file. Click on 'Review' button and verify that file is properly analyzed, errors are listed and displayed in red and that values are different from those in first analyzed file.

(tick)(tick)

 

If there are valid rows, submit upload and check if payments are properly applied to appropriate accounts.

(tick)(tick) 

Go back to 'Import transactions' page and select MPESA plugin and click on Browse button. Verify that file selection window appears.

(tick)(tick)

 

Select inappropriate format file e.g. .pdf and click on Review button. Verify that validation message appears.

(tick)(tick)

 

Select proper .xls file and click on Review button.

(tick)(tick)

 

Verify that the following message appears: "Payment type MPESA not found. Have you configured this payment type?."

(tick)(tick)

 

Go to 'Define lookup options' page and add 'MPESA' payment mode.

(tick)(tick)

 

Go back to 'Import transactions' page and select again proper .xls file and click on Review button.

(tick)(tick)

 

Verify that the following message still appears: "Payment type MPESA not found. Have you configured this payment type?." because payment mode hasn't been defined on 'Define accepted payment types' page.

(tick)(tick)

 

Go to 'Define accepted payment types' page and add 'MPESA' payment mode for repayments and disbursements.(tick)(tick) 
Go back to 'Import transactions' page and select again proper .xls file and click on Review button.(tick)(tick) 
Verify that file is properly analyzed and errors are listed and displayed in red.(tick)(tick) 
Click on 'Edit:Import information' button and select different file. Click on 'Review' button and verify that file is properly analyzed, errors are listed and displayed in red and that values are different from those in first analyzed file.(tick)(tick) 
If there are valid rows, submit upload and check if payments are properly applied to appropriate accounts and that appropriate accounts are disbursed.(tick)(tick) 

If imported transactions were adjusted/modified manually on the account then it should't be possible to undo those transactions via Undo imported files functionality

(tick)(tick) 
Verify 'Add the possibility to import new Loans data' (MIFOS-5661) (tick) 
Verify 'Add the possibility to import new Savings data' (MIFOS-5663)(tick)(tick)Does not stop at the first empty row, the last error is: Error in row 65536, Column 2: Customer global id cannot be null or empty
Verify 'Unable to import clients via Client Data Import when extended Family Details are enabled' (MIFOS-5706) (tick)if adding client to a group, meeting options cannot be specified ("Meeting options are not allowed for a client being added to a group"), but they have to be ("Incomplete meeting data")
Verify 'Customer meeting schedule is not generated for Clients created via Client Data Import' (MIFOS-5705) (tick) 
Verify if it is possible to set customer activation date during Client data import (MIFOS-5755)(tick)(tick) 
View Accounting Exports

head-master-

archive #1483

Michał S

head-
master-
archive
#1483

Lech R

Comments
Check 'View accounting exports' link on Admin page.(tick)(tick) 
Check layout on 'View accounting exports' page.(tick)(tick) 
Verify how fast page is loading. (MIFOS-5806)(tick)(tick)page loads reasonably quickly, but generating a report takes a few minutes with a large database
Verify that 10 days are listed in the table (if there are less than 10 days with transactions then only those days should be listed)(tick)(tick) 
Check that only days on which transaction took place are listed in the table.(tick)(tick) 
Click on 'Generate Export and View Details' link and verify that Mifos Accounting Export page is properly displayed.(tick)(tick) 
Verify that 'Download Tally XML format' link and 'Print' link are displayed and work properly.(tick)(tick) 
Check if amount for GLIM account is not doubled (if there are 2 clients in GLIM) MIFOS-5638 (tick) 
Check (on database which exists more than 1000 days) if results are displayed properly on 'View accounting exports' page MIFOS-5687 (tick) 
Download XML file and check if Voucher Date is not set to always the same date (tick) 
Check if after migration from Mifos 2.1.x all transactions are listed in XML file in current Mifos release (tick) 
Templates
 

head-
master-
archive
#1483

Lech R

comment
Verify 'It is impossible to download report template.' (MIFOS-5746)(tick)(tick) 
   Â