I have a FlatFile Schema that was working in UAT on this project I’m on. Files were being downloaded from the Bank and the flatfile was being converted to an iData Doc with all records accounted for. The Schema was Record Delimited “CRLF”. Then during further UAT testing today, the files downloaded from the Bank were being truncated by the convertToValues service (in that only the Header record was being parsed and any subsequent Detail or Trailer records were being dropped). isValid was returning “true” from convertToValues and no errors were returned.
After playing around a bit, I changed the Record Delimiter to "Newline" and everything started working again ??? Does anyone know of any outstanding issues with the Record Delimiter in FlatFile Schemas and what it's set to (either "CRLF" or "Newline") ??