Registering a G-T Excel format file results in table definitions that ignore the format field

Document ID : KB000125591
Last Modified Date : 31/01/2019
Show Technical Document Details
Issue:
Are there any examples for these or better documentation of the GT-Excel layout? I am trying to use a G-T Excel format xls file to define a file format that has a header/detail/trailer fixed format. We have used these in the past. But now when I register one of these files as an object - it seems to ignore the format column (a/an/n for alpha/alphanumeric/numeric) - and sets all columns to be numeric.
Environment:
TDM Portal 4.7
Resolution:
The parsing and the formats that can be used in GT-Excel format column are:
a - VARCHAR
n - NUMERIC
d - DATE
There's no alphanumeric format there. The attached file works.
Additional Information:
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://comm.support.ca.com/kb/How-to-Download-Test-Data-Manager/KB000009671.  To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html
File Attachments:
DegreeFields_fixed3.xls