Introducing CellarTracker.org (Beta)

[neorunner]

now to just find the motivation to use it and keep it current

I treat it like untappd and throw things on a pick list when I pull them from the cellar, then it's just a quick audit of the fridge to see what didn't get drank before hitting deduct from cellar.

 

[stakem1]

I treat it like untappd and throw things on a pick list when I pull them from the cellar, then it's just a quick audit of the fridge to see what didn't get drank before hitting deduct from cellar.

cursory glance, i like what im seeing. its just that im starting from scratch here...i have zero documentation of my cellar and the idea of manually loading everything is daunting

 

[lambandtunaphish]

cursory glance, i like what im seeing. its just that im starting from scratch here...i have zero documentation of my cellar and the idea of manually loading everything is daunting

One case at a time. Baby steps, stakem. Baby steps.

 

[neorunner]

cursory glance, i like what im seeing. its just that im starting from scratch here...i have zero documentation of my cellar and the idea of manually loading everything is daunting

It's a web portal that can be accessed from multiple devices, invite a couple friends over and attack it. What we did for a friends cellar that is in the 5k bottle range.

 

[trickytunadicky]

cursory glance, i like what im seeing. its just that im starting from scratch here...i have zero documentation of my cellar and the idea of manually loading everything is daunting

Agreed with neorunner. Pay your help in drinking the stuff you find you don't want to be sitting on/entering

 

[JohnfromPurdue]

Signed up, got an email from wckg.net that went to my junk mail, been debating for the last 10 minutes to click the link, not sure if its from cellartracker, on work computer, feeling lucky...

 

[MordorMongo]

Ok I finally signed up but someone explain to a barely functional drunk stoner how to get my google drive doc to magically do this for me.

 

[fear0251]

Signed up, got an email from wckg.net that went to my junk mail, been debating for the last 10 minutes to click the link, not sure if its from cellartracker, on work computer, feeling lucky...

Yea that's my development site, it's safe to click, and let me see why it's doing that.

Edit: Just checked, and I had never reset that particular configuration item from when I promoted to production. Going forward the emails should be from cellartracker.org.

Thank you for letting me know about this problem.

 

[fear0251]

Ok I finally signed up but someone explain to a barely functional drunk stoner how to get my google drive doc to magically do this for me.

Ok, it's not quite magically easy, but here's what you do:
This should probably be done from a computer, as I'm not quite sure how to do this with a mobile device.

A) Create a new Cellar in CellarTracker
A1. Open CellarTracker
A2. From the "My Cellars" page, Create a new cellar.
A3. From the "My Cellars" page, click the Import button for that cellar
A4. Leave this page open, so you can get back here for reference

B) Prepare your google spreadsheet
B1. Open your google spreadsheet.
B2. Make sure the very first row of your spreadsheet has keywords that match the Columns in the "CSV File Format" box on the CellarTracker import page. For example, you should probably have at least a "Brewery" column, and a "Name" column.

C) Export your google spreadsheet.
C1. From the pull down menus in the spreadsheet, click File->Download as->Comma-separated values (.csv, current sheet)
C2. Save the file to your hard drive, and keep track of where you put it.

D) Import your file into CellarTracker
D1. Back on the CellarTracker Import page, click the "Browse..." button, and then select that file you just exported.
D2. Click the "Upload" button.

If everything went well, you should see some results come back that tells you how many rows were updated, and if there were any errors.

Edit: I'm adding this as a FAQ in the application, and I'd appreciate suggestions on how to make this process easier/more clear.

 

[MordorMongo]

Ok, it's not quite magically easy, but here's what you do:
This should probably be done from a computer, as I'm not quite sure how to do this with a mobile device.

A) Create a new Cellar in CellarTracker
A1. Open CellarTracker
A2. From the "My Cellars" page, Create a new cellar.
A3. From the "My Cellars" page, click the Import button for that cellar
A4. Leave this page open, so you can get back here for reference

B) Prepare your google spreadsheet
B1. Open your google spreadsheet.
B2. Make sure the very first row of your spreadsheet has keywords that match the Columns in the "CSV File Format" box on the CellarTracker import page. For example, you should probably have at least a "Brewery" column, and a "Name" column.

C) Export your google spreadsheet.
C1. From the pull down menus in the spreadsheet, click File->Download as->Comma-separated values (.csv, current sheet)
C2. Save the file to your hard drive, and keep track of where you put it.

D) Import your file into CellarTracker
D1. Back on the CellarTracker Import page, click the "Browse..." button, and then select that file you just exported.
D2. Click the "Upload" button.

If everything went well, you should see some results come back that tells you how many rows were updated, and if there were any errors.

Edit: I'm adding this as a FAQ in the application, and I'd appreciate suggestions on how to make this process easier/more clear.

Hahahahahahaha I am very high and that's a hell of a lot of words. I may just wait for our mead bang and let you have at it.


Holy **** that was a lot of words

 

[MordorMongo]

Ok, it's not quite magically easy, but here's what you do:
This should probably be done from a computer, as I'm not quite sure how to do this with a mobile device.

A) Create a new Cellar in CellarTracker
A1. Open CellarTracker
A2. From the "My Cellars" page, Create a new cellar.
A3. From the "My Cellars" page, click the Import button for that cellar
A4. Leave this page open, so you can get back here for reference

B) Prepare your google spreadsheet
B1. Open your google spreadsheet.
B2. Make sure the very first row of your spreadsheet has keywords that match the Columns in the "CSV File Format" box on the CellarTracker import page. For example, you should probably have at least a "Brewery" column, and a "Name" column.

C) Export your google spreadsheet.
C1. From the pull down menus in the spreadsheet, click File->Download as->Comma-separated values (.csv, current sheet)
C2. Save the file to your hard drive, and keep track of where you put it.

D) Import your file into CellarTracker
D1. Back on the CellarTracker Import page, click the "Browse..." button, and then select that file you just exported.
D2. Click the "Upload" button.

If everything went well, you should see some results come back that tells you how many rows were updated, and if there were any errors.

Edit: I'm adding this as a FAQ in the application, and I'd appreciate suggestions on how to make this process easier/more clear.

Import result unsuccessful

 

[MordorMongo]

Also how Dafuk no mead section?

 

[trickytunadicky]

Also how Dafuk no mead section?

If enough people really want a separate mead cellar, we'll build one, but personally I have mine under the beer cellar, and categorize it via BJCP. It can also be done under wine if the mood strikes you.

 

[MordorMongo]

If enough people really want a separate mead cellar, we'll build one, but personally I have mine under the beer cellar, and categorize it via BJCP. It can also be done under wine if the mood strikes you.

I think I vastly ****** all of that up. I've made a mess of your site.

 

[trickytunadicky]

Import result unsuccessful

Read the instructions again when you are sober, then we will try to figure out how to Scottproof them.

 

[MordorMongo]

This is precisely why people like me don't deserve nice things

 

[trickytunadicky]

I think I vastly ****** all of that up. I've made a mess of your site.

You only broke your cellar.

 

[trickytunadicky]

This is precisely why people like me don't deserve nice things

But you have $400 towels and a squatty potty. You deserve all of the finest things.

 

[MordorMongo]

Read the instructions again when you are sober, then we will try to figure out how to Scottproof them.

Oh I created them, just did something horribly wrong. All quantities and sizes are jacked. It's a mess, but it appears the bulk of my (old) data is there....sort of.

 

[MordorMongo]

Welp, now I really have a project on my hands. Thanks Jay and Patty!

 

[PepeSylvia1]

Ok, it's not quite magically easy, but here's what you do:
This should probably be done from a computer, as I'm not quite sure how to do this with a mobile device.

A) Create a new Cellar in CellarTracker
A1. Open CellarTracker
A2. From the "My Cellars" page, Create a new cellar.
A3. From the "My Cellars" page, click the Import button for that cellar
A4. Leave this page open, so you can get back here for reference

B) Prepare your google spreadsheet
B1. Open your google spreadsheet.
B2. Make sure the very first row of your spreadsheet has keywords that match the Columns in the "CSV File Format" box on the CellarTracker import page. For example, you should probably have at least a "Brewery" column, and a "Name" column.

C) Export your google spreadsheet.
C1. From the pull down menus in the spreadsheet, click File->Download as->Comma-separated values (.csv, current sheet)
C2. Save the file to your hard drive, and keep track of where you put it.

D) Import your file into CellarTracker
D1. Back on the CellarTracker Import page, click the "Browse..." button, and then select that file you just exported.
D2. Click the "Upload" button.

If everything went well, you should see some results come back that tells you how many rows were updated, and if there were any errors.

Edit: I'm adding this as a FAQ in the application, and I'd appreciate suggestions on how to make this process easier/more clear.

I think a template .csv file, with all the headings, and correct format etc.. already set would help make the process easier for non techies. I find it easier to input into excel when starting fresh rather than using most sites UI, or for the folks with google doc's just copy and paste each column to the correct one on the template, then upload.

 

[neorunner]

We need a squatty potty owners group.

 

[trickytunadicky]

We need a squatty potty owners group.

You know how to start a thread.

EDIT: Isn't RTT the unofficial posts about poops thread already?

 

[fear0251]

I think a template .csv file, with all the headings, and correct format etc.. already set would help make the process easier for non techies. I find it easier to input into excel when starting fresh rather than using most sites UI, or for the folks with google doc's just copy and paste each column to the correct one on the template, then upload.

Thanks for the suggestion!

I've gone ahead and added an empty CSV file for each type of import. It's on the Import page inside the "CSV File Example" box.

 

[BigToad22]

Looks interesting

 

[BingoBango]

Hey PurityControl88 not sure if you saw this yet, but this is the thing I told you about that I signed up for because it looked good but I've been too lazy to actually use yet.

 

[drbenzo1]

I'm terrible at cellar tracking... Created an account but I end up cellar raiding and forgetting to update... I'll give it a try

 

[EverybodyLovesRainman]

IN


now I just need to find someone to add all my stuffs

I'm just going to pay some high school nerds a couple beers to input all my info.
Capitalism in the purest form.

 

[mateoloco]

I'm just going to pay some high school nerds a couple beers to input all my info.
Capitalism in the purest form.

Is this you EverybodyLovesRainman?

I've seriously fallen behind on my Untapped checkins and I feel it may affect the outlook of the beer community on my person. I'm asking for the help of an individual or individuals to input my beer consumption into untapped over the last several months. My last checkin was November 20th, I have photos of most of the beers I've drank since then and will be available 24/7 to guide you when you're not sure if I drank a beer or not. This isn't an easy task by any means so I understand if you enlist the help of several others. I can't do this on my own, you're my only hope.

 

[EverybodyLovesRainman]

Is this you EverybodyLovesRainman?

http://www.beeradvocate.com/beer/profile/1471/45073/