Querys using GCA

Discussion about software such as GSAK, OziExplorer etc, as well as all things hardware, GPSrs, laptops, PDAs, paperless caching, cables etc
Post Reply
User avatar
spatialriq
5500 or more caches found
5500 or more caches found
Posts: 326
Joined: 12 May 11 11:52 pm
Location: Perth

Querys using GCA

Post by spatialriq » 20 January 14 6:46 pm

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?

User avatar
CraigRat
850 or more found!!!
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

Post by CraigRat » 20 January 14 7:01 pm

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.

User avatar
spatialriq
5500 or more caches found
5500 or more caches found
Posts: 326
Joined: 12 May 11 11:52 pm
Location: Perth

Re: Querys using GCA

Post by spatialriq » 20 January 14 7:08 pm

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

User avatar
CraigRat
850 or more found!!!
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

Post by CraigRat » 20 January 14 7:13 pm

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

User avatar
spatialriq
5500 or more caches found
5500 or more caches found
Posts: 326
Joined: 12 May 11 11:52 pm
Location: Perth

Re: Querys using GCA

Post by spatialriq » 20 January 14 7:37 pm

Wow, that was quick. Thanks for your assistance :D

User avatar
CraigRat
850 or more found!!!
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

Post by CraigRat » 20 January 14 7:59 pm

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:


User avatar
spatialriq
5500 or more caches found
5500 or more caches found
Posts: 326
Joined: 12 May 11 11:52 pm
Location: Perth

Re: Querys using GCA

Post by spatialriq » 20 January 14 8:07 pm

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)

Post Reply