Hi there,

I have deleted several plots from my collect earth analysis. These plots are no longer in the csv file that is referenced by google earth when collecting the data, nor in the sample data in the properties of the project.

However, when I export the excel file output to csv...they are still there with all of the data, and also when Saiku runs the analysis these deleted plots are still referenced.

Please can someone tell me how to stop these deleted plots from being referenced still?

Thank you

Becky

asked 07 Aug '18, 11:29

bstedham's gravatar image

bstedham
1136
accept rate: 0%


As it takes longer to write the manual step-by-step explanation I have just released a new version of Collect Earth that includes the utility to delete plots from the database.

UPDATE TO VERSION 1.7.0 or later

WARNING: BEFORE DELETING ANYTHING I ADVISE YOU TO MAKE A BACKUP OF YOUR DATA

Basically you need to identify the plot IDs that you want to delete from the DB. Then you put them into a CSV file where the header is the name (or names) of the key attributes of the survey. So if you have a survey where the plot have only one key attribute called id and you want to delete plots with ids 1,2,3 and 10 you would create a CSV like this:

id
1
2
3
10

Then you go to Collect Earth menu Tools->Utilities->Delete plots from Database

alt text

This opens a dialog where you choose the CSV file with the IDs to be removed (the dialog will validate that the CSV file has the expected headers with the name of the key attributes)

alt text

At the end you will get a window that lets you know how many plots were deleted, how many plots in the CSV were actually not in the Database and how many plots were in the database but for some reason there was an exception and could not be deleted (you can find the exception message in the Collect Earth logs Help->Open Application Log file)

permanent link

answered 09 Aug '18, 17:30

collectearth's gravatar image

collectearth ♦
1.0k16
accept rate: 17%

edited 10 Aug '18, 09:52

Open%20Foris's gravatar image

Open Foris ♦♦
9995714

Hello @collectearth, i'm on the same boat as Becky - it would be much apprecaited if you could please post the step-by-step process to manually remove such plots from the analysis.

thanks very much, simone

permanent link

answered 08 Aug '18, 12:26

svaccari's gravatar image

svaccari
113
accept rate: 0%

edited 08 Aug '18, 12:33

Hello Becky,

We are right now developing a small utility within Collect Earth to do just that!

If you cannot wait for a few days let me know and I will guide you through the manual process to remove plots.

permanent link

answered 07 Aug '18, 15:14

collectearth's gravatar image

collectearth ♦
1.0k16
accept rate: 17%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×281

question asked: 07 Aug '18, 11:29

question was seen: 3,098 times

last updated: 10 Aug '18, 09:52