Building the External Data Input File

External means that the input file is not part of the test scripts, but instead is a separate text file(s) that will contain the test data. To construct the input data file, begin by building a generic Excel spreadsheet and laying out the format of the data records. The format is:

  • Each row in the spreadsheet will eventually become a data record in the input file.

  • Each column will become a data field in a given record.

Conversion routines—such as those developed by Andy Tinkham of CWC, Inc., and modified by Archer Group for use with Rational Robot—can be utilized to read the Excel spreadsheet and write the data to rows in a sequential CSV file.

The difference between a generic CSV text file and an SQABasic ...

Get Just Enough Software Test Automation now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.