rumpelrossi Posted September 27, 2007 Share Posted September 27, 2007 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 Link to comment
+LSUMonica Posted September 27, 2007 Share Posted September 27, 2007 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! Link to comment
+trainlove Posted September 27, 2007 Share Posted September 27, 2007 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. Link to comment
+Lil Devil Posted September 27, 2007 Share Posted September 27, 2007 OMG a positive, helpful post from trainlove Mark this date on your calendars Link to comment
+trainlove Posted September 27, 2007 Share Posted September 27, 2007 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. Link to comment
rumpelrossi Posted September 29, 2007 Author Share Posted September 29, 2007 Thank you very much... I think I have to change to a premium membership, or something like this... Have a nice day... rumpelrossi Link to comment
+trainlove Posted October 2, 2007 Share Posted October 2, 2007 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. Link to comment
Recommended Posts