Spreadsheet-Based Test Script Configuration for Automation

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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

VSEngineering 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

Engineering Contradiction:
Improvetesting reliabilityVSAvoidautomation testing complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

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.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Measurement precision

If specialized scripting languages are used for automation testing, then testing precision is improved, but ease of operation deteriorates

Engineering Contradiction:
Improvetesting precisionVSAvoidease of operation
Core Design Contradiction:
Measurement precisionVSEase of operation

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.

Inventive Principle:
Principle #26Copying

3Adaptability or versatility

If manual documentation of automation scripts is performed, then adaptability is improved, but productivity deteriorates

Engineering Contradiction:
Improvetesting adaptabilityVSAvoidtesting productivity
Core Design Contradiction:
Adaptability or versatilityVSProductivity

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.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS10083111B2Test script configuration spreadsheet
Publication Date: 2018.09.25 AMERICAN EXPRESS TRAVEL RELATED SERVICES CO INC
  • US10083111B2 patent drawing
  • US10083111B2 patent drawing
  • US10083111B2 patent drawing

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.