Home › Forums › User Forums › Community Forum

Failed import due to validation

Mon, 09/26/2011 - 20:15 — kehan

Hi All,
As per my previous post, I'm trying to import an excel spreadsheet and I am having trouble with importing from the Workbench into excel after doing my mapping. Specify gives me a cryptic message:
Inconsistent mappings for record 3: Agent
and when I dig around in specify.log I get the following 4 lines that seem to be pointing to the problem:

09:02:34 DEBUG wb.wbuploader.MissingDataResolver:403 - setting Agent.AgentType to 1
09:02:34 DEBUG wb.wbuploader.MissingDataResolver:403 - setting Agent.AgentType to 1
09:02:34 DEBUG wb.wbuploader.MissingDataResolver:403 - setting Agent.AgentType to 1
09:02:34 ERROR wb.wbuploader.MissingDataResolver:467 - unable to meet requirement: Collector.IsPrimary

Has anybody seen this before, and is there a way to fix this? I can't find a mapper for Collector.IsPrimary in the workbench mapping.

Thanks in advance,
Kehan

‹ Specify functions from the command line Importing From Excel - Can't Reuse Mappings ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Mon, 09/26/2011 - 20:29 — kehan

Additional information

I should add that I'm using Specify 6.3.05 on Ubuntu Linux version 10.10

Help>About reports that I'm using MySQL 5.1.49-1ubuntu8.1 and Java Version 1.6.0_20

Fri, 10/07/2011 - 12:18 — tlammer

RE: Failed import due to validation

Mappings can only be reused if the CSV file being imported contains the same or fewer columns than the mapping. In other words, if you split a CSV file into two smaller files for import, then import the first CSV file but do not map all the columns, the unmapped columns are discarded. When you then import the second CSV file you will not be given the option to reuse the mapping created for the first CSV file. To reuse the mapping you must first delete the unmapped/discarded columns from the CSV file before importing it into the WorkBench.