Skip to Content
Former Member
Oct 19, 2016 at 12:58 PM

File-Content-Convesion, File-Adapter, PI, 7.4 Single Stack



We are using a simple file-sender channel with content conversion (FCC, from a csv-file).
This is a small example input file:


As you can see, there is a field delimiter (^) and the field lengths vary, as expected using csv.
So any fixed-field-length stuff is off the table.

Therefore Recordset-Structure is defined as: DATA,*,FOOTER,1

This blog here
seems to adress the problem, but whenever I leave out the keyFieldValue for the DATA-Lines, I can't even start the channel without getting an error. java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:
Mandatory parameter 'DATA.keyFieldValue': no value found

Problem being, that the content of the key field (DATA.field#1) does also vary (as all other fields will) and the FCC parameter [NODE].keyFieldValue does not seem to have any wildcard or regex-magic.

How can I force the FCC to collect all sets that start with a number, or even a digit, or do not start with an E, or whatever comes to mind.

Best Regards