how to clean up the records in Collect Earth

  • Asked
  • Active
  • Viewed 5106 times
0

I have entered a lot of records when i did some tests in Collect earth. Is there a way to clean up these records collected from Collect Earth? I don't need them anymore. As far as i know, these records are kept in Sqlite, but not sure what is best way to clean up the records.

thanks,

jinkai

0

Accepted answer

Dear Jinkai,

Right now there is not a very good system to do this.

The easiest option is to remove the SQLite database file and restart Collect Earth with a fresh and clean database that will be automatically generated by Collect Earth. DISCLAIMER: IF YOU DO THIS YOU WILL OBVIOUSLY DELETE THE DATA ALREADY ON THE DATABASE!! So in that case remember to export the data so that you keep a copy of everything you had there.

The database file is called collectEarthDatabase.db and is located in the hidden folder : C:\Users\YOUR_USERNAME\AppData\Roaming\CollectEarth

You can access easily this folder by clicking on Tools->Open Data Folder alt text

This will open a file explorer where you can locate the collectEarthDatabase.db file. Before removing the file close Collect Earth (as otherwise the file will not be able to be removed as it is in use of the application)

Once you have done this you can restart Collect Earth and a new and completely empty database file will be automatically created created!

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.