Enhanced data loading for test management tool

• US 7,761,841 B1
• Filed: 04/29/2005
• Issued: 07/20/2010
• Est. Priority Date: 04/29/2005
• Status: Expired due to Fees

• Current Assignee: Sprint Communications Company LP (Deutsche Telekom AG)
• Original Assignee: Sprint Communications Company LP (Deutsche Telekom AG)
• Inventors: Stuart, Darren C., Rexroad, George L., Thode, James D.
• Primary Examiner(s): Kang; Insun
• Application Number:
  US11/118,732
• Time in Patent Office: 1,908 Days
• Field of Search: 717/125, 717/126
• US Class Current: 717/100
• CPC Class Codes: G06F 11/3688 for test execution, e.g. scheduling of test suites

Abstract

A computer automated method to update a data store is disclosed. The method comprises receiving a definition mapping one or more information fields in an upload file to fields in a data store, creating a first linkage between a test set identified in a first record in the upload file and a first test case based on the mapping, and creating a test set record in the data store including the first linkage and data in the information fields in the first record in the upload file based on the definition.

Claims

1. A computer automated method to update a data store, comprising:

receiving, by a script executed by a spreadsheet application, a test set definition for mapping a plurality of information fields associated with at least a test

set defined as an ordered sequence of test cases and a plurality of test cases in a spreadsheet upload file from the spreadsheet application to fields in a data store of a test management tool, wherein the test management tool does not provide support for uploading the test set from the upload file;

creating, by the script, based on the definition, a plurality of linkages, wherein each linkage is between the test set and one of the plurality of test cases in the upload file; and

creating, by the script, based on the definition, a plurality of test set records for the test set in the data store, wherein each of the plurality of test set records includes one of the plurality of linkages, and wherein the test set is automatically uploaded to the data store by the script when the plurality of test set records for the test set is created.

2. The method of claim 1, wherein the creating the plurality of linkages and the creating the plurality of test set records employ an application programming interface provided by the test management tool.

3. The method of claim 2, wherein the test management tool is a Mercury TestDirector™

and wherein the creating the plurality of linkages includes using the Mercury TestDirector™

TSTestFactory application programming interface.

4. The method of claim 1, wherein the upload file is a Microsoft Excel™

file and the method is initiated by activating a macro selection button in a Microsoft Excel™

control window.

5. The method of claim 1, further including:

creating a second linkage between a requirement in the data store and a second test case; and

creating a requirement-to-test case association record in the data store including the second linkage.

6. The method of claim 5, further comprising:

creating linkages between at least one requirement and a plurality of test cases; and

creating linkages between at least one test case and a plurality of requirements.

7. The method of claim 1, further including:

verifying the definition of the mapping between the plurality of information fields in the upload file and fields in the data store;

generating a report when the verifying fails; and

terminating the method when the verifying fails.

8. An automated test documentation system, comprising:

a data store of a test management tool containing information related to a test set defined as an ordered sequence of test cases and a plurality of test cases, wherein the test management tool does not provide support for uploading the test set from a spreadsheet upload file;

the test management tool stored on a computer readable storage medium and executable by a processor to use the information related to the test set and the plurality of test cases to record progress of a testing project and to generate reports on the testing project;

a spreadsheet application stored on a computer readable storage medium and executable by a processor to define and store a test set definition related to the test set, the test set, and a plurality of test cases in the upload file; and

a script stored on a computer readable storage medium and executable by the spreadsheet application to automatically upload the test set from the upload file to the data store, wherein the script processes the test set definition to create linkages between the test set and the plurality of test cases and to create entries in the data store, each entry containing one of the linkages between the test set and the plurality of test cases;

wherein the test set is automatically uploaded to the data store by the script when the entries are created.

9. The system of claim 8, wherein the test set definition comprises a plurality of rows in a spreadsheet, each of the rows associating one of the plurality of test cases to the test set, thereby defining the test set as composed of one or more test cases.

10. The system of claim 8, wherein the test management tool is a Mercury TestDirector™

.

11. The system of claim 10, wherein the script employs Mercury TestDirector™

application programming interfaces selected from the group consisting of TestFactory, TestSetTreeManager, TestSetFactory, TestSetFolder, TSTestFactory, Customization, CustomizationLists, and CustomizationUsers.

12. The system of claim 8, wherein the script is written using Visual Basic™

.

13. The system of claim 8, wherein the script generates one or more error reports and halts entry creation when a terminal error occurs.

14. The system of claim 8, wherein the data store further contains information about a requirement, wherein the spreadsheet application defines and stores an association between one of the plurality of test cases and the requirement, and wherein the script processes the test set definition to create a linkage between the one of the plurality of test cases and the requirement and to create an entry in the data store containing the linkage between the one of the plurality of test cases and the requirement.

15. A method for building test sets, comprising:

creating a spreadsheet update file using a spreadsheet application, the update file comprising a test set definition, a plurality of information fields containing at least a first test set defined as an ordered sequence of test cases, and a plurality of test cases;

creating, by a script executed by the spreadsheet application, based on the definition related to the first test set, a plurality of records for the first test set in a data store of a test management tool so that the first test set is automatically uploaded from the update file to the data store by the script, each record in the data store storing a linkage, created by the script, between the first test set and one of the plurality of test cases, wherein the test management tool does not provide support for uploading the first test set from the update file;

displaying the linkage between the first test set and the one of the plurality of test cases using the test management tool;

creating a revised update file based on the update file using the spreadsheet application that comprises a plurality of information fields associated with at least a second test set and the plurality of test cases;

creating, by the script, based on a definition related to the second test set, a plurality of records for the second test set in the data store of the test management tool so that the second test set is automatically uploaded from the revised update file to the data store by the script, each record storing a linkage, created by the script, between the second test set and one of the plurality of test cases, wherein the test management tool does not provide support for uploading the second test set from the revised update file; and

displaying the linkage between the second test set and the one of the plurality of test cases using the test management tool;

wherein the first and second test set are automatically uploaded to the data store by the script when the plurality of records for the first and second test set is created.

16. The method of claim 15, further comprising:

creating linkages between at least one requirement in the data store and the plurality of test cases; and

creating linkages between at least one test case and a plurality of requirements in the data store.

17. The method of claim 16, wherein the test management tool is a Mercury TestDirector™

.

18. The method of claim 15, using Microsoft Excel™

to create the update file and the revised update file, and wherein at least some of the records in one of the update file and the revised update file are created by copying and pasting at least portions of other records.

19. The method of claim 15, wherein the creating the records in the data store is performed by Visual Basic™

code.

20. The method of claim 19, wherein the Visual Basic™

code validates that the plurality of test cases are present in the data store and generates an error report when a test case is determined to not be present in the data store.