Skip to Content
Register · Login
About Theme

A Letterboxing Community

Search Edit Search

Read Thread: How to download find logbook

Re: How to download find logbook
Board: Letterboxing Help Desk
Reply to: #972176 by Trailhead Tessie
Feb 26, 2019 6:37am
Board
Happy to help. :)
Re: How to download find logbook
Board: Letterboxing Help Desk
Reply to: #972177 by photopam
Feb 26, 2019 1:57pm
Board
Another question: I'm getting more traditional finds listed on the downloaded spreadsheets than what AQ is showing online. For example, the downloaded spreadsheet shows 3574 traditional AQ finds, while the online AQ logbook shows 3143 traditionals. So I have 431 too many listings on the downloaded version, and that's just the AQ finds. Looking through the listings, it does look like a few have doubled up, although it doesn't seem like there are over 400 doubles. Any ideas? I used both Excel and Google Doc and the results are identical.
Re: How to download find logbook
Board: Letterboxing Help Desk
Reply to: #972183 by Trailhead Tessie
Feb 26, 2019 3:32pm
Board
It seems as though the "Finds" download is also including some set of "Plants"... IF you are also a finder. In other words, if you are one of the contributors to a plant (carver, planter) that you have also technically "Found", then it won't show up on "Finds" on your logbook, but it WILL show up in the downloaded list. I'm not really sure if that is a bug or not, or just an artifact of the differences in the purposes of these lists. Also, I see that in the downloaded version, there can be MULTIPLE lines of the same box, if (as in the case listed above) there are multiple "Planters" as well.

Case in point, at least for me, was the "Everybody Do A Line" box from LBCon... https://www.atlasquest.com/showinfo.php?boxId=121150

I am one of the "Planters", because it was (literally) a whole bunch of us doing a line on a stamp. So it shows up in the download list a bunch of times for me, but does NOT show up in my "Finds" in the logbook.

Ryan is going to have spotty connectivity over the next few...day? weeks? Who knows... but I think once he is back he will be able to either confirm this as expected, or tweak it so it is more in line with what he intended.

I think, in general, most AQers have no idea just how complex a database this is... it ISN'T just one big spreadsheet-like blob... there are MANY DOZENS of individual tables (collections of similar info) that all need to be linked together, so something that SEEMS simple ("a list of my finds") actually involves pulling together data from, say, 6 or more tables. And the more stuff that needs to be linked together, the more complex the queries become, and the longer the queries take. The timing increases somewhat exponentially as an individual's logbook grows, as well. So a logbook with 10,000 entries can take FAR longer than 10x a logbook with 1,000 entries. AQ has to handle both... and not just for an individual. There are often MANY MANY queries running on AQ simultaneously, and if one query is time-consuming, it can mean EVERYONE is experiencing that lag (seemingly for "no reason").

Large-database system management and optimization is more an art than a science (well, a hefty combination of both, actually), and as one who deals with this sort of thing at work on a daily basis, I can tell you from experience, Ryan has done an AMAZING job of juggling the diverse needs of a diverse community!

Oh crap, did I just say something nice about Ryan? Hmmm.... pretend I didn't say anything, I don't want it going to his head...
Re: How to download find logbook
Board: Letterboxing Help Desk
Reply to: #972186 by wassamatta u
Feb 26, 2019 4:03pm
Board
Hey, if anyone wants to start a business where we can maintain an online logbook that includes ALL of our finds, including the dates found, location, planter names, and a link to the clues, I would definitely pay an annual fee for that rather than spend a bazillion hours doing that for myself manually for over 3,000 boxes.
Re: How to download find logbook
Board: Letterboxing Help Desk
Reply to: #972186 by wassamatta u
Feb 26, 2019 6:22pm
Board
Oh crap, did I just say something nice about Ryan? Hmmm.... pretend I didn't say anything, I don't want it going to his head...

Just tell him someone hacked into your account. ;-)
Re: How to download find logbook
Board: Letterboxing Help Desk
Reply to: #972186 by wassamatta u
Feb 27, 2019 8:11pm
Board
It seems as though the "Finds" download is also including some set of "Plants"... IF you are also a finder.

Yeah, that's a bug. Tried to fix one bug and managed to introduce another one. There shouldn't ever be multiple lines of the same box just because there are multiple planters.

The problem should be fixed now, though! Which isn't to say I haven't introduced another bug or that one of you eagle-eyed people will spot one that has (so far) been previously undiagnosed.

It's tricky stuff!

-- Ryan
Re: How to download find logbook
Board: Letterboxing Help Desk
Reply to: #972216 by Green Tortuga
Feb 28, 2019 6:19am
Board
I'm getting random found boxes repeated.

At this point I've started to go through the list from the beginning, one by one, adding location, planter, and other info. I think I'm up to box 60. I guess I should have been maintaining my own electronic logbook from the very beginning because it's going to take forever.