Querys using GCA
- spatialriq
- 5500 or more caches found
- Posts: 326
- Joined: 12 May 11 11:52 pm
- Location: Perth
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?
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?
- CraigRat
- 850 or more found!!!
- Posts: 7015
- Joined: 23 August 04 3:17 pm
- Twitter: CraigRat
- Facebook: http://facebook.com/CraigRat
- Location: Launceston, TAS
- Contact:
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.
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.
- spatialriq
- 5500 or more caches found
- Posts: 326
- Joined: 12 May 11 11:52 pm
- Location: Perth
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
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
- CraigRat
- 850 or more found!!!
- Posts: 7015
- Joined: 23 August 04 3:17 pm
- Twitter: CraigRat
- Facebook: http://facebook.com/CraigRat
- Location: Launceston, TAS
- Contact:
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
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
- spatialriq
- 5500 or more caches found
- Posts: 326
- Joined: 12 May 11 11:52 pm
- Location: Perth
Re: Querys using GCA
Wow, that was quick. Thanks for your assistance
- CraigRat
- 850 or more found!!!
- Posts: 7015
- Joined: 23 August 04 3:17 pm
- Twitter: CraigRat
- Facebook: http://facebook.com/CraigRat
- Location: Launceston, TAS
- Contact:
Re: Querys using GCA
I was doodling round in the database doing something not too dissimilar when your post arrivedspatialriq wrote:Wow, that was quick. Thanks for your assistance
- caughtatwork
- Posts: 17024
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
- spatialriq
- 5500 or more caches found
- Posts: 326
- Joined: 12 May 11 11:52 pm
- Location: Perth
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