Log in to AnswerLog in to Follow
2021-02-18 14-38-44
tcastanho
80Views
6Comments
[CSVUtil] RFC Violation on CSVUtil
Question
Data
Forge
csvutil
Service icon
CSVUtil
Forge component 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?

0
0
23 Dec 2019

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

Wei

0
0
28 Dec 2019

I have the same issue, and corrected by formating the line like this:

aaa, "LCD 27"" 4K", bbb

It works, but we get - LCD 27"" 4K - as the value of the second column. I was expecting the extension to revert the "" to ". Do we need to take care of that?

Regards,
Carlos

0
0
07 Jan 2021

I had try the data you mentioned  and get [LCD 27" 4K] as expected.



It seems there a space before double quotation in your data.
So i guess this is problem, because first character of the field should be double quotation if you need  escape that field,



0
0
08 Jan 2021

Replying to Wei Zhu's comment on 08 Jan 2021 01:55:20

This was just an example, I don't have any space in my data. I just format like this in the comment for better reading.

I did try your sample just like you did, and it worked just fine, but in our code, we get the "" instead of ". Can you please check that you don't do any replace in your Demo to correct the ".

Thanks,
Carlos

0
0
08 Jan 2021

Replying to Carlos Oliveira's comment on 08 Jan 2021 16:27:12

Please provide the OML and your CSV data.
So i can check what is the problem.

Regards
Wei

0
0
12 Jan 2021

Replying to Wei Zhu's comment on 12 Jan 2021 11:36:42

Thanks for you time and support,
Just check and the quotes are correct! Very strange, but prety sure it was something we did.

0
0
12 Jan 2021
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.