On 1 Aug 2012, at 9:24 PM, Cliff Kachinske <[email protected]> wrote: > 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?
Yes, it's a key, marked unique. The problem was a bug in the way the csv importer was trying to synchronize id fields. The trunk is now patched. (The problem was triggered by gaps in the file's id sequence, and the first one was following #37. > > 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.) > > --
