Download UserProfile

[rumpelrossi]

Hi to all,

 

how can I download the AllCachesFind-listing from my UserProfile.

I want to import it to ooCalc e.g. where I want to sort this list in any other order than the FoundDate.

Perhaps it would also be possible to download the coordinates of every cache of this list, particularly of the archieved or deleted ones.

 

Thanks

 

Rumpelrossi

[+LSUMonica]

Ahh!! Now you have discovered one of the benefits of being a PREMIUM member!

 

Premium members have the ability to run Pocket Queries or PQs, as they are commonly refered to. PQs are a group of cache listings in the .gpx format. You can run PQs based on activity, location, type, etc, or in your case based on your found status. This PQ can then be imported into quite a few software programs.

 

Truly for all the features, Premium Membership at $30 a year or $3 a month is quite a bargin!

[+trainlove]

Well that's all well and good. But you can also:

go to your account

click on your small stat box on the upper left

click on geocaches

click on List of Geocaches found (All Cache Finds)

select all

copy

paste special, text, into Excel

manipulate it by doing Text to Columns and so on...

well this works only for 20 caches at a time.

But this has cache type, name, gc name, owner, state, when it was last found and when you found it.

 

If on the other hand you:

go to your account

in the quick view click on Show all logs for: Caches

click on Found it, and later on click on Attended, and later click on Webcam Photo Taken, but at least you don't have to do it 20 at a time, there you can get all of each of those categories

select all

copy

paste special, text into Excel

you will have your find date, cache name and state but none of thatother information.

 

I have done this in the past before becoming a Premium Member, and I still occasionally do it as I have a spreadsheet of finds, sorted by date (backwards within each day of course, see other forum posts about that), to keep track of milestones for total finds, milestones for traditional finds, milestones for 'other than traditional' finds, milestones for puzzle finds and milestones for multi-cache finds. Pretty soon I'll also be able to do a milestone for Events attended. I also use that spreadsheet to count caches/unit time, resting days, continuous caching days and so on.

 

Excel is great.

[+Lil Devil]

OMG a positive, helpful post from trainlove

Mark this date on your calendars

[+trainlove]

Gee, I thought that my reply was a full blown blast against the constant PQ answers that are always bandied about.

 

just kidding. PQ's are great but not everyone is a Rocket Scientist like me and like PQ's. I do miss them so much since I let me Premium Membership lapse 'forever'.

 

I will, but probably will not, have quite negative posts when/if there are ever problems like those back n February/March and May/June. I can only wait and see what Version 2 rollout will be like, but I'll watch all the other negative posts if they happen.

 

Excel is great. Microsoft otherwise @&@. Bill Gates should be hung.

[rumpelrossi]

Thank you very much...

I think I have to change to a premium membership, or something like this...

Have a nice day...

 

rumpelrossi

[+trainlove]

I've been too busy to follow up on this but here are a couple images of the eassy kinds of things you can do 'without having to become a Premium Member'.

 

P.S. I also keep a database of all my finds using EasyGPS and have a couple routes definied, one that is of all cache finds, and the other is of all cache finds with the daily return trip home. If you do this then be sure to download the .LOC file for events before they become archived, or you will have to manually enter the waypoint. One of these days I'll become a Premium Member for a month to get My Finds PQ so that I can upload the most recent stuff into ItsNotAboutTheNumbers.com.