Integration Error

  • 65Views
  • Last Post 07 August 2017
0
votes
Daniel Rogers posted this 04 August 2017

We are running an integration between a csv file on DropBox and Salesforce.com that is giving an error. The error is "The column delimiter for column 'Funding Source Name' was not found".  This is the last column in our csv file.  The format of the file hasn't changed in two years and many files have been imported sucessfully in the past.  It has CRLF on the end of each line.  All the columns are correctly delimited with commas.  We've tried to change the end of line character setting in Skyvia from LF to CRLF but Skyvia keeps changing it back.  Please suggest a solution.  

0
votes
Simon Bubnov posted this 07 August 2017

Your package uses double quotation mark as "Text Qualifier". Probably the CSV file data contains double quotation marks. For example, XML data usually contains double quotation marks. In this case you may need to re-create the CSV file using other "Text Qualifier" value and use this value for "Text Qualifier" in the import package.

Close