Topic: Import fails

Hi there.
Im trying to import a UTF-8 CSV file and getting this error all the time:

Error: The server encountered a problem trying to import your file. Please check that it is a plaintext csv file and try again. Extra information: Column count doesn't match value count at row 7

The lines im importing are:

Name,Edition,Count
City of Traitors,Exodus,1
Wheel of Fortune,Revised Edition,2
Gwendlyn Di Corci,Legends,1
Force of Will,Alliances,1
Gilded Drake,Urza's Saga,1
Blood Moon,The Dark,1
Kamahl, Fist of Krosa,Onslaught,1

Any ideas would be great, I have triyed everything I could think of.

Kind regards
Michael

Re: Import fails

My hunch is that the issue is Kamahl, Fist of Krosa. That's line 7 (assuming the header isn't counted or that the list is 0-based), and notice in the error it mentions the "column count". That's because the comma in Kamahl's name makes that line have 4 columns, not 3. In a proper CSV, any values that contain commas will be surrounded by quotation marks:

"Kamahl, Fist of Krosa",Onslaught,1

What program are you using? If Excel or a dedicated CSV editor, then this issue shouldn't even occur, as they're designed to handle that situation correctly. If you're using a plaintext editor like Notepad, then you'll have to manually quote any card or edition names (like Duel Decks Anthology, Elves vs. Goblins) that contain commas.