Oh my goodness. That pairs nicely with the TravelingHomeschoolers fall trips…! Problem is it doesn’t jive with DD’s dual enrollment classes. Blasted these school schedules!
These are interesting listings: the under median % is not giant, but for CC you really don’t see that many prices further away below median. Last year we did see some for March, but we’re talking 4 listings. In June there were more, but still not many.
Based on when those all appeared I’d say it is 95% unlikely to see a lower March CC price show up. For June - we’ll probably see some, but they’ll appear in the 45-70 days out range and be very limited in number.
2-night CC Studio 03/13 for $420/night or 5% under median
When you copy a Dropbox shared link, it’s usually a viewer URL on www.dropbox.com. That URL often does not directly serve the CSV bytes. Instead, Dropbox commonly replies with an HTTP redirect (301/302/303) to wherever the actual file can be downloaded from at that moment.
So the flow is basically:
Your tool requests: https://www.dropbox.com/s/.../data.csv?dl=0 (or raw=1, etc.)
Dropbox replies: 302 Found + a Location: ... header pointing somewhere else (sometimes a different Dropbox URL)
After one or more hops, you frequently end up at something like: https://dl.dropboxusercontent.com/... and that final URL is a more “direct file” endpoint.
Some apps/plugins do an extra thing after following redirects by saying, “Oh cool, this final URL must be the real source” and they save that final redirected URL back into their settings/DB as the new “source.” Those redirect URLs are often temporary. So you get this loop:
Day 1: wpDataTables imports fine using the shared link → follows redirect → ends up at a direct dropboxusercontent URL → stores that.
Day 2: wpDataTables tries to fetch using the stored dropboxusercontent URL → it’s expired → fetch fails → table breaks.
Day 3: something triggers a “refresh/reconnect/rebuild” using the original shared link again (or you manually re-save it) → it follows redirects again → gets a new working temporary direct URL → table “magically” works again… until it expires.
That matches the “how did it resolve itself?” question: Some refresh/import path likely regenerated a fresh direct link, even though you didn’t consciously change anything, and these temp URLs don’t have exact times of expiration, so it’d be tough to nail down.
A quick way to confirm it’s wpDataTables:
Put the stable Dropbox shared link back in the wpDataTables settings (the dropbox.com/... one).
Click whatever wpDataTables uses to refresh / rebuild / re-import the table.
Immediately check the DB value again in phpMyAdmin.
If it flips to dl.dropboxusercontent.com/... right after a refresh it’s almost certainly wpDataTables doing it.
Another alternative is bandwidth limits. Dropbox Basic allows for up to 20GB and 100k downloads per day. I’m sure you’re nowhere near the downloads limit and you likely aren’t at the 20GB limit with just a CSV, but I figured I’d mention it just in case.
Thanks! I’ll have to read through your message again to make sure I’m getting what you are saying, but when I checked the URL stored in phpMyAdmin yesterday it was indeed the original dropbox link I entered a few months ago and not a different one.
After I installed the plugin I realized that when creating a wpdatatable using a shared csv file, it doesn’t go out and grab the data to create a local table, it uses that shared URL each page load to go out and load the data into the browser. (Which is why my main page is clunkier than I like.)
I’ve been planning to script up an alternate method to pull my shared file into a local table on my server to speed up that load time.I tested that with a table I imported manually and it was much zippier.
That tactic would also have the benefit of far fewer hits to my shared dropbox file as more users use the search engine. But, my active data file for the search is only 748k, so I’m probably good for awhile.
Here are all the 7-night or longer GF studios for all dates - as you can see, rare to see in December at any price, extremely rare below the median line.
For Riviera studios, in December at least - the majority of below median listings appear right around 11 months, so time’s a-wastin’! Not very many Riv studios priced lower than this in that month.
4-night Riviera Studio 12/15 for $455/night or 19% under median
I always wonder if someone with zero context and is just looking for a room somehow ends up paying the asking price for one of these listings just because they don’t know it is a bad deal.
We’ve been that week and have seen guest in the parks after their ash blessing. I wonder if they do that on property somewhere. They have drive thru services here.