CSV Import Set Error: Data Contains 2 Columns, Expected 1

ashbot
Kilo Contributor

‎09-22-2016 01:42 PM

Good afternoon,

I have a current HTTPS integration that is pulling a CSV.   It was previously working, but now I am receiving an error: Data contains 2 columns, expected 1.   I've seen a lot about date/time fields, I do not have one in my CSV, though I am pulling MAC Addresses that contain semi-colons.   Any help would be appreciated!

0 Helpfuls
  • 9,376 Views
6 REPLIES 6

Michael_Nau
Giga Contributor

‎10-03-2016 09:49 AM

Hi Ashley,



can you post a few lines from that CSV given you don't consider the data to be confidential?



If that is not possible first try to attach the file directly to a data source, then see if you encounter the same error - just to take your integration out of the equation.



Regards,


Michael


0 Helpfuls

drjohnchun
Tera Guru

‎10-03-2016 11:05 AM

I suspect the import data contains a comma; if the comma was part of the field data and not intended to be a delimiter, the field must be enclosed in double quotes. If this is indeed the case, it must be fixed from the source (the sender).



Please see my other reply in How do I change the CSV file delimiter from a comma "," to a carrot "^"?



Please feel free to connect, follow, mark helpful, like, endorse.


John Chun, PhD PMP see John's LinkedIn profile


visit snowaid


0 Helpfuls

yogesh15dd
Tera Guru
In response to drjohnchun

‎12-14-2016 01:57 AM

Hi John,



I have the similar error, the 'double quotes' problem on the csv import   file, the data is not getting loaded, i use HTTP, csv, data source method.



I tried opening the csv in a notepad , it looks like below, if you observe the first, 4th and the 5th values, they are not wrapped up in a double quotes, not sure why not!, is it a problem with the sender or problem with my viewing?




"CompanyType","LegacyAccountNumber","BusinessName","LegacyAccountASRID","LegacyAccountAgentParty_ID","LegacyGroupNumber"


 


BookOfBusiness,"AA3002","ARMSTRONG I AGENCY",8009834,8526940,"AA3002"



Please suggest.



Thanks


Yogish


0 Helpfuls

drjohnchun
Tera Guru
In response to yogesh15dd

‎12-14-2016 06:06 AM

Hi Yogesh - I don't see issues with the data you have. Enclosing in double quotes is optional for the fields not requiring double quotes, as I mentioned in my blog CSV Primer & Troubleshooting Tips. None of your field values requires enclosing in double quotes, although I'm not sure why some are enclosed and some aren't.



My suggestion is to open your CSV file in Excel and see if you notice anything, such as a row breaking into multiple rows or misaligned columns; then you know there's an issue at the source.


0 Helpfuls