Method and device for converting Excel format testing case into XML (extensive markup language) format

A test case and excel technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of manual difficult test cases, low efficiency, low work efficiency, etc., and achieve the effect of convenient use case maintenance

Inactive Publication Date: 2014-11-19

FUJIAN STAR NET EVIDEO INFORMATION SYST CO LTD

1 Cites 16 Cited by

AI-Extracted Technical Summary

Problems solved by technology

[0002] At present, the operation of creating and maintaining test cases using test case management tools is relatively cumbersome. Employees can only input test cases one by one. When modifying use cases, they also modify them one by one. The work efficiency is low. Some test case management tools only support importing. Use cases in XML format, and artificially writing test cases in XML format is very cumbersome and prone to problems. For example, the current open source test case management tool Testlink has the following shortcomings in the proces...

Abstract

The invention provides a method for converting an Excel format testing case into an XML (extensive markup language) format. The method comprises the following steps of establishing a testing case template of an Excel format; filling information data of a testing case in the testing case template; analyzing XML format requirements on importation of the testing case by using a testing case management tool; corresponding contents of an Excel form to various nodes in XML one by one; selecting a range in which the information data of the testing case are required to be exported in the testing case template of the Excel format; and generating an XML file by using the information data in the range according to the requirements on the XML format. The invention also provides a device for converting the Excel format testing case into the XML format. The efficiency is improved; and the labor cost is reduced.

Application Domain

Special data processing applications

Technology Topic

Test caseInformation data +3

Image

Examples

Experimental program(1)

Example Embodiment

[0028] Such as figure 1 As shown, the method of the present invention for converting Excel format test cases into XML format includes the following steps:

[0029] Step 10. Establish a test case template in Excel format, and fill in the test case information data in the test case template. The test case information data includes: test subsystem name, sub-module name, test case name, test type, Priority, summary, premise, operation steps, and expected result information, the Excel format is ".xls" format or ".et" format;

[0030] Step 11. Set the save path of the generated Xml file.

[0031] Step 20: Analyze the XML format requirements of the test case management tool to import the test case, and make a one-to-one correspondence between the test case information data written in the Excel table and each node in the XML;

[0032] Correspondence, for example: the "test subsystem name" column in the Excel test case template corresponds to the "testsuite" node of the Xml file, the "submodule name" column corresponds to the "testcase" node of the Xml file, and the "test case name" column corresponds to Go to the "name" node of the Xml file, the "operation step" column corresponds to the "actions" node of the Xml file, and the "expected result" column corresponds to the "expectedresults" node of the Xml file. The corresponding operations for the other columns are similar, that is, the Excel table The columns inside correspond to the relevant nodes of Xml.

[0033] Step 30. According to the scope of the test case information data to be exported in the selected Excel format test case template, extract the required test case information data from the Excel table, and generate an XML file according to the XML format requirements of the use case import of the use case management tool. Then, write the retrieved test case data into the corresponding node in the XML file, and save it according to the save path generated in step 11.

[0034] Examples of selected use case scope: For example, if 20 test cases are established in the test case template, you can select the 5th to 15th test cases to export.

[0035] Such as figure 2 As shown, the device of the present invention for converting Excel format test cases into XML format includes the following modules:

[0036] The information setting module establishes a test case template in Excel format, and fills the test case information data into the test case template. The test case information data includes: test subsystem name, sub-module name, test case name, test type , Priority, summary, premise, operation steps, and expected result information, the Excel format is ".xls" format or ".et" format;

[0037] Save path module, set the save path of the generated XML file;

[0038] Analyze the corresponding module, analyze the XML format requirements of the test case management tool to import the use case, and make a one-to-one correspondence between the test case information data written in the Excel table and each node in the XML;

[0039] Read and generate XML file module, export the range of test case information data selected in the Excel format test case template, and write the information data in the range into the XML file according to the XML format requirements imported by the analysis test case management tool In the corresponding node, an XML file is generated, and the XML file is saved according to the save path generated by the save path module.

[0040] The present invention has the following advantages: the present invention is a method and device for converting Excel format test cases to XML format, which can easily convert Excel format test cases to Xml format, which improves our test case design and test case import Efficiency: When the test case content needs to be modified in batches, you can make batch modifications in the test case template, and then convert it to Xml format through batch conversion and import it uniformly, which greatly improves maintenance efficiency and facilitates our subsequent use case maintenance.

[0041] Although the specific embodiments of the present invention are described above, those skilled in the art should understand that the specific embodiments described by us are only illustrative and not intended to limit the scope of the present invention. The equivalent modifications and changes made by the technicians in accordance with the spirit of the present invention should all be covered by the scope of protection of the claims of the present invention.

PUM

Description & Claims & Application Information

We can also present the details of the Description, Claims and Application information to help users get a comprehensive understanding of the technical details of the patent, such as background art, summary of invention, brief description of drawings, description of embodiments, and other original content. On the other hand, users can also determine the specific scope of protection of the technology through the list of claims; as well as understand the changes in the life cycle of the technology with the presentation of the patent timeline. Login to view more.