Anyone know what this is trying to tell me? I cannot import the CSV because of this error.
Everything is labeled as VARCHAR and api_well_number is marked as the unique identifier. SQLiteManager: INSERT INTO "main"."WELLS" VALUES ("Adams, E.H. et al",'Schuyler','Hector','3.11E+13','Collins 1','UM','Unknown Not Found','DW','Dry Wildcat','8') [ UNIQUE constraint failed: WELLS.api_well_number ] Exception Name: NS_ERROR_STORAGE_CONSTRAINT Exception Message: Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute] Dan Telvock Environment Reporter Investigative Post <http://www.investigativepost.org/> Twitter: @dantelvock 716-831-2626 ext. 3