Errors in batch importing - field too long

[GoogleCodeExporter]

I was attempting to upload the very large file (1400 records) into BibApp
(I've attached it). It processed 74 records but then hit the following errors:

PGError: ERROR: value too long for type character varying(255) : INSERT
INTO "keywords" ("name", "created_at", "updated_at") VALUES(E'FF005 Field
Crops (NEW March 2000) FF020 Plant Breeding and Genetics FF060 Plant
Physiology and Biochemistry FF700 Plant Disorders and Injuries (Not caused
directly by Organisms) HH430 Pesticide and Drug Residues and Ecotoxicology
(NEW March 2000) JJ700 Fertilizers and other Amendments', '2009-12-22
10:08:55.022473', '2009-12-22 10:08:55.022473') RETURNING "id"

PGError: ERROR: value too long for type character varying(255) : INSERT
INTO "keywords" ("name", "created_at", "updated_at") VALUES(E'FF005 Field
Crops (NEW March 2000) FF020 Plant Breeding and Genetics FF060 Plant
Physiology and Biochemistry FF700 Plant Disorders and Injuries (Not caused
directly by Organisms) HH430 Pesticide and Drug Residues and Ecotoxicology
(NEW March 2000) JJ700 Fertilizers and other Amendments', '2009-12-22
10:08:55.022473', '2009-12-22 10:08:55.022473') RETURNING "id"

This was a refworks upload.

Original issue reported on code.google.com by sshree...@gmail.com on 22 Dec 2009 at 4:11

Attachments:

• CropSciencesIDEALS-Export.xml

[GoogleCodeExporter]

Fixed. However, the error reporting still needs to be cleaned up a bit. -Bill

Original comment by waingram on 22 Dec 2009 at 11:06

• Changed state: Accepted
• Added labels: Milestone-Release1.0, Priority-Critical

[GoogleCodeExporter]

Fixed in r1419

Bill

Original comment by waingram on 29 Jan 2010 at 6:54

• Changed state: Fixed