[CSVUtil] RFC Violation on CSVUtil

Forge Component
Published on 2019-09-28 by Wei Zhu
28 votes
Published on 2019-09-28 by Wei Zhu

Using Outsystems 10 when loading a CSV to a Record List i'm getting this error: 

Only loads 55563 records missing the rest of the file.

Anyone knows the solution?

CSV use comma as separator and use double quotation as escape character. This means

1. If your data field contain separator or CR/LF, you must escape it with double quotation

  Example: aaa,"b1,b2"

2. If your data field contain double quotation, you must use two double quotations (just like Text value in OutSystems )

  Example: aaa,"b1,"",b2"

The error you mentioned means your data contains only one double quotation

  Example: aaa,"b1,",b2"

So you'd better check your CSV file just after 55563 records.

Best Regards