Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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
View PDF1 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI 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 process of use in the industry: it only supports test cases in XML format Import, and it is difficult to manually design test cases in XML format; if you do not use the use case import function, directly create a new test case in the Testlink tool, the efficiency is very low; use the manually created test cases in Testlink, the exported format is limited, which is not convenient for test cases The review operation; the use case maintenance in Testlink is also more troublesome, it will be more convenient if the function can be imported through the use case

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for converting Excel format testing case into XML (extensive markup language) format
  • Method and device for converting Excel format testing case into XML (extensive markup language) format

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Such as figure 1 Shown, the present invention converts the Excel format test case to the method for XML format, comprises the steps:

[0029] Step 10, set up the test case template of Excel format, and fill in the test case information data in the described test case template, the described test case information data includes: test subsystem name, submodule name, test case name, test type, Priority, summary, premise, operation steps, expected result information, the Excel format is ".xls" format or ".et" format;

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

[0031] Step 20, 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;

[0032] For example, the "test subsystem name" column in the Excel test case template corresponds to the "testsuite" node in the Xml file, the "submodule name...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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.

Description

technical field [0001] The invention relates to a method and a device for converting an Excel format test case into an XML format. Background technique [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 process of use in the industry: it only supports test cases in XML format Import, and it is difficult to manually design test cases in XML format; if you do not use the use case import function, directly create a new test case in the Testlink tool, the efficiency is very low; use the ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/22
Inventor 钟国辉
Owner FUJIAN STAR NET EVIDEO INFORMATION SYST CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com