Fixed length flat file processing 4.6 vs 65

, ,
1

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:

<?xml version="1.0"?> 
<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

2

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

3

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