Not able to register GTEXCEL file with the required column

book

Article ID: 224561

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Generate synthetic data for Fixed width File 
 
Steps followed:
  • Created GTExcel with Header_Record, Data_Record, Trailer_Record as per file specifications. 
  • Register using portal/ GTdatamaker
  • Create Generator
  • Write generation logic.
  • Publish it.
Issue:
  • Unable to register GTExcel from TDM portal.
  • When registered through GtDatamaker, I could find Header & Trailer specification with all columns, but Data_record/body specification columns are missing from the registered object.
 

Environment

Release : 4.9.1

Component :

Resolution

There are two changes required in file:

1)   Record length positions you have started from 0. Please change it from 1.

2)  In data records, header titles includes underscore (_). Remove underscore and replace it with space. Ex: Field_Name with "Field Name" and Column_Name with "Column Name" etc.