| Specify 7 Version: | v7.12.0.6 |
|---|
I have a lot of duplicate localities with identical GUID’s that I want to clean up. What is the best way to remove the localities that aren’t being used and aren’t linked to any records?
Hi @nationalshell,
Batch deleting records is something that we are interested in implementing (issue 6882), but it is not possible at this time.
The best way to resolve the unused locality records is to merge them. Since it sounds like the duplicate localities have no useful information or linked records, they can be merged into one record quite simply. Then, the remaining locality record can deleted from the database.
Please note, though, that this merge workaround is dependent on being able to return the duplicates in a query. The easiest way to do so is by adding the duplicates to a record set and querying inside that record set. If you don’t already have an export or record set of the duplicate records, you can follow this guide on exporting a list of duplicate records: Identifying Duplicates for Merging in Specify 7. The duplicate export may come in handy when creating a record set of the duplicates so they can be merged.
For more context:
Please let us know of any remaining questions!
Hi Bronwyn,
Thank you! This is extremely helpful. My workaround was to make a locality query with the locality GUID, and EMPTY collection number (meaning it wasn’t tied to any collection objects). And then I just browsed in Forms and could delete 1 locality at a time pretty quickly. It is a bit tedious.
