@mdione @RussEby Marcos, don't be that guy... People have to work around stuff they have little control over and had no choice having to use most of the time. I can imagine why an old ERP is not expecting "empty" comma filled lines, and then, some "dev around ERPs" stuff I've seen is like adversarial adaptations, because the ERP vendor doesn't want you to integrate freely with it.
@vdd @mdione @RussEby ERP != CRM... and "should" to our benefit, surely... As I said, ERP vendors usually don't want interoperability, they want to sell you "another module"
Curious, what is ETL?
Most of my CSVs, I create using Python and don't have issues.
Where the problem comes up is when others are trying to load a CSV and it shows 400 'failures' out of 900 and they were only trying to load 500 rows.
I have to explain that the 'failures' are the empty rows and can be ignored. Unless some of the records did fail and then I need to filter the results for them so they can corrected and reuploaded.