+AstroGliders Posted October 12, 2011 Share Posted October 12, 2011 How do I find and delete duplicate logs in GSAK? Quote Link to comment
+pppingme Posted October 12, 2011 Share Posted October 12, 2011 Easiest way is to add the Fcount column then sort by that. Quote Link to comment
+EdrickV Posted October 12, 2011 Share Posted October 12, 2011 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. Quote Link to comment
+Isonzo Karst Posted October 12, 2011 Share Posted October 12, 2011 (edited) 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. Edited October 12, 2011 by Isonzo Karst Quote Link to comment
Keystone Posted October 12, 2011 Share Posted October 12, 2011 I am moving this thread from the Geocaching Topics forum to the GPS and Technology forum. Quote Link to comment
+GeoHoosier Posted January 14, 2014 Share Posted January 14, 2014 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. Quote Link to comment
Keystone Posted January 14, 2014 Share Posted January 14, 2014 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. Quote Link to comment
+baloo&bd Posted January 17, 2014 Share Posted January 17, 2014 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 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.