Eric
Posts: 5745
Joined: 10/10/2003
From: Seattle, WA
Status: online
|
DRINKING WINDOWS
In my continued jihad to make drinking window management much richer and more useful, I have fleshed out the wine drilldown by exposing the Availability score as well as a more detailed explanation of how this relates to the drinking window for a wine. I also now expose this as well as the aggregated Drinking window at the wine drilldown level. You can also now update your drinking window and refresh to immediately see how this impact the availability index. Also, if you are the only user with a personal drinking window for a wine, the average community consumption window is suppressed (since it just represents your window). I also made it so that people who are printing barcode labels now have their personal drinking window displayed on the label, and I fixed a small logic error whereby a wine that was OK to start drinking in a year used to say "after 2004" instead of "starting 2004" etc.
IMPROVED REPORTING
(1) The consumption report showing individual bottles now has a column showing the consumption type. This report as well as the monthly/quarterly/yearly summary now can also be filtered by consumption type (for example, to see a list of gifted or returned bottles, traded or sold, restaurant purchases etc.) and the advanced query UI exposes this for both reports.
(2) I finally showed some love to the Vintage report. It now exposes price/valuation totals and supports advanced queries.
(3) The advanced query page now shows a Master varietal dropdown. Note that you can only filter by either this or the varietal but not both. However, the current, lame user interface doesn't prevent you from trying to filter using both.
WEB QUERY
The Excel web query has been sligtly enhanced. Now each row exposes an iWine column. This is useful if you are inhaling these reports into Microsoft Access and doing true database reporting, as now you have something to join on. I also exposed a "Pending Futures" tab to help people track their pending purchases.
FIT AND FINISH
(1) The consumption summary report didn't honor the new setting for showing/hiding prices.
(2) The consumption summary wasn't treating dates properly, so on on-US locales the hyperlinks for months might yield errors or erroneous results.
(3) The http://www.cellartracker.com/phone site wasn't showing the proper list of bottles for a user if the inventory wasn't associated with a purchase.
(4) When I recently rewrote the inventory editing page, I busted the ability to mark a bottle as consumed.
(5) When logging out now I clear out all the search attributes from the CellarTracker cookie.
(6) I made the user listing quite a bit more terse (mostly for my own use to monitor site activity) when it is viewed on a PocketPC/Treo/BlackBerry.
(7) For better maintainability, I dramatically cut back XLQUERY.ASP. No one should see any changes on the surface, but I have dialed this page back to only support what is needed for the current Excel web query.
_____________________________
Cheers!
-Eric LeVine
|
Printable Version
v 2.3.3 release notes - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread