Spreadsheet-Based Test Script Configuration for Automation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for testing webpage and native application functionality require specialized automation tools and scripting languages, leading to increased time and costs due to the complexity of automation testing, which delays the time to market for new functionalities.
Innovation Solution
An automated testing system utilizing spreadsheets driven by a test execution engine, allowing testers with limited knowledge of advanced scripting languages to execute test scripts across multiple browsers and platforms, with features like screenshot capture and upload to quality center upon failure, and integration with HP Quality Center for test management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If specialized automation tools and scripting languages are used for testing, then testing reliability is improved, but device complexity and ease of operation deteriorate
Solution Approach 1:
The patent introduces an intermediary layer between the tester and the automation testing system. This intermediary is a spreadsheet-based configuration interface that translates simple spreadsheet entries into complex automation test scripts. The spreadsheet acts as a mediator that hides the complexity of scripting languages and automation tools while maintaining their powerful testing capabilities, thus improving reliability without increasing the perceived complexity for the end user.
2Measurement precision
If specialized scripting languages are used for automation testing, then testing precision is improved, but ease of operation deteriorates
Solution Approach 1:
The patent uses spreadsheets as a simplified copy or representation of the actual automation test execution environment. Instead of requiring users to directly manipulate complex scripting languages, the system allows them to work with a spreadsheet copy that mirrors the test structure. This spreadsheet copy can then be automatically translated into the precise automation scripts needed for accurate testing, maintaining precision while dramatically improving ease of operation.
3Adaptability or versatility
If manual documentation of automation scripts is performed, then adaptability is improved, but productivity deteriorates
Solution Approach 1:
The system implements self-service automation where the spreadsheet configuration automatically generates and executes the test scripts without requiring manual documentation. The spreadsheet structure itself serves as both the configuration interface and the source code, eliminating the need for separate documentation steps. This self-service approach maintains adaptability through flexible spreadsheet editing while dramatically improving productivity by removing the time-consuming manual documentation process.
Data Source
AI summary
A test script may be written in a test script configuration spreadsheet. A plurality of test scripts may be listed in a test suite spreadsheet. A user may hit a run key to execute all or any subset of the test scripts listed in the test suite spreadsheet. A test engine may read the test suite spreadsheet and the test script configuration spreadsheets to execute the test scripts on any platform or browser specified by the test suite spreadsheet.


