Anyone have a Build Acceptance Test Improvement Request Form?
I was thinking something like this, but not sure of the best way to implement it. I was wondering if somebody has something better than an Excel spreadsheet in a shared directory on the local network? Looking for suggestions...
Description of Request | Test Script Name | Requestor | Assigned To | Estimated Completion Date | Comments
Re: Anyone have a Build Acceptance Test Improvement Request Form?
I could not believe that I could not find a test tracking database utility out there! I googled and wiki'ed with no luck. However, I strongly recommend NOT to use a shared spreadsheet. Locking and timing issues compared to a database make it ungainly once you get over two or three people.
Each time I have needed a test or bug tracking utility, I have built it myself.
I suggest instead that you consider a simple database implementation, with two separate tables. The last time I implemented this was for a Session Based Testing database, in two parts.
The Test Case Table:
Original Author: (your Requestor, I guess)
Current Contact: (your Assigned To, I guess)
Purpose: (short description for summary queries)
Description of Request: (from your list)
Reason: (previously found bug with number, test case number, regression, AdHoc)
Step/Expected Result Pair: (additive, 1..n)
Expected Completion date: (from your list)
The Test Results Table:
Test Case: (the tie in to the table above)
Test Number: (autofill)
Pass/Fail Result: (one for each step in Test Case Table)
Comments on Result: (one for each step in Test Case Table, not just for the failed conditions)
Overall Pass/Fail Result:
External Tracker Number: (other number for failed tests to tie to.)
That way, you can run test cases more than once without having to repeat the description and name in your columns. The implementation is fairly simple, and most DBs offer simple front end forms to fill the data. Plus, since most of the usage will be adding info rather than querying and editing existing items, a DB is much cleaner than a spreadsheet for these purposes.