1

Topic: Redundant locations report

We have a lot of location records on our system that no longer have any observations against them, and would like to get rid of them. Some have locations beneath them in the hierarchy that do have observations, so we will probably have to do this manually rather than by batch update. Does anyone have a report that would list them for us?

Janet Simkin
British Lichen Society

2

Re: Redundant locations report

Hi

The attached report should list all your locations and show the ones which either have data atached directly or which have sub sites below them (at any level) with data attached. It ignores system supplied locations and their shilden even if not system supplied.

This Report could be turned into a Batch Update to delete the Locations with no data.

Mike Weideli
Littlefield Consultancy - IT Consultants

3

Re: Redundant locations report

Thanks for the quick response, but there is no attachment!

Janet Simkin
British Lichen Society

4

Re: Redundant locations report

Sorry.

Report is attached, plus a Batch Update which will delete them. The Batch Update isn't very forgiving, so if you use  it make sure you have a backup and check afterwards that everything looks ok. It is more likely to fail than delete anything that matters. It can't delete Locations or their parents which have data attached to them, but it will delete locations which  have other infomation attached(eg Measurements, Grid Squares, Features).

Report is in System/Supplied/Information
Batch Update is in System Supplied/Delete

Post's attachments

R6TEAMDel7LocNoData.xml 6.8 kb, 2 downloads since 2018-04-04 

RTEAM_Unused_Locations.xml 1.98 kb, 4 downloads since 2018-04-04 

You don't have the permssions to download the attachments of this post.
Mike Weideli
Littlefield Consultancy - IT Consultants

5

Re: Redundant locations report

Thanks, Mike. I haven't tried the batch update yet but the report is just what we need.

Janet Simkin
British Lichen Society