RE: Diyotta is using Bulk API V1(Bulk V1) to load salesforce data which supports only comma delimited files
Diyotta is using Bulk API V1(Bulk V1) to load salesforce data which supports only comma delimited files. The source file contains special characters(Single quotes, double quotes, comma and new line characters) so we are replacing these special chars before loading it to salesforce.
Source Database is DENTRIX
processing platform is Postgresql.
Target Database is Salesforce
How do we overcome these data load issues??
Column delimiter should always be comma while loading into Salesforce. Use double quote(“) as escape character this will escape the double quotes and Text Qualifier as Double quotes. When the data is inclusive of the single/Double quotes