What was the result of the discussion about the necessity of importing each taxonomic level separately (or going in and backfilling every taxonomic level above a given determination)? Will the “ignore when blank” function obviate this need? ((fingers crossed!))
Hi @ambemis,
“Ignore when Blank” changes the matching behavior when importing new data into Specify.
Normally, the WorkBench treats empty cells in the Data Set as values, so that if a mapped cell is empty and the corresponding database field contains data, a new record would be created in a database table because an empty cell would not match the contents of the database field.
A usage example for this match parameter option would be where a Data Set contains Taxon entries including a column containing taxon authors and publication dates, but where for some rows in the Data Set Taxon cells in that column are empty.
The desired matching behavior of the WorkBench would be to ignore the blank cells in that column, and to not create a new Taxon record due to a cell without an author/date value.
In short, when “Ignore when Blank” is set, Specify will not use the blank cells for determining a match and therefore do not cause new records in that table to be created.