ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Not able to register GTEXCEL file with the required column


Article ID: 224561


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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.
  • 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.


Release : 4.9.1

Component :


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.