Method Community

Hello I am getting the following error while attempting to update my customer contact list. Please help.

ERROR:The CSV appears to be corrupt near record '16' field '108 at position '991'

TIP: Your delimited data could not be understood. This is probably caused by an uneven amount of delimiters in each line. For instance, if line 1 has 15 commas, all of the following lines must have 15 commas too. If you have delimiters inside double quotation marks, however, they will be ignored.

For example, the following will fail, since it will be interpreted as have 1 delimiter (comma) in the first two lines, and 2 delimiters (commas) in the third line.
Name,Phone
Natalie Chapman,555-111-3456
Crenshaw,Bob,555-555-1212

This however will succeed, since there is an equal amount of delimiters (commas) per line.
Name,Phone
Natalie Chapman,555-111-3456
Bob Crenshaw,555-555-1212

This will also succeed, since “Crenshaw, Bob” is surrounded by double quotation marks:
Name,Phone
Natalie Chapman,555-111-3456
“Crenshaw,Bob”,555-555-1212

jnairn - that's a pretty informative (and hopefully helpfully worded) message for an error :).

What is the contents of your 15th record?

What is the contents of your 16th record?

Are you importing from a CSV file, or are you copying and pasting?

Paul

jnairn - got your private message.

There's no commas in there, so I'm guessing it's a copy and paste from Excel?  Really hard to figure out what's going on in there, as it came to me in one continuous line.

Instead of a copy and paste from the clipboard can you try saving it as a CSV from Excel and importing it?  

Paul

That's the thing. I am importing it. I tried it as a csv file as well as txt file.

jnairn - do you mind emailing the first 20 lines of the file to method at methodintegration.com, citing this forum post (#11373)?  

Paul