I have a service in 4.6 that processes a fixed length flat file service using a template. I’m now using 6.5 and I need to upgrade to a flat file schema and can’t get the convertToValues service to work correctly. I think the problem is with my flat file schema I created.

The template I was using in 4.6 is:

<Positional>
<SEGMENT-DELIMITER>
<FIXED></FIXED>
<KEYWORD></KEYWORD>
<OFFSET>51</OFFSET>
</SEGMENT-DELIMITER>
<FIELD-DELIMITER>
<FIXED></FIXED>
<KEYWORD></KEYWORD>
<OFFSET></OFFSET>
</FIELD-DELIMITER>
<SUB-FIELD-DELIMITER>
<FIXED></FIXED>
<KEYWORD></KEYWORD>
<OFFSET></OFFSET>
</SUB-FIELD-DELIMITER>
<SEGMENT ID="recordWithNoID">
<POSITION NAME="Function" START="0" LENGTH="4"/>
<POSITION NAME="Date" START="4" LENGTH="8"/>
<POSITION NAME="Time" START="12" LENGTH="6"/>
<POSITION NAME="RailCarNumber" START="18" LENGTH="10"/>
<POSITION NAME="EL_Status" START="28" LENGTH="1"/>
<POSITION NAME="Material" START="29" LENGTH="10"/>
<POSITION NAME="Destination" START="39" LENGTH="10"/>
<POSITION NAME="AEI_ReaderID" START="49" LENGTH="2"/>
</SEGMENT>
<LOOP START="recordWithNoID" />
</Positional>

In 6.5 what do I specify as the Record Definition name as the first character of the fixed length string can be anything? I’m able to set the field definitions but I can’t figure out what to name my record definition.

Here is a sample string that I need to parse using the template above:

LESC09012006032100ITLX40210 L281232200499981 XXLESC09012006032100USLX20511 L281232200499981 XX
TLP 09012006035800ITLX40115 L281232200199981 XXTLP 09012006035800PLCX21812 L281232200199981 XX
TLP 09012006035800ITLX40055 L281232200199981 XXTLP 09012006035800ITLX40048 L281232200099981 XX
TLP 09012006035800PLCX18191 L281232200199981 XX

Thanks

Kevin,

If you dont have any Record Identifier in your flatfile…then set
“recordWithNoID” as the Record Definition in the FFSChema…and create the field definitions accordingly and test it.

HTH,
RMG

RMG,

Thanks for your suggestion it helped. I eventually fixed this by creating a FF Dictonary for a recordWithNoID. I created the dictonary and added the dictonary record to my schema as the Default Record. Once I did this the convertToValues worked correctly.

Thanks,

Kevin