Many Catalogue records include a 2nd row in the Taxon ‘Identification’ table, with no data apart from Filed As (IdeFiledAs_tab) = “No”
e.g. (in live + test): Cat irn 4425029
After live is updated with new dev, multiple rows in the Taxon ID table will cause an "id history" indicator-box to be checked. This is good for records that have multiple IDs, but not so good for records like irn 4425029.
How to find possibly-messy records
Open the Catalogue module and find the "Filed As" (use File -> 'Find a Field' if needed)
Search 'Filed As' = 'No'
Sort the results by 'Taxon' to clump the records with 'empty' Taxon id's
Check the 'Identification' tab tables to see if there are indeed empty rows -- e.g.:
Note for Insects and IZ:
Please group problem-records until Sep 2023. Fixing them needs to wait until after the Sep 2023 EMu update, to address a bug in Catalogue logic related to the ID table rows.
How to fix - Individually
...e.g. if you see one while editing/searching:
Right-click the row-number for the empty row, and select 'Delete'
Save the record.
How to fix - In Batches (be careful)
If your batch contains ONLY records that have a 2nd (or multiple) empty rows with 'Filed As' = 'No':
TO DO: delete empty Taxon ID rows
Many Catalogue records include a 2nd row in the Taxon ‘Identification’ table, with no data apart from Filed As (IdeFiledAs_tab) = “No”
After live is updated with new dev, multiple rows in the Taxon ID table will cause an "id history" indicator-box to be checked. This is good for records that have multiple IDs, but not so good for records like irn 4425029.
How to find possibly-messy records
Open the Catalogue module and find the "Filed As" (use File -> 'Find a Field' if needed)
Search 'Filed As' = 'No'
Sort the results by 'Taxon' to clump the records with 'empty' Taxon id's
Check the 'Identification' tab tables to see if there are indeed empty rows -- e.g.:
Note for Insects and IZ:
Please group problem-records until Sep 2023. Fixing them needs to wait until after the Sep 2023 EMu update, to address a bug in Catalogue logic related to the ID table rows.
How to fix - Individually
...e.g. if you see one while editing/searching:
Right-click the row-number for the empty row, and select 'Delete'
Save the record.
How to fix - In Batches (be careful)
If your batch contains ONLY records that have a 2nd (or multiple) empty rows with 'Filed As' = 'No':
Run this global replace:
if needed - How to use the global replace tool