Hello Garry,
I apologize for the late reply (although it looks like you had sent this
quite a long time ago, but only got delivered a few days ago).
Reading over this, this looks more like your validations for your upcoming
data migrations? Is that correct? If so, we are close to putting all of
our data migration validation plans together, at which point I can share
with you some of the reports/tests we plan on running.
Otherwise, this looks like a good strategy although I would be interested to
know what exact reports you¹ll be using for your validation? Can you be a
bit more specific about this?
Another thing you might consider is determining all the different states of
the data, finding examples of each and comparing those against each other.
Ie, for a customer you might find examples for: Active, Blacklisted,
Closed, Active with an Active Group Loan, Active with a Active Individual
Loan, etc.
Just to be clear though I would not consider this an ³UAT², or at least how
we¹ve been using the term here at Mifos. We use UATs (ie, User Acceptance
Tests for anyone unfamiliar with the term) for having the client verify that
Mifos works as expected and there are no major issues (either in the form of
bugs or problems integrating with their processes). For example, at ENDA we
created a suite of tests for each role, covering all the major actions they
might take.
Ryan
On 9/26/08 5:56 AM, "Garry Blanco" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am currently involved in one of Grameen's Mifos v1.1 lighthouse in the
> Philippines. We are about to conduct the UAT with SECDEP (MFI). I am seeking
> advice or suggestion with our UAT. It will also be great if somebody could
> share us their existing work on Mifos UAT/test script so we would have basis.
> Anyways, here is the test plan & test script that we have prepared:
>
> --- TEST PLAN ---
> Database
> 1. Check data integrity (Source Data vs. Mifos Database) like format, type,
> value and length
> 2.
> 3. Verify referential integrity of linked tables
> 4.
> 5. Confirm number of records migrated.
> 6.
> 7. Benchmark speed of data transfer.
>
> User Interface
> 1.
> 2. Check if migrated data appears in the right field of the web page/s.
> 3.
> 4. Verify that all Look-Ups are properly populated like user title and
> educational level.
> 5.
> 6. Verify if items and its dependencies are properly placed or linked to each
> other like center and groups.
> 7.
> 8. Confirm that migrated data contains the complete set of information like
> list of barangays.
> 9.
> 10. Validate that information corresponds to its parent data like client data.
>
> Reports
> 1.
> 2. Check if mapped data falls in the right column of the report.
> 3.
> 4. Verify accuracy of value shown/printed in the report.
> 5.
> 6. Confirm report consistency of retrieved information.
>
> Output:
> 1.
> 2. Create the following listing by extracting the items from the Mifos
> database and have them signed by the SECDEP:
>> *
>> * Grouping will contain branch, center, loan officer and group information.
>> *
>> * Loans product will contain Product Category, Loan Product Details, Loan
>> Amount, Interest Rate, Repayment Schedule, Fees and Accounting.
>> *
>> * Savings product will contain Product Category, Saving Product Detail,
>> Targeted Deposits and Withdrawal Restriction, Interest Rate and Accounting.
>> *
>> * Other Look-Ups (Fees, Funds, Checklist, Holidays, Salutation, User title,
>> Marital status, Educational level, Religion, Business activity, Purpose of
>> loan, Officer title)
> 3.
> 4. Test Script
>
> --- TEST SCRIPT ---
>
>
>
>
> Database
> 1.
> 2. Does the data transferred to Mifos the same with the source data?
> 3.
> 4. Will you rate the speed of the data transfer? 1-lowest, 10-highest.
> 5.
> 6. Does the total counts of records migrated in the database equal the total
> counts of records in the migration template?
>
>
>
> MIFOS User Interface
> 1.
> 2. Is Mifos (database & application UI) configured in accordance to your
> specifications?
> 3.
> 4. Does the information of data correspond to its parent data? Ex. Client and
> Groups
> 5.
> 6. Does the data shown falls in the right fields?
> 7.
> 8. Are all look-ups populated properly? Ex. barangay, Munipality/City
> 9.
> 10. Does the migrated data contain the complete set of information?
> 11.
> 12. Are all functions and features described in walkthrough operational?
> 13.
> 14. Does the client registration date <= savings/loans start date?
> 15.
> 16. Does the items and its dependencies are properly placed or linked to each
> other?
> 17.
> 18. Does the data mapped to destination accordingly?
>
>
>
> Reports
> 1.
> 2. Does the data falls in the right column of the report?
> 3.
> 4. Does the report show the accurate value in the report?
> 5.
> 6. Are the formula used in the reports corresponds to what is currently being
> used by your organization?
> 7.
> 8. Does the speed of retrieving report fast? 1-lowest, 10-highest?
>
> ---
>
>
> Thanks,
>
> Garry Blanco
> Office: 8960735
> Mobile: +639063266986 / +639228286102 / +639178602002
> Yahoo: [EMAIL PROTECTED]
>
>
>
>
> New Email addresses available on Yahoo!
> <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http://mail.promo
> tions.yahoo.com/newdomains/aa/>
> Get the Email name you've always wanted on the new @ymail and @rocketmail.
> Hurry before someone else does!
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>
> _______________________________________________
> Mifos-functional mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-functional
Ryan Whitney
Mifos Technical Program Manager
[EMAIL PROTECTED]
Mifos - Technology that Empowers Microfinance (www.mifos.org)
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Mifos-functional mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-functional
