While I haven't posted very much in this particular forum, I am fairly active elsewhere on the site (what up RTT and Burger Concoctions folks?) Some of you may know that I have an extensive cellar for which I have been actively developing software to manage. I'm happy to announce that my homegrown cellar tracking web application is ready for beta testing. If this is something you might be interested in, I'd love your help in finding bugs, and figuring out new features to add. You can access it at http://cellartracker.org My plan is to keep this site free of charge to all users for basic functionality. Eventually I may add premium features, or ads, in order to help me pay for hosting costs. Features Include: Tracking of different types of cellars: Beer, Glassware, Wine, Spirits. Import/Export from CSV (Comma Separated Value) files. Picklist Functionality Customizable Views Customizable consume-by algorithyms Sharing of Cellars with other users Planned Features: Email reminder notifications when consume-by dates have occurred Barcode input I look forward to your feedback!
Dig it a lot -- great performance. Best I've played with. Would love to be able to add a beer direct from the inventory views; gets hard to remember what I haven't added.
I'm not sure how easy it would be to add a beer directly in that view, but if it helps, you can click "Cellars->New Beer" in the Pull Down menus to quickly get to the new beer page.
If you have it in a spreadsheet already, it's not too hard to do. EDIT: I'll be using this information to make requests for future mead tastings. ;-)
So... importing CSV. tells me import is successful and counts rows properly, but doesn't appear to actually load anything into the cellar. EDIT: Data is making it in there somehow, because when I go to manually add a beer, I see all of my locations/etc. prepopulating the dropdowns.. The beers just don't show up.
Emailed you. Looks like I can upload to glassware just fine, with a file that looks like just my beer file. Very odd
It looks like CellarTracker wanted an ABV on those beers. It should work now, and just default to 0 on stuff it doesn't recognize.
Do you have a template .csv file for download? I didn't see one available... But also looking from my phone.
We give a quick example without all of the available fields on that page under "CSV File Example". It's not a downloadable example, but you can copy and paste it into a file: Here is an example of a CSV file with a header row and 3 entries. Note, the Cellar Style chosen here was "BJCP 2015". "Brewery","Name","Vintage","Style","Size","Location","Purchased Date" "Founders","Imperial Stout","2011","13F. Russian Imperial Stout","12 oz","Box 1","10/31/2011" "Hair of the Dog","Fred","Batch 78","19C. American Barleywine","12 oz","Fridge","12/9/2010" "Cantillon","Saint Lamvinus","2007","17F. Fruit Lambic","750 ml","Shelf 2","12/31/2007"