Sort found geocoins types by find count...

[+GeoLog81]

There is a hard to find page in my profile where I view how many geocoins of various types I've disovered... Is it possible to order them by find count?

[+JoergWausW]

I couldn't find a solution for you at geocaching.com.

Why do you need it?

 

Here is your current list down to 5 of the same icon (not necessarily 5 of the same coin):

 

Travel Bug Dog Tags 141

My Personal Geocoins 15

Geocaching Polska Geocoins 14

GeoGems 11

USA Geocoins 8

CC Geocoins 8

Appalachian Trail Geocoins 8

Mystic Pegasus Geocoins 7

Geocacher's License Geocoins 2007 6

Appalachian Trail 2008 Geocoins 6

Compass Rose Geocoin 2009 6

Mystic Naga Geocoins 6

Cachen ist die beste Medizin Geocoins 6

Mystic Gargoyle Geocoins 6

Geocaching – All In One Geocoin 2013 6

Mystic Garuda Geocoins 6

Inca Cross Geocoins 6

Royal Flush Geocoins 5

Nordic Caching Traveler Geocoins 5

Cacher Thermometer Geocoins 5

Travel Bug Origins - Deutschland 5

conivo’s Butterfly Geocoins 5

Six Pack of Beer Tags 5

Geocaching Basel Geocoins 5

 

This is how I did it:

 

1) go to your public list of trackables (the one list everyone can access)

2) save page as htm-file

-) When I tried to open it in 'open office', it crashed, probably because the file was too big and I was not patient enough to wait if it ever would wake up again. It may work for Excel... I don't know. So I did this:

3) open saved file with Windows editor

4) search for string "Trackables Moved" - there are two hits. The correct one is the first one that doesn't say "Total" in the same line

5) mark the <td>-Tag you can find three lines below

6) press ctrl+shift+Home to mark everything in the document before the table you want.

7) Press Delete to get rid of it. The first line in your document now should be <table class="Table">

8) search for string "Trackables Owned". Again, the first on is the correct one.

9) mark the </div>-Tag five lines up

10) press ctrl+shift+End to mark everything in the document after that line.

11) Press Delete to get rid of it. The last line in your document now should be </table>.

12) Save file as another name.

-) When I tried to open it in 'open office' it still crashed, probably because of all the icons....

13) Open the saved file in firefox/another browser. You get a table only with icons, names and counts.

14) press ctrl+A to mark all and ctrl+C to copy all

15) Start 'open office calc' (Excel might be able to do the same, but I don't own it)

-) Don't use the regular "paste"-function (made it crash again....)

16) Chooose Edit-> Insert content (may be labelled differently in English- I have a German version... it's ctrl+shift+V in open office)

-) Don't pick HTML (crash...)

17) Pick "unformatted text" - this gets rid of the icons.

18) I got a dialog how the content is supposed to be inserted. Make sure name and count is in different columns (I didn't have to change anything - the preview looked fine).

19) Then I had a nice two column file with the correct information. Now sort by Column Count (data-> sort)

 

If anyone knows an easier way, you're welcome to tell.

Edited November 19, 2014 by JoergWausW

[+GeoLog81]

Thanks a lot. It seems to be reeeaaaaaalllyyyy long procedure Maybe it would be easier to write the site scrapper and parse the content in Java or Python or whatever