How can Grid-Tools help to manage your flat file data?
Managing flat file data in integrated systems is one of the most complex problems a tester can face. Datamaker™ provides a complete system to help testers and developers manage these files. Existing files can be quickly used as the basis for creating new versions of the files. The newly created files can be simply updated with more current dates or can be updated to reflect down-stream application requirements.
Quite often production files are used in development to test input processes or to prepare data for testing. These files often fail validation when purchase order numbers do not match, account balances have been reset ... or many other reasons. The ability to quickly manipulate these files will save many hours spent manually editing files or writing code to adjust specific values. Now there is finally a solution to the current struggles testers face when preparing and managing flat files.
Datamaker™ can handle all types of flat file structures, including:
Fixed definition including multi-record types
Tab or other separated
Excel and CSV
Datamaker™ provides a variety of easy-to-use functions to manage flat files including:
Generating synthetic flat files
Storing flat files in a central repository for easy editing
Mass edits of multiple files
Subset selection of records – cut down a file easily while retaining consistency of control totals and checksums
Full version control – if a file structure changes all of the data can quickly be upgraded
Downstream and upstream lookup of values in interdependent applications
Easy masking of data in files – full before and after viewing of masked data
A vast array of data manipulation functions to edit specific columns or calculate derived values such as trailer totals