View unanswered posts | View active topics It is currently 11 December 18 1:26 pm



Post new topic Reply to topic  [ 8 posts ] 
Querys using GCA 
Author Message
5500 or more caches found
5500 or more caches found
User avatar

Joined: 12 May 11 11:52 pm
Posts: 326
Location: Perth
GCA Found: 888
GCA Hidden: 36
100 GCA Finds500 GCA Finds
Post Querys using GCA
Hi,

I've had a look thru the public queries and tried to make my own but so far not getting far, so time to ask for help. ](*,)

I'm trying to make a query to output my FTF's. For the past year or so I've been adding in the *FTF* but prior to this I just added in FTF. I've also found a few of my logs had *FTF, so not all are being picked up automatically. Is there some way I can get a query to search my finds that have FTF within them and dump this out to a GPX?


20 January 14 6:46 pm
Profile E-mail
850 or more found!!!
850 or more found!!!
User avatar

Joined: 23 August 04 3:17 pm
Posts: 6891
Location: Launceston, TAS
GCA Found: 158
GCA Hidden: 44
100 GCA Finds
Post Re: Querys using GCA
We don't have any facilities at the moment for searching log text via queries (nor will we due to the load that text searches place on the server).

I can do a manual search for you for any logs of yours that have FTF in them (and give you the cache codes) if that helps.


20 January 14 7:01 pm
Profile E-mail WWW
5500 or more caches found
5500 or more caches found
User avatar

Joined: 12 May 11 11:52 pm
Posts: 326
Location: Perth
GCA Found: 888
GCA Hidden: 36
100 GCA Finds500 GCA Finds
Post Re: Querys using GCA
Craig, no that ok. I've got at least 164 that I know of (CGA and GC combined) .. so manually doing it would take a while! I skimmed thru the last 6 months and found a couple I'd missed and was just wondering if there be an automated way of doing it.

Any idea if GSAK could do such a thing? I've got that installed and have my finds in there .. rarely use it though as it's also something I'm a novice at :D


20 January 14 7:08 pm
Profile E-mail
850 or more found!!!
850 or more found!!!
User avatar

Joined: 23 August 04 3:17 pm
Posts: 6891
Location: Launceston, TAS
GCA Found: 158
GCA Hidden: 44
100 GCA Finds
Post Re: Querys using GCA
Yes, GSAK can.

I can also run a query that can work out if you've put FTF in the log and also claimed FTF on a cache, won't take long


20 January 14 7:13 pm
Profile E-mail WWW
5500 or more caches found
5500 or more caches found
User avatar

Joined: 12 May 11 11:52 pm
Posts: 326
Location: Perth
GCA Found: 888
GCA Hidden: 36
100 GCA Finds500 GCA Finds
Post Re: Querys using GCA
Wow, that was quick. Thanks for your assistance :D


20 January 14 7:37 pm
Profile E-mail
850 or more found!!!
850 or more found!!!
User avatar

Joined: 23 August 04 3:17 pm
Posts: 6891
Location: Launceston, TAS
GCA Found: 158
GCA Hidden: 44
100 GCA Finds
Post Re: Querys using GCA
spatialriq wrote:
Wow, that was quick. Thanks for your assistance :D

I was doodling round in the database doing something not too dissimilar when your post arrived :lol:


20 January 14 7:59 pm
Profile E-mail WWW
Online
User avatar

Joined: 17 May 04 12:11 pm
Posts: 15751
Location: Melbourne
GCA Found: 1240
GCA Hidden: 333
100 GCA Finds500 GCA Finds1000 GCA Finds
Post Re: Querys using GCA
FYI.

http://wiki.geocaching.com.au/wiki/Impo ... to_Find.29


20 January 14 8:06 pm
Profile E-mail WWW
5500 or more caches found
5500 or more caches found
User avatar

Joined: 12 May 11 11:52 pm
Posts: 326
Location: Perth
GCA Found: 888
GCA Hidden: 36
100 GCA Finds500 GCA Finds
Post Re: Querys using GCA
Well that was worth the effort ... just found 11 more FTF's I'd missed! So now on 151 GC and 24 GCA, so 175 in total .. nice 8)


20 January 14 8:07 pm
Profile E-mail
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


Who is online

Users browsing this forum: No registered users and 34 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Forum theme by Vjacheslav Trushkin for Free Forum/DivisionCore.