• Please visit and share your knowledge at our sister communities:
  • If you have not, please join our official Homebrewing Facebook Group!

    Homebrewing Facebook Group

Introducing CellarTracker.org (Beta)

Homebrew Talk

Help Support Homebrew Talk:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
lIZYYfU.gif


New feature: Charting

It's limited to a few predetermined charts right now, just bar charts of Breweries and Styles.
 
I created a new cellar with "Misc Style 1", I believe it was called. I wanted to see how it all looked, but was too lazy to get up and go to my cellar so I looked around, spotted a 4-pack of Aquanaut Misterioso on the kitchen counter, and tried manually entering it.

I went to my cellar and clicked New Item. Both the brewery and the beer popped up in the dropdowns and, when I chose them, autopopulated some of the fields. However, I disagreed with a couple of the values (I wanted to call it an American Porter instead of an English Porter, and Aquanaut reports the ABV as 6.0 rather than 6.20 both on their site and on the can), so I manually updated them. Then I added the description from the brewery's website in the rich text Comments field, scrolled to the top, and clicked Save.

I was taken to the URL https://cellartracker.org/item/save which threw a 403 error:

Forbidden
You don't have permission to access /item/save on this server.​

On a side note, have you considered putting a Save button at the bottom of the New Item screen?

I look forward to giving this a shot!
 
I created a new cellar with "Misc Style 1", I believe it was called. I wanted to see how it all looked, but was too lazy to get up and go to my cellar so I looked around, spotted a 4-pack of Aquanaut Misterioso on the kitchen counter, and tried manually entering it.

I went to my cellar and clicked New Item. Both the brewery and the beer popped up in the dropdowns and, when I chose them, autopopulated some of the fields. However, I disagreed with a couple of the values (I wanted to call it an American Porter instead of an English Porter, and Aquanaut reports the ABV as 6.0 rather than 6.20 both on their site and on the can), so I manually updated them. Then I added the description from the brewery's website in the rich text Comments field, scrolled to the top, and clicked Save.

I was taken to the URL https://cellartracker.org/item/save which threw a 403 error:

Forbidden
You don't have permission to access /item/save on this server.​

On a side note, have you considered putting a Save button at the bottom of the New Item screen?

I look forward to giving this a shot!

Thanks for the bug report, there is some pretty hefty security that is loaded on the site, and I'm still getting some false positives. Please try again, and see if it goes through this time.

Currently, the site gets a lot of it's data from http://brewerydb.com , which is probably where that ABV of 6.0 vs 6.2 is coming from. Eventually we'd like to have a way to submit updated data back to that system, but there's nothing like that in place.

Thanks for the feedback on the save button location, that's a very good idea.

Also, while the comments field can be used for a description of the beer, after you've saved the item for the first time, you should see another place to put description and images (on the right hand side of the screen if on a pc, or below if mobile). Those descriptions are automatically being loaded from brewerydb when available, but you can also submit a description there yourself if it's blank or needs to be updated.

We really appreciate your feedback!
 
Thanks for the bug report, there is some pretty hefty security that is loaded on the site, and I'm still getting some false positives. Please try again, and see if it goes through this time.

Currently, the site gets a lot of it's data from http://brewerydb.com , which is probably where that ABV of 6.0 vs 6.2 is coming from. Eventually we'd like to have a way to submit updated data back to that system, but there's nothing like that in place.

Thanks for the feedback on the save button location, that's a very good idea.

Also, while the comments field can be used for a description of the beer, after you've saved the item for the first time, you should see another place to put description and images (on the right hand side of the screen if on a pc, or below if mobile). Those descriptions are automatically being loaded from brewerydb when available, but you can also submit a description there yourself if it's blank or needs to be updated.

We really appreciate your feedback!
Yep, it went through this time with no problems. Also, good heads up on the description/image fields...I actually like that better, because I can enter the bare minimum initially and then fill things in as needed. However, the brewerydb description & image were pretty darn good for Misterioso (matched what was on the brewery's site), so I didn't have to make any updates.

Thanks for the response & fix!
 
Update 3/4/2016
Bug fixed: Move items between picklists now working again
Enhancement: Link URLs moved to tabbed section of the item page, to better reflect their shared nature.
Enhancement: brewerydb.com link added to URL section whenever it is present
 
after just loading my cellar sheet in the thing that bothers me straight away is that beer name is to left of brewery since I got the other way around in my cellar sheet
 
after just loading my cellar sheet in the thing that bothers me straight away is that beer name is to left of brewery since I got the other way around in my cellar sheet
Views are customizable so you can arrange the columns in the order that best suits you. On the Cellars screen, select the cellar you want to manage, select Edit, Views, then the view you wish to change and view columns. From there you can arrange columns in whichever order you wish. At any time you can make rearrangements or restore defaults.
 
While I can attest that a medium rare steak and Raison D'Extra is fantastic, I'd be curious to see the breakdown of your DFH cellar as I'm assuming some of it might be cellar casualties.
In order: D'Extra, Olde School, 120 Min, Immort and a few stragglers I probably don't need to be sitting on.
 
me again whith question or anoying suggestions. is there a setting to have all the sizes in ml instead some in ml and some in oz?

here comes my rant about like cellarhq it becomes to centered on american thinking
I give you props that you allow letters from scandinavian languages something that took cellerhq some time
 
me again whith question or anoying suggestions. is there a setting to have all the sizes in ml instead some in ml and some in oz?

here comes my rant about like cellarhq it becomes to centered on american thinking
I give you props that you allow letters from scandinavian languages something that took cellerhq some time
The goal is to have it be as user friendly as possible. The US has some goofy labeling laws when it comes to booze (beer can be in oz, and typically is, but wine of any kind, including mead must be in mL), so we are open to maintaining both as needed. To make it more usable for everyone, the database does learn, so if there is a size you need that you don't see, you should be able to type it in instead of selecting from the list.
 
The goal is to have it be as user friendly as possible. The US has some goofy labeling laws when it comes to booze (beer can be in oz, and typically is, but wine of any kind, including mead must be in mL), so we are open to maintaining both as needed. To make it more usable for everyone, the database does learn, so if there is a size you need that you don't see, you should be able to type it in instead of selecting from the list.
it´s just that in spread sheet I uploaded everything was in ml but the site then changed it oz on the 355 and 650 ml to Oz instead
 
it´s just that in spread sheet I uploaded everything was in ml but the site then changed it oz on the 355 and 650 ml to Oz instead

When a size that is not listed is imported, we set it to a default of 22 oz. We can go ahead and add 355ml and 650ml sizes to the size list, which should allow those sizes to be imported.
 
When a size that is not listed is imported, we set it to a default of 22 oz. We can go ahead and add 355ml and 650ml sizes to the size list, which should allow those sizes to be imported.

thanks, is just the ocd in my head that gets bugged by it being in to diffrent systems
 
Okay finally turned my first closet of beers into a spreadsheet. Just one question: how do I share the list with people who don't have an account (i.e. for my profile here)? Thanks for your hard work!
 
Okay finally turned my first closet of beers into a spreadsheet. Just one question: how do I share the list with people who don't have an account (i.e. for my profile here)? Thanks for your hard work!
It is currently in development, and at the top of the to do list (aside from any bugs that pop up hindering immediate usage, of course). In the mean time you can export to CSV and load to Google Docs.
 
Sharing your cellar is now available for beta testing, and with that we have also launched an alternate URL for the site: haveuseenmycellar.com

Here are some quick instructions on how to make your cellar publicly available to anonymous users.
Step 1: Log into the application and navigate to "My Cellars"
Step 2: Click "Edit" on the cellar you would like to share.
Step 3: Click the "Access Control" tab.
Step 4: Under the "Anonymous Access" section change the setting to yes.
Step 5: You will see the "Include in Public Directory" field come up. Click "yes" if you want your cellar to be publicly browsable. The default is "no." Recommendation is to keep this setting until Step 7 is complete, then change to "yes" if desired.
Step 6: Click the "Save" button in that section to save your changes.
Step 7: Review the "Anonymous Views" tab to ensure that anonymous users only see the views you want them to see, and make any adjustments accordingly.
Step 8: You may now go back and add your cellar to the Public Directory if desired or use the "link to cellar" information that has now appeared in the "Anonymous Access" section to share the cellar to specific individuals of your choosing via link.
 
Last edited:
Any way to import an existing list from excel?
Thnx in advance

Yes, you basically export your excel file to a .csv file. Once you have created a cellar in the app, click the Import button. It should explain the process pretty clearly. Feel free to ask questions, or give us suggestions!
 
Bar Code Scanning has just been added as a new feature! To try it out, click on "Scan Barcode" in the new item page, then click the button that appears in the new window, and take a picture of the Bar Code.
For now, the Bar Code must be scanned horizontally.
Some items may not be found, but every new Bar Code we add will help to build the database.
 
Bar Code Scanning has just been added as a new feature! To try it out, click on "Scan Barcode" in the new item page, then click the button that appears in the new window, and take a picture of the Bar Code.
For now, the Bar Code must be scanned horizontally.
Some items may not be found, but every new Bar Code we add will help to build the database.
If this is even close to working, I'm ******* excited.
 
If this is even close to working, I'm ******* excited.
It's out there in beta for you to try. So far what I have found is that if it is beer from the store it works pretty alright but if it is special release stuff it has to go in the old fashioned way...but if anyone takes the minute to add a barcode if there is one, the database gets updated for everyone else.
 
It's out there in beta for you to try. So far what I have found is that if it is beer from the store it works pretty alright but if it is special release stuff it has to go in the old fashioned way...but if anyone takes the minute to add a barcode if there is one, the database gets updated for everyone else.

http://img.pandawhale.com/44872-this-is-*******-awesome-mackle-lKia.gif
 
Back
Top