Groundspeak Forums: Duplicate Logs - Groundspeak Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Duplicate Logs

#1 User is offline   AstroGliders 

  • Premium Member
  • Group: +Premium Members
  • Posts: 3
  • Joined: 15-July 07

Posted 11 October 2011 - 11:03 PM

How do I find and delete duplicate logs in GSAK?

#2 User is offline   Potato Finder 

  • Plutonium Member
  • Group: +Premium Members
  • Posts: 1147
  • Joined: 21-January 05

Posted 11 October 2011 - 11:08 PM

Easiest way is to add the Fcount column then sort by that.

#3 User is offline   EdrickV 

  • Premium Member
  • Group: +Premium Members
  • Posts: 727
  • Joined: 20-February 11

Posted 12 October 2011 - 12:06 AM

1. Create and add a My Finds pocket query to GSAK. (Adding it to a separate, empty, database might be a good idea.)
2. Go to View|Add/Remove Columns...
3. Add the Found Count column.
4. Scroll to the Found Count column and click it's header to sort using it.

#4 User is offline   Isonzo Karst 

  • 10% platinum
  • Group: +Premium Members
  • Posts: 5372
  • Joined: 08-March 03

Posted 12 October 2011 - 02:23 AM

Assuming you're looking to clean up duplicate finds. Run a MyFinds query. Put it in database in GSAK

Search > Filter > Logs, select type, and Number "greater then or equal to (enter the number) 2.

When you run this filter, you'll only see caches you've logged with 2 or more then one Found it! logs

Should be a short list, easy to work with.

This post has been edited by Isonzo Karst: 12 October 2011 - 02:25 AM


#5 User is offline   Keystone 

  • Everything in Moderation
  • Group: Site Wide Moderators
  • Posts: 16621
  • Joined: 16-May 03

  Posted 12 October 2011 - 02:27 AM

I am moving this thread from the Geocaching Topics forum to the GPS and Technology forum.

#6 User is offline   GeoHoosier 

  • Premium Member
  • Group: +Premium Members
  • Posts: 1
  • Joined: 15-May 08

Posted 14 January 2014 - 05:24 AM

Is there a way to find the duplicates on Geocaching.com so I can delete the duplicate logs? I have three duplicates and I want to ensure they is only one per find.

#7 User is offline   Keystone 

  • Everything in Moderation
  • Group: Site Wide Moderators
  • Posts: 16621
  • Joined: 16-May 03

Posted 14 January 2014 - 08:18 AM

There is no tool directly on the Geocaching.com website that will identify the cache(s) where you've logged multiple finds. The statistics tab on your profile will flag the problem for you by saying that you have X+3 finds on X geocaches. There are at least three ways of finding out which cache pages contain those three duplicate logs:

1. Download a "My Finds" pocket query and run it through GSAK as noted above.
2. If you don't use GSAK, go to Project-GC.com and use the Find Bad Logs tool. This is web-based and requires no data manipulation on your part - just authentication to this website -- a trusted Geocaching Live! API partner.
3. If you don't want to authenticate with Project-GC, go to your list of "found it" logs, accessed from your profile page by clicking on "Geocaches." Copy the table and export it into Excel or other spreadsheet tool. Sort the data by cache name and scan the list for duplicates. If the duplicates aren't located, repeat the process by examining your "Attended" logs in case you double-logged an event cache.

#8 User is offline   baloo&bd 

  • Caching Couple
  • Group: +Premium Members
  • Posts: 3192
  • Joined: 29-March 03

Posted 17 January 2014 - 11:58 AM

GSAK also has about 6 or so macros to help with the task, although the fcount is the easiest. I also use this to find duplicate logs by others on caches I own.

DupplicateFoundLogsAnyDate.gsk

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic