Page 1 of 1

Querys using GCA

Posted: 20 January 14 6:46 pm
by spatialriq
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?

Re: Querys using GCA

Posted: 20 January 14 7:01 pm
by CraigRat
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.

Re: Querys using GCA

Posted: 20 January 14 7:08 pm
by spatialriq
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

Re: Querys using GCA

Posted: 20 January 14 7:13 pm
by CraigRat
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

Re: Querys using GCA

Posted: 20 January 14 7:37 pm
by spatialriq
Wow, that was quick. Thanks for your assistance :D

Re: Querys using GCA

Posted: 20 January 14 7:59 pm
by CraigRat
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:

Re: Querys using GCA

Posted: 20 January 14 8:06 pm
by caughtatwork

Re: Querys using GCA

Posted: 20 January 14 8:07 pm
by spatialriq
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)