Spreadsheet-Based Test Script Automation for Web Applications
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current systems for testing web applications are laborious, time-consuming, and require programming skills, and they lack the ability to dynamically define test plans, store results for future use, and compare test results throughout an application's lifespan.
Innovation Solution
A system and method that includes a test control module for creating test plans and scripts, and a testing tool that interacts with the application to conduct tests, enabling dynamic definition of objects and parameters, and storing test results for comparative analysis, using a spreadsheet interface to simplify data entry and presentation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual code input and navigation steps are used to test application objects, then testing coverage can be achieved, but the process becomes laborious and time-consuming
Solution Approach 1:
The system enables testers to define test plans and scripts without programming skills by providing a spreadsheet interface that automatically generates test code and executes tests, allowing the testing system to serve itself rather than requiring manual programming intervention
Solution Approach 2:
The patent replaces manual mechanical coding and test execution with an automated system that uses spreadsheet data to generate and execute test scripts, substituting the mechanical process of manual code input with an automated information processing system
2Reliability
If existing testing tools are used to identify application flaws, then testing can be performed, but the ability to dynamically define test plans and store results for future comparison is lacking
Solution Approach 1:
The system allows test plans and scripts to be dynamically defined and modified through spreadsheet input, enabling flexible adaptation to changing application requirements while maintaining the ability to store and compare results over time
Solution Approach 2:
The testing system provides multiple functions including dynamic test plan creation, result storage, baseline establishment, and regression testing through a single unified platform that accepts spreadsheet input, making it versatile for various testing scenarios
3Ease of operation
If spreadsheet interface is used for data entry, then programming knowledge is not required, but the system must convert data between formats
Solution Approach 1:
The system introduces an intermediary conversion layer that translates spreadsheet data into test execution formats and vice versa, allowing users to work with familiar spreadsheet interfaces while the system handles the complexity of format conversion automatically
Data Source
AI summary
A system and method for testing at least one application is provided. The system comprises a test plan or script creation module for enabling a user to create at least one test plan or script for use in testing the at least one application. The system also comprises a test results module for initiating and determining test results associated with testing of the at least one application according to the at least one test plan or script. In some embodiments, the test results module determines: (1) baseline test results achieved by resolving the at least one test plan or script against the at least one application prior to the application being put to actual use, and (2) dynamic test results achieved by resolving the at least one test plan or script against the at least one application after the at least one application has been put to actual use. The system may also include a comparison module for comparing the dynamic test results with the baseline test results.