Jonathan, Is email really a key?
What happens if you delete line 36? If it still fails, what happens if you delete lines 1 thru 36? On Monday, July 30, 2012 8:52:18 PM UTC-4, Jonathan Lundell wrote: > > I'm running into an odd csv-import problem. > > I've exported a table via SQLFORM.grid's export function, and have a > fine-looking CSV file, about 1300 records. > > In the admin interface for that table, I delete all the records, and > import the file. It imports 37 records, and then quits with the message: > > unable to parse csv file (1062, u"Duplicate entry '[email protected]' for > key 'email'") > > (I've anonymized the email address; it's a good one.) > > What's odd is that there *is* no duplicate. And if I delete the line with > the offending address, I get the same result but with the next line of the > file. > > (This is with current-stable and MySQL.) --
