Skip to Content
Register · Login
About Theme

A Letterboxing Community

Search Edit Search

Read Thread: Logbook Tweak

Logbook Tweak
Board: Atlas Quest Announcements
Feb 17, 2019 6:13pm
Board
So I tweaked the logbook again, and those of you who want to search for specific boxes but can't remember the names.... I added a search option to filter results based on the start of the box name.

But... there are compromises which you may or may not like. My goal is to keep the queries running fast, after all. You nudge something in one place, and it pokes out in other places.

To keep the queries running fast, AQ no longer pre-sorts the results before limiting them, so if you have 1000 finds (for instance) and sort them alphabetically, they don't stop at the M's (or whatever is halfway through your list). It more-or-less randomly displays any 500 boxes of the total number of matches like the regular search does. You'll have to narrow down your results if you're looking for a specific box.

I also renamed the "500 limit" to "all" years since that appeared to cause some confusion. There's still a limit, though. That hasn't changed.

And I added limits to all possible search results. It might be your logbook, but it acts more like a search now. Because, based on the feedback I got, people seem to prefer using it as another search option rather than an actual logbook. So I went ahead and changed the code to be more.... search-friendly.

So in a nutshell, it works more like a regular search. Which, for those of you who wanted your logbook to be searchable--will probably like. For those of you who prefer your logbook being a logbook.... you probably won't. And I'm sorry for that.

-- Ryan
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971666 by Green Tortuga
Feb 17, 2019 6:24pm
Board
I was very happy with things the way they were. Being fast is not always being best. Just my humble opinion.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971668 by Acorns4u
Feb 17, 2019 6:30pm
Board
Being fast is not always being best.

You say that now, but if AQ took 10 seconds to load every page, you'd probably find it very annoying. It wasn't that bad--but I'm not going to wait until it's so bad that people complain before doing something about it either.

I'm not trying to make queries that take 1/10th of a second run in 1/100th of a second that nobody would even notice. I'm fixing the queries that take several seconds to run. And in the worst case, these tended to range from about 10 to 13 seconds. That's not acceptable. Any query that takes more than about 1 second to run gets a hard look by me, but 10+ seconds? It had to go.

-- Ryan
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971669 by Green Tortuga
Feb 17, 2019 6:47pm
Board
My problem is that there is still no way to see the entire list of finds in the logbook or search. I tried the advanced search but it only shows 2500, and I'm assuming those are random. I think that the biggest complaint was that we couldn't sort (not search) and see our whole list of finds anymore, but I might be wrong. We can sort by newest, oldest, owner ... but if you can't see the whole list, and you're getting random results, then what is the point of sorting? I'm really not trying to be difficult and do appreciate you trying to please all of us.

Example: In my logbook, LTCs, I set it to search all by newest first. The first LTCs it shows are from 2017, so I miss 2018 and 2019 completely.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971670 by Topcollector
Feb 17, 2019 7:05pm
Board
My problem is that there is still no way to see the entire list of finds in the logbook or search.

It seems like there's a couple of things going on here. One is being able to search for a particular box one has found. Another is being able to see the complete list of one's finds.

Regarding the second thing, it used to be that your plants and finds were displayed in order, 100 per page, and you could get a complete list by going through the pages. Now they're displayed by year. If you have fewer than 500 finds in a year, you'll get the complete list for that year, but if you exceeded 500 finds you won't.

For my own logbook finds I've only got one year, where I exceeded 500, 2018 with 503. I was just looking at that, and it made me feel a little uncomfortable. All but 3 of my finds for the year were showing, but which 3 weren't? The first 3? The last 3? Some random 3? I wouldn't know how to search for them because I wouldn't know what I was missing (unless I checked my paper logbooks).

Would it be possible to add a month field next to the year field to help with the logbook display? Most people don't exceed 500 finds in a month, although I know some people do.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971670 by Topcollector
Feb 17, 2019 7:29pm
Board
GT wrote:
That's not acceptable. Any query that takes more than about 1 second to run gets a hard look by me, but 10+ seconds? It had to go.

Topcollector wrote:
My problem is that there is still no way to see the entire list of finds in the logbook or search. I tried the advanced search but it only shows 2500, and I'm assuming those are random.

What is done on another geolocation game (that shall remain nameless) is that the list of all your finds (with logs) can be run once every three days. A request to generate this list can be queued. Once completed this query is ready to download. The results of the query are available for download for a week. If a query is queued again the results replace the previous results of the query.

Perhaps this is a compromise that can be done. Other numbers can be used here, probably lengthening the time between queries.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971672 by Dawnkey
Feb 17, 2019 8:01pm
Board
Now they're displayed by year. If you have fewer than 500 finds in a year, you'll get the complete list for that year, but if you exceeded 500 finds you won't.

Actually, my original version did show all of the finds from that year. It wasn't ideal (some people have a few thousand finds in a single year) which is still a rather slow query (and possibly a very long-loading page), but at least there was an actual limit in the form of the end of the year.

Now that there's an additional way to narrow down searches, there's less need to depend solely on the year to filter results, so I added same 500 box limit that the "all years" option had to everything. The queries run faster.

Would it be possible to add a month field next to the year field to help with the logbook display?

I'm going to wait on this idea. At that point, I'd rather just let people put a "start date" and "end date" and include up to 500 boxes between the two because some people could invariably prefer to see an entire year, others might want to see a specific month or week or whatever. Maybe that's the better option.

-- Ryan
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971674 by Oberon_Kenobi
Feb 17, 2019 8:09pm
Board
What is done on another geolocation game (that shall remain nameless) is that the list of all your finds (with logs) can be run once every three days.

That's actually very interesting. So apparently they've run into the same problem AQ has been having. That's a surprising "fix" to the problem, though. I wouldn't have thought of that idea in a million years.

A request to generate this list can be queued. Once completed this query is ready to download.

If you just want to download an entire list of your finds, I already did that. Check the bottom of your profile page. =) No queue necessary! No wait needed!

Generating a long list like that that doesn't require sorting and processing.... it runs pretty fast. All these features people want on their logbooks.... it slows things down a lot. So the download is very basic, bare-bones stuff--but it's a complete list of plants, finds and attempts. I'll probably add some other options in the future (carves, donations, owned, etc.) but those hadn't been as much of a priority for me.

-- Ryan
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971666 by Green Tortuga
Feb 17, 2019 8:17pm
Board
I also renamed the "500 limit" to "all" years since that appeared to cause some confusion. There's still a limit, though. That hasn't changed.

Is there a way that you could have a setting to change the default view to the most current year rather than all? Or even better if you could add a setting that people could set the default view however they prefer?
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971676 by Green Tortuga
Feb 17, 2019 8:28pm
Board
If you just want to download an entire list of your finds, I already did that. Check the bottom of your profile page. =) No queue necessary! No wait needed!

Ah, didn’t know that existed! I don’t scroll past my “interview”.

AND, That’s the most comforting thing I’ve read concerning the on-line logbook. As long as I can access the complete list somewhere, I’m happy. For info on my individual finds, I will continue to use the search options available in the Letterboxes dropdown.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971675 by Green Tortuga
Feb 18, 2019 3:56am
Board
I'd rather just let people put a "start date" and "end date" and include up to 500 boxes between the two because some people could invariably prefer to see an entire year, others might want to see a specific month or week or whatever. Maybe that's the better option.

I like the date range idea.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971676 by Green Tortuga
Feb 18, 2019 5:51am
Board
It doesn't download into any recognizable organization on my computer, just what appears to be an AQ #, a name and hashtags. It's all finds, no matter LTC, traditional ... No dates. I can't figure out how that would be useable.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971689 by Topcollector
Feb 18, 2019 7:16am
Board
Strange. I see type of box and dates on my iPad. I haven’t gone on my computer yet to experiment.

I do know that if you have columns that are too narrow, sometimes the info in the columns will show as hash tags. Try increasing your spreadsheet column widths. If all that works out, you then should be able to sort by type of box, etc.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971704 by JampersandJ
Feb 18, 2019 8:24am
Board
I really, really hate to say anything that sounds like a complaint because this web site is a fantastic service for a ridiculously low price (even for premium membership), and we appreciate it so much.

I do, however, find it a bit frustrating to have to export logbook items to a spreadsheet to be able to view them all as we could before the big change.

Items in my logbook are numbered in Safari on my iPhone and iPad, but not on my MacBook Air, even though all are using Safari. No amount of refreshing the page on the Mac has changed that. Weird...

Thanks, GT, for all you do to keep AQ running smoothly.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971711 by Road Junkies
Feb 18, 2019 2:50pm
Board
I was happy with the logbook the way it functioned before the update, both in using it and how fast it loaded. It loaded in a speedy manner and was simple, easy and logical to use. I thought it was just fine and dandy.

MM
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971676 by Green Tortuga
Feb 18, 2019 4:24pm
Board
The change I wanted isn’t addressed. I wanted to be able to sort my traditional finds by state without having to compose some sort of search.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971741 by Baqash
Feb 18, 2019 8:02pm
Board
The change I wanted isn’t addressed.

You can download your finds into a spreadsheet and sort them however you want. The downloads do include location information so sorting by state is possible.

-- Ryan
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971741 by Baqash
Feb 18, 2019 9:50pm
Board
It just occurred to me.... maybe you'll find your stats page useful. It has a list of all the states you found boxes and when you click on them, pulls up the list of all the boxes in that state.

(Premium member perk!)

-- Ryan
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971754 by Green Tortuga
Feb 19, 2019 2:21am
Board
Never knew they were clickable. Thanks that works
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971752 by Green Tortuga
Feb 19, 2019 2:33am
Board
Downloading g and sorting works if you are on a computer. Phone not so much
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971666 by Green Tortuga
Feb 19, 2019 6:27am
Board
Ryan, I apologize in advance if you've already addressed this elsewhere. When I go to my logbook and select Finds/Traditional/All/Newest, the resulting boxes are definitely not the newest boxes. Any ideas?
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971711 by Road Junkies
Feb 19, 2019 6:38am
Board
Not sure whether anything changed at AQ or my pages refreshed enough times, but suddenly this morning my logbook is numbered in Safari on the Mac. Yay!
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971766 by Rocklun
Feb 21, 2019 3:55pm
Board
More on the logbook tweak...

I also appreciate this website and all it does to make letterboxing enjoyable and the way it helps me manage my plants and finds. It brings me joy.

I've been following this thread and hoped to have my questions answered about the logbook layout. But up to this point, I haven't seen anything that directly speaks to what's going on in my logbook. Like Rocklun mentioned, my finds do not seem to be listing in the order selected. If I choose TRADITIONAL-2019-NEWEST, my 5 latest finds don't show up at the top or anywhere in the list. I do have over 500 finds in 2019, so I'm guessing that's part of the problem.

I've gone back and looked at 2018 Finds (TRADITIONAL-2018-NEWEST). I'm seeing the same thing. 500 boxes are listed, but then random boxes will not be there. For example, on December 1, I found several more boxes than what show up in the listing.

And, lastly...the spreadsheet. Thank you. It is good to have a spot where all the boxes can be. For me, it would be helpful to have a little spreadsheet lesson (since I've used them minimally). The list downloads by box number, smallest to largest. How would I order the downloaded spreadsheet in date found order?

This is such a good website and I've spent many enjoyable hours solving mystery locations, planning trips, decoding ciphers, and digging deeper into the website to learn more about it. So it's a ton of fun and I appreciate it.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971905 by Angel Winks
Feb 21, 2019 10:04pm
Board
I wish it would have an "all" instead of traditional/hh/cootie/LTC/event/ect
When I am searching other people's logs (just attended event and I can't find AQ# for a find) they aren't listed even though their logbooks are public.... you have to choose type of stamp (and ironically for this event many of the stamps are showing up traditional instead of event so I am having trouble finding them!)
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971905 by Angel Winks
Feb 22, 2019 12:48am
Board
...the spreadsheet. Thank you. It is good to have a spot where all the boxes can be. For me, it would be helpful to have a little spreadsheet lesson (since I've used them minimally). The list downloads by box number, smallest to largest. How would I order the downloaded spreadsheet in date found order?

To change the order of the data, select “data” and then “sort.” Typically you can sort by any of the categories listed in the "header row."
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971905 by Angel Winks
Feb 22, 2019 12:56am
Board
I do have over 500 finds in 2019...

We're not even two full months into 2019 yet!
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971919 by roo
Feb 22, 2019 5:51am
Board
Thank you, roo! That's all I needed. It worked perfectly.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971920 by Kirbert
Feb 22, 2019 5:54am
Board
I know...kind of crazy, right?

But I can only blame mudflinginfools and Teacup. I went to their Final Flight event in January and there were well over 400 traditional letterboxes. Wowza! Then letterboxing luck was with us...the weather was lovely and we were able to spend a couple of days looking for traditional finds in the area. It was a great way to start 2019, especially because we came home to the polar vortex and all the winter storms we've had in Michigan since.
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971905 by Angel Winks
Feb 22, 2019 6:05am
Board
I do have over 500 finds in 2019, so I'm guessing that's part of the problem.

Yes, that's definitely part of the problem. AQ just promises to return 500 boxes that match your search--it makes no guarantees about which 500 boxes.

The logbook works more like a search than an actual log.

-- Ryan
Re: Logbook Tweak
Board: Atlas Quest Announcements
Reply to: #971932 by Green Tortuga
Feb 22, 2019 6:09am
Board
Ryan, thank you. I was hoping there would be a way for me to fix that, but que sera sera.

This tells me I am going to get to know spreadsheets much better. Learning something new is almost never a bad thing. Thank you, again.